DBA Data[Home] [Help]

APPS.HR_US_FF_UDFS dependencies on FF_DATABASE_ITEMS

Line 5081: FF_DATABASE_ITEMS FDI

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
5084: AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
5085: AND PAA.ASSIGNMENT_ACTION_ID= FAI.CONTEXT1