[Home] [Help]
79: SELECT 1
80: FROM per_all_assignments_f a,
81: per_assignment_status_types past,
82: pay_assignment_actions act,
83: pay_payroll_actions pact,
84: per_time_periods ptp
85: where a.payroll_id = c_payroll_id
86: and a.assignment_status_type_id = past.assignment_status_type_id
87: and past.per_system_status IN ('TERM_ASSIGN')
484: SELECT 1
485: FROM per_all_assignments_f a,
486: per_assignment_status_types past,
487: pay_assignment_actions act,
488: pay_payroll_actions pact,
489: per_time_periods ptp
490: where a.payroll_id = c_payroll_id
491: and a.assignment_status_type_id = past.assignment_status_type_id
492: and past.per_system_status IN ('TERM_ASSIGN')