DBA Data[Home] [Help]

APPS.PAY_US_EARNINGS_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 110: FROM pay_shadow_element_types

106: CURSOR c_element(p_ele_name VARCHAR2,
107: p_template_id NUMBER) IS
108: SELECT element_type_id,
109: object_version_number
110: FROM pay_shadow_element_types
111: WHERE element_name = p_ele_name
112: AND template_id = p_template_id;
113: --
114: -- cursor to get the template id