APPS.PQP_GB_STAKEHOLDER_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 114: pay_template_core_objects ptco

110: --
111: CURSOR c5 (c_element_name in varchar2) is
112: SELECT ptco.core_object_id
113: FROM pay_shadow_element_types psbt,
114: pay_template_core_objects ptco
115: WHERE psbt.template_id = l_te_ustrctr_id
116: AND psbt.element_name = c_element_name
117: AND ptco.template_id = psbt.template_id
118: AND ptco.shadow_object_id = psbt.element_type_id

Line 179: pay_template_core_objects ptco

175: --
176: CURSOR c3 (c_object_name in varchar2) is
177: SELECT ptco.core_object_id
178: FROM pay_shadow_balance_types psbt,
179: pay_template_core_objects ptco
180: WHERE psbt.template_id = l_te_ustrctr_id
181: AND psbt.balance_name = c_object_name
182: AND ptco.template_id = psbt.template_id
183: AND ptco.shadow_object_id = psbt.balance_type_id;