APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ELEMENT_TYPES_F

Line 257: FROM pay_element_types_f pet, pay_element_types_f_tl petl

253: -- Cursor to get element name
254: CURSOR csr_get_element_name
255: IS
256: SELECT petl.element_name
257: FROM pay_element_types_f pet, pay_element_types_f_tl petl
258: WHERE petl.element_type_id = pet.element_type_id
259: AND petl.LANGUAGE = USERENV('LANG')
260: AND pet.element_type_id = p_element_type_id
261: AND p_effective_date BETWEEN pet.effective_start_date

Line 266: l_element_name pay_element_types_f.element_name%TYPE;

262: AND pet.effective_end_date;
263:
264: l_proc_name VARCHAR2(80) := g_proc_name || 'get_element_name';
265: l_proc_step PLS_INTEGER;
266: l_element_name pay_element_types_f.element_name%TYPE;
267: --
268: BEGIN
269: --
270: IF g_debug

Line 2332: FROM pay_element_types_f petf, pay_element_classifications pec

2328: p_element_type_id NUMBER
2329: )
2330: IS
2331: SELECT pec.classification_name
2332: FROM pay_element_types_f petf, pay_element_classifications pec
2333: WHERE petf.element_type_id = p_element_type_id
2334: AND pec.classification_id = petf.classification_id;
2335:
2336:

Line 2530: l_element_name pay_element_types_f.element_name%TYPE;

2526: l_psi_pens_category pqp_configuration_values.pcv_information1%TYPE;
2527: l_template_pens_category pay_element_type_extra_info.eei_information4%TYPE;
2528: l_rec_pen_bal_dtls r_pen_bal_dtls;
2529: l_rec_eeit_info pay_element_type_extra_info%ROWTYPE;
2530: l_element_name pay_element_types_f.element_name%TYPE;
2531: --
2532: BEGIN
2533: --
2534: IF g_debug