APPS.NTG_EARNINGS_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 72: FROM pay_element_templates

68: -- cursor to get the template id
69: --
70: CURSOR c_template (l_template_name varchar2) IS
71: SELECT template_id
72: FROM pay_element_templates
73: WHERE template_name = l_template_name
74: AND legislation_code = p_legislation_code
75: AND template_type = 'T'
76: AND business_group_id is NULL;

Line 524: FROM pay_element_templates

520: l_proc VARCHAR2(60) := 'ntg_earnings_template.delete_ele_template_objects';
521: --
522: CURSOR c1 is
523: SELECT template_id
524: FROM pay_element_templates
525: WHERE base_name = p_ele_name
526: AND business_group_id + 0 = p_business_group_id
527: AND template_type = 'U';
528: --