You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    SQL Query to sum the results from multiple pay_balance_view_pkg.get_balance_values function

    in Payroll and Global Payroll Interface (GPI) 2 comments

    Hi Experts,

    This is on Oracle Fusion HCM. Is there a way to sum the results from multiple pay_balance_view_pkg.get_balance_values function? For example, I need the combined results of the following in 1 column:


    table(pay_balance_view_pkg.get_balance_values

    (p_payroll_rel_action_id => pra.payroll_rel_action_id

    ,p_base_balance_name1 => 'Union Dues CNA'

    ,p_database_item_suffix1 => '_REL_PTD'

    )) bal1,

    table(pay_balance_view_pkg.get_balance_values

    (p_payroll_rel_action_id => pra.payroll_rel_action_id

    ,p_base_balance_name1 => 'Union Dues CNA'

    ,p_database_item_suffix1 => '_REL_PTD'

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!