APPS.PQP_EARNINGS_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 86: FROM pay_element_templates

82: -- cursor to get the template id
83: --
84: CURSOR c_template (l_template_name varchar2) is
85: SELECT template_id
86: FROM pay_element_templates
87: WHERE template_name = l_template_name
88: AND legislation_code = p_legislation_code
89: AND template_type = 'T'
90: AND business_group_id is NULL;