APPS.PQP_UK_VEHICLE_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 82: FROM pay_shadow_element_types

78: l_lump t_lump_bal;
79:
80: CURSOR c1 (c_ele_name varchar2) is
81: SELECT element_type_id, object_version_number
82: FROM pay_shadow_element_types
83: WHERE template_id = l_template_id
84: AND element_name = c_ele_name;
85: --
86: -- cursor to fetch the core element id

Line 90: FROM pay_shadow_element_types psbt,

86: -- cursor to fetch the core element id
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