APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_SHADOW_BALANCE_TYPES

Line 311: l_pri_bal_id NUMBER(9); -- Get from pay_shadow_balance_types

307: l_balance_feed_id NUMBER(9); --
308: l_balance_row_id NUMBER(9); --
309: l_balance_type_id NUMBER(9); --
310:
311: l_pri_bal_id NUMBER(9); -- Get from pay_shadow_balance_types
312: l_hrs_bal_id NUMBER(9):= NULL; -- Get from pay_shadow_balance_types
313: l_exists number(10) := 0;
314:
315: l_ele_repname VARCHAR2(30);

Line 312: l_hrs_bal_id NUMBER(9):= NULL; -- Get from pay_shadow_balance_types

308: l_balance_row_id NUMBER(9); --
309: l_balance_type_id NUMBER(9); --
310:
311: l_pri_bal_id NUMBER(9); -- Get from pay_shadow_balance_types
312: l_hrs_bal_id NUMBER(9):= NULL; -- Get from pay_shadow_balance_types
313: l_exists number(10) := 0;
314:
315: l_ele_repname VARCHAR2(30);
316: l_skip_formula VARCHAR2(80);

Line 817: from pay_shadow_balance_types psbt,

813: --
814: BEGIN
815: select ptco.core_object_id
816: into l_pri_bal_id
817: from pay_shadow_balance_types psbt,
818: pay_template_core_objects ptco
819: where psbt.template_id = l_template_id
820: and psbt.balance_name = p_ele_name
821: and ptco.template_id = psbt.template_id

Line 832: from pay_shadow_balance_types

828: --
829: IF p_ele_calc_rule_code = 'NTG FLT' then
830: select balance_type_id
831: into l_pri_bal_id
832: from pay_shadow_balance_types
833: where template_id = l_template_id
834: and balance_name = p_ele_name;
835: ELSE
836: NULL;

Line 845: from pay_shadow_balance_types psbt,

841: --
842: BEGIN
843: select ptco.core_object_id
844: into l_hrs_bal_id
845: from pay_shadow_balance_types psbt,
846: pay_template_core_objects ptco
847: where psbt.template_id = l_template_id
848: and psbt.balance_name = p_ele_name||' Hours'
849: and ptco.template_id = psbt.template_id