DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 612: CURSOR get_balance_attribute (c_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_name%type) IS

608: FROM pay_payroll_actions ppa
609: WHERE ppa.payroll_action_id = c_payroll_Action_id;
610:
611: /* bug 7571001 - added get_balance_attribute cursor to initialize g_attribute_id*/
612: CURSOR get_balance_attribute (c_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_name%type) IS
613: select attribute_id
614: from PAY_BAL_ATTRIBUTE_DEFINITIONS
615: where attribute_name = c_attribute_name
616: ;

Line 614: from PAY_BAL_ATTRIBUTE_DEFINITIONS

610:
611: /* bug 7571001 - added get_balance_attribute cursor to initialize g_attribute_id*/
612: CURSOR get_balance_attribute (c_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_name%type) IS
613: select attribute_id
614: from PAY_BAL_ATTRIBUTE_DEFINITIONS
615: where attribute_name = c_attribute_name
616: ;
617:
618: /*bug8711855 - Modified to fetch defined_balance_ids of Lump Sum E balances*/

Line 2724: ,PAY_BAL_ATTRIBUTE_DEFINITIONS pbad

2720: ,pay_element_entries_f pee
2721: ,pay_run_results prr
2722: ,pay_element_types_f pet
2723: /* below added for bug 7571001 */
2724: ,PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
2725: , PAY_BALANCE_ATTRIBUTES pba
2726: ,pay_defined_balances pdb
2727: ,pay_balance_dimensions pbd
2728: ,PAY_BALANCE_FEEDS_F pbf