DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on PAY_AC_UTILITY

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

385: AND hoi.organization_id = p_gre_id;
386:
387: -- CURSOR to get state earnings details
388: CURSOR get_state_details (p_state VARCHAR2) IS
389: SELECT pay_ac_utility.get_balance_name(pbt.balance_type_id) balance_name
390: ,pay_ac_utility.get_bal_reporting_name(pbt.balance_type_id) rep_name
391: FROM pay_balance_types pbt,
392: pay_defined_balances pdb,
393: pay_balance_attributes pba,

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

386:
387: -- CURSOR to get state earnings details
388: CURSOR get_state_details (p_state VARCHAR2) IS
389: SELECT pay_ac_utility.get_balance_name(pbt.balance_type_id) balance_name
390: ,pay_ac_utility.get_bal_reporting_name(pbt.balance_type_id) rep_name
391: FROM pay_balance_types pbt,
392: pay_defined_balances pdb,
393: pay_balance_attributes pba,
394: pay_bal_attribute_definitions pbad