DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_ASSIGNMENTS_F

Line 296: per_assignments_f paf,

292: ,'Lunar Month' ,'4') PAYROLL_PERIOD,
293: ptp.TIME_PERIOD_ID
294: FROM
295: pay_payrolls_f ppf,
296: per_assignments_f paf,
297: hr_organization_units hou,
298: hr_organization_information hoi,
299: hr_soft_coding_keyflex scl,
300: per_time_periods ptp

Line 996: per_assignments_f paf,

992: ptp.period_name
993:
994: FROM
995: pay_payrolls_f ppf,
996: per_assignments_f paf,
997: per_time_periods ptp
998: WHERE paf.payroll_id = ppf.payroll_id
999: AND paf.assignment_id=c_assignment_id
1000: AND ppf.payroll_id=NVL(g_payroll_id,ppf.payroll_id)