DBA Data[Home] [Help]

APPS.PQP_UK_VEHICLE_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 91: pay_template_core_objects ptco

87: --
88: CURSOR c5 (c_element_name in varchar2) is
89: SELECT ptco.core_object_id
90: FROM pay_shadow_element_types psbt,
91: pay_template_core_objects ptco
92: WHERE psbt.template_id = l_template_id
93: AND psbt.element_name = c_element_name
94: AND ptco.template_id = psbt.template_id
95: AND ptco.shadow_object_id = psbt.element_type_id

Line 456: pay_template_core_objects ptco

452: --
453: CURSOR c3 (c_object_name in varchar2) is
454: SELECT ptco.core_object_id
455: FROM pay_shadow_balance_types psbt,
456: pay_template_core_objects ptco
457: WHERE psbt.template_id = l_template_id
458: AND psbt.balance_name = c_object_name
459: AND ptco.template_id = psbt.template_id
460: AND ptco.shadow_object_id = psbt.balance_type_id;