DBA Data[Home] [Help]

APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 841: per_all_assignments_f paf,

837: SELECT pps.actual_termination_date
838: FROM pay_payroll_actions ppa,
839: pay_assignment_actions paa,
840: per_time_periods ptp,
841: per_all_assignments_f paf,
842: per_periods_of_service pps
843: WHERE paa.assignment_action_id = p_assignment_action_id
844: AND ppa.payroll_action_id = paa.payroll_action_id
845: AND ptp.payroll_id = ppa.payroll_id