APPS.PQP_EARNINGS_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES
Line 78: FROM pay_shadow_element_types
74: -- cursor to fetch the new element type id
75: --
76: CURSOR c_element (c_ele_name varchar2) is
77: SELECT element_type_id, object_version_number 78: FROM pay_shadow_element_types 79: WHERE template_id = l_template_id
80: AND element_name = c_ele_name;
81: --
82: -- cursor to get the template id