APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_ELEMENT_CLASSIFICATIONS

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 2342: l_ele_classification pay_element_classifications.classification_name%TYPE;

2338: l_proc_name VARCHAR2(80)
2339: := g_proc_name || 'get_avc_pen_balance_details';
2340: l_proc_step PLS_INTEGER;
2341: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;
2342: l_ele_classification pay_element_classifications.classification_name%TYPE;
2343: l_element_type_id NUMBER;
2344: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2345: l_balance_name pay_balance_types.balance_name%TYPE;
2346: l_balance_type_id NUMBER;