APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 115: l_source_template_id pay_element_templates.template_id%TYPE;

111: l_template_id pay_shadow_element_types.template_id%TYPE;
112: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
113: l_base_fwc_element_type_id pay_template_core_objects.core_object_id%TYPE;
114: l_base_fwc_element_type_id_fix pay_template_core_objects.core_object_id%TYPE;
115: l_source_template_id pay_element_templates.template_id%TYPE;
116: l_object_version_number pay_element_types_f.object_version_number%TYPE;
117: l_proc_name VARCHAR2 (80)
118: := g_proc_name
119: || 'create_user_template_low';

Line 191: l_format_base_name pay_element_templates.base_name%TYPE

187: l_standard_link VARCHAR2 (1) := NVL (
188: p_standard_link
189: ,'N'
190: );
191: l_format_base_name pay_element_templates.base_name%TYPE
192: := UPPER (TRANSLATE (TRIM (p_ele_base_name), ' ', '_'));
193: l_ees_cont_formula ff_formulas_f.formula_name%TYPE
194: := l_format_base_name
195: || '_EES_'

Line 260: FROM pay_element_templates

256: -- Cursor to check unique base name
257: CURSOR csr_chk_uniq_base_name
258: IS
259: SELECT 'X'
260: FROM pay_element_templates
261: WHERE template_name = g_template_name
262: AND business_group_id = p_business_group_id
263: AND template_type = 'U'
264: AND UPPER (base_name) = UPPER (p_ele_base_name);

Line 285: FROM pay_element_templates

281: --
282: CURSOR csr_get_temp_id
283: IS
284: SELECT template_id
285: FROM pay_element_templates
286: WHERE template_name = g_template_name
287: AND legislation_code = p_legislation_code
288: AND template_type = 'T'
289: AND business_group_id IS NULL;

Line 3902: FROM pay_element_templates

3898: -- Cursor to get template id
3899: CURSOR csr_get_template_id
3900: IS
3901: SELECT template_id
3902: FROM pay_element_templates
3903: WHERE base_name = p_ele_base_name
3904: AND template_name = g_template_name
3905: AND business_group_id = p_business_group_id
3906: AND template_type = 'U';

Line 3981: FROM pay_element_templates

3977: IS
3978: SELECT 'X'
3979: FROM DUAL
3980: WHERE EXISTS ( SELECT 1
3981: FROM pay_element_templates
3982: WHERE base_name = p_ele_base_name
3983: || ' Fixed'
3984: AND template_name = g_template_name
3985: AND business_group_id = p_business_group_id