APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 2488: FROM pay_element_types_f petf, pay_element_classifications pec

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:

Line 2498: l_ele_classification pay_element_classifications.classification_name%TYPE;

2494: l_proc_name VARCHAR2(80)
2495: := g_proc_name || 'get_avc_pen_balance_details';
2496: l_proc_step PLS_INTEGER;
2497: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;
2498: l_ele_classification pay_element_classifications.classification_name%TYPE;
2499: l_element_type_id NUMBER;
2500: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2501: l_balance_name pay_balance_types.balance_name%TYPE;
2502: l_balance_type_id NUMBER;