APPS.PQP_GB_STAKEHOLDER_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 133: FROM pay_element_templates

129: l_proc varchar2(61) := g_proc||'get_template_id';
130: --
131: CURSOR c4 is
132: SELECT template_id
133: FROM pay_element_templates
134: WHERE template_name = l_template_name
135: AND legislation_code = p_legislation_code
136: AND template_type = 'T'
137: AND business_group_id is NULL;

Line 529: FROM pay_element_templates

525:
526:
527: CURSOR csr_te_stkhldr IS
528: SELECT template_id
529: FROM pay_element_templates
530: WHERE base_name = p_frm_be_element_name
531: AND business_group_id = p_frm_ctl_business_group_id
532: AND template_type = 'U';
533: --