APPS.HR_PERSON_RECORD dependencies on PAY_PAYROLLS_F

Line 289: , (SELECT PAYROLL_NAME FROM PAY_PAYROLLS_F PPF WHERE PPF.PAYROLL_ID = PAAF.PAYROLL_ID

285: , STTL.USER_STATUS
286: , ST.PAY_SYSTEM_STATUS
287: , ST.PER_SYSTEM_STATUS
288: , PAYROLL_ID
289: , (SELECT PAYROLL_NAME FROM PAY_PAYROLLS_F PPF WHERE PPF.PAYROLL_ID = PAAF.PAYROLL_ID
290: and p_eff_date between ppf.effective_start_date and
291: nvl(ppf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) PAYROLL_DESC
292: , LOCATION_ID
293: , (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAAF.LOCATION_ID