DBA Data[Home] [Help]

APPS.HR_US_FF_UDFS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 5079: PAY_ASSIGNMENT_ACTIONS PAA,

5075:
5076: CURSOR check_archive_data IS
5077: SELECT 'Y'
5078: FROM PAY_PAYROLL_ACTIONS PPA,
5079: PAY_ASSIGNMENT_ACTIONS PAA,
5080: FF_ARCHIVE_ITEMS FAI,
5081: FF_DATABASE_ITEMS FDI
5082: WHERE PPA.REPORT_TYPE = 'YREND'
5083: AND TO_CHAR(PPA.EFFECTIVE_DATE,'YYYY') = p_reporting_year