APPS.HR_PERSON_RECORD dependencies on PAY_PAYROLLS_F

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

266: , STTL.USER_STATUS
267: , ST.PAY_SYSTEM_STATUS
268: , ST.PER_SYSTEM_STATUS
269: , PAYROLL_ID
270: , (SELECT PAYROLL_NAME FROM PAY_PAYROLLS_F PPF WHERE PPF.PAYROLL_ID = PAAF.PAYROLL_ID
271: and p_eff_date between ppf.effective_start_date and
272: nvl(ppf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) PAYROLL_DESC
273: , LOCATION_ID
274: , (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAAF.LOCATION_ID