APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 818: pay_template_core_objects ptco

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
822: and ptco.shadow_object_id = psbt.balance_type_id;

Line 827: -- NTG template does not have record in pay_template_core_objects.

823: --
824: EXCEPTION WHEN NO_DATA_FOUND THEN
825: --
826: -- Is this NTG element?
827: -- NTG template does not have record in pay_template_core_objects.
828: --
829: IF p_ele_calc_rule_code = 'NTG FLT' then
830: select balance_type_id
831: into l_pri_bal_id

Line 846: pay_template_core_objects ptco

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
850: and ptco.shadow_object_id = psbt.balance_type_id;

Line 1171: from pay_template_core_objects ptco

1167: PROCEDURE UPDATE_JD_LEVEL_ON_BALANCE(p_template_id in number) is
1168: --
1169: CURSOR get_balance_type_ids(p_template_id number) IS
1170: select ptco.core_object_id
1171: from pay_template_core_objects ptco
1172: where ptco.template_id = p_template_id
1173: and ptco.core_object_type = 'BT';
1174: --
1175: BEGIN