333: -- Cursor to get element name
334: CURSOR csr_get_element_name
335: IS
336: SELECT petl.element_name
337: FROM pay_element_types_f pet, pay_element_types_f_tl petl
338: WHERE petl.element_type_id = pet.element_type_id
339: AND petl.LANGUAGE = USERENV('LANG')
340: AND pet.element_type_id = p_element_type_id
341: AND p_effective_date BETWEEN pet.effective_start_date
342: AND pet.effective_end_date;
343:
344: l_proc_name VARCHAR2(80) := g_proc_name || 'get_element_name';
345: l_proc_step PLS_INTEGER;
346: l_element_name pay_element_types_f.element_name%TYPE;
347: --
348: BEGIN
349: --
350: IF g_debug
2484: p_element_type_id NUMBER
2485: )
2486: IS
2487: SELECT pec.classification_name
2488: FROM pay_element_types_f petf, pay_element_classifications pec
2489: WHERE petf.element_type_id = p_element_type_id
2490: AND pec.classification_id = petf.classification_id;
2491:
2492:
2682: l_psi_pens_category pqp_configuration_values.pcv_information1%TYPE;
2683: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;
2684: l_rec_pen_bal_dtls r_pen_bal_dtls;
2685: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;
2686: l_element_name pay_element_types_f.element_name%TYPE;
2687: --
2688: BEGIN
2689: --
2690: IF g_debug