DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on PAY_AC_UTILITY

Line 372: SELECT pay_ac_utility.get_balance_name(pbt.balance_type_id) balance_name

368: AND hoi.organization_id = p_gre_id;
369:
370: -- CURSOR to get state earnings details
371: CURSOR get_state_details (p_state VARCHAR2) IS
372: SELECT pay_ac_utility.get_balance_name(pbt.balance_type_id) balance_name
373: ,pay_ac_utility.get_bal_reporting_name(pbt.balance_type_id) rep_name
374: FROM pay_balance_types pbt,
375: pay_defined_balances pdb,
376: pay_balance_attributes pba,

Line 373: ,pay_ac_utility.get_bal_reporting_name(pbt.balance_type_id) rep_name

369:
370: -- CURSOR to get state earnings details
371: CURSOR get_state_details (p_state VARCHAR2) IS
372: SELECT pay_ac_utility.get_balance_name(pbt.balance_type_id) balance_name
373: ,pay_ac_utility.get_bal_reporting_name(pbt.balance_type_id) rep_name
374: FROM pay_balance_types pbt,
375: pay_defined_balances pdb,
376: pay_balance_attributes pba,
377: pay_bal_attribute_definitions pbad