APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 826: pay_template_core_objects ptco

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

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

831: --
832: EXCEPTION WHEN NO_DATA_FOUND THEN
833: --
834: -- Is this NTG element?
835: -- NTG template does not have record in pay_template_core_objects.
836: --
837: IF p_ele_calc_rule_code = 'NTG FLT' then
838: select balance_type_id
839: into l_pri_bal_id

Line 854: pay_template_core_objects ptco

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

Line 1179: from pay_template_core_objects ptco

1175: PROCEDURE UPDATE_JD_LEVEL_ON_BALANCE(p_template_id in number) is
1176: --
1177: CURSOR get_balance_type_ids(p_template_id number) IS
1178: select ptco.core_object_id
1179: from pay_template_core_objects ptco
1180: where ptco.template_id = p_template_id
1181: and ptco.core_object_type = 'BT';
1182: --
1183: BEGIN