APPS.PQP_UK_VEHICLE_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 116: FROM pay_element_templates

112: l_proc varchar2(60) := 'pqp_uk_vehicle_template.get_template_id';
113: --
114: CURSOR c4 is
115: SELECT template_id
116: FROM pay_element_templates
117: WHERE template_name = l_template_name
118: AND legislation_code = p_legislation_code
119: AND template_type = 'T'
120: AND business_group_id is NULL;

Line 873: FROM pay_element_templates

869:
870:
871: CURSOR c1 is
872: SELECT template_id
873: FROM pay_element_templates
874: WHERE base_name = p_ele_name
875: AND business_group_id = p_business_group_id
876: AND template_type = 'U';
877: --