APPS.PAY_US_RSRW_UPGREV dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 2796: ,pay_element_type_extra_info petei

2792: CURSOR csr_get_ele_xtra_info(cp_eletyp_ctx_id in number)
2793: IS
2794: SELECT petei.eei_information11
2795: FROM pay_element_types_f pet
2796: ,pay_element_type_extra_info petei
2797: where pet.element_type_id = cp_eletyp_ctx_id
2798: and pet.element_type_id = petei.element_type_id
2799: and petei.information_type = 'US_EARNINGS'
2800: and petei.eei_information_category = 'US_EARNINGS';

Line 2825: lv_ele_xtra_info PAY_ELEMENT_TYPE_EXTRA_INFO.eei_information11%TYPE;

2821:
2822:
2823: ln_max_period_num NUMBER;
2824: ln_period_num NUMBER;
2825: lv_ele_xtra_info PAY_ELEMENT_TYPE_EXTRA_INFO.eei_information11%TYPE;
2826:
2827: BEGIN
2828:
2829: hr_utility.trace('Entering into pay_us_rsrw_upgrev.get_payprd_per_fiscal_yr');