DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on HR_LOCATION_EXTRA_INFO

Line 859: FROM hr_location_extra_info hlei

855: and ppit.pei_information1= 'PAYMENTSUMMARY'
856: and ppit.information_type='HR_SELF_SERVICE_PER_PREFERENCE'
857: union
858: Select LEI_INFORMATION2 online_opt, 2 sort_col
859: FROM hr_location_extra_info hlei
860: WHERE hlei.location_id = c_loc_id
861: And hlei.lei_information1= 'PAYMENTSUMMARY'
862: AND hlei.information_type = 'HR_SELF_SERVICE_LOC_PREFERENCE'
863: UNION