APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_SHADOW_BALANCE_TYPES

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

312: l_balance_feed_id NUMBER(9); --
313: l_balance_row_id NUMBER(9); --
314: l_balance_type_id NUMBER(9); --
315:
316: l_pri_bal_id NUMBER(9); -- Get from pay_shadow_balance_types
317: l_hrs_bal_id NUMBER(9):= NULL; -- Get from pay_shadow_balance_types
318: l_exists number(10) := 0;
319:
320: l_ele_repname VARCHAR2(30);

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

313: l_balance_row_id NUMBER(9); --
314: l_balance_type_id NUMBER(9); --
315:
316: l_pri_bal_id NUMBER(9); -- Get from pay_shadow_balance_types
317: l_hrs_bal_id NUMBER(9):= NULL; -- Get from pay_shadow_balance_types
318: l_exists number(10) := 0;
319:
320: l_ele_repname VARCHAR2(30);
321: l_skip_formula VARCHAR2(80);

Line 825: from pay_shadow_balance_types psbt,

821: --
822: BEGIN
823: select ptco.core_object_id
824: into l_pri_bal_id
825: from pay_shadow_balance_types psbt,
826: pay_template_core_objects ptco
827: where psbt.template_id = l_template_id
828: and psbt.balance_name = p_ele_name
829: and ptco.template_id = psbt.template_id

Line 840: from pay_shadow_balance_types

836: --
837: IF p_ele_calc_rule_code = 'NTG FLT' then
838: select balance_type_id
839: into l_pri_bal_id
840: from pay_shadow_balance_types
841: where template_id = l_template_id
842: and balance_name = p_ele_name;
843: ELSE
844: NULL;

Line 853: from pay_shadow_balance_types psbt,

849: --
850: BEGIN
851: select ptco.core_object_id
852: into l_hrs_bal_id
853: from pay_shadow_balance_types psbt,
854: pay_template_core_objects ptco
855: where psbt.template_id = l_template_id
856: and psbt.balance_name = p_ele_name||' Hours'
857: and ptco.template_id = psbt.template_id