DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_RULES dependencies on PER_TIME_PERIODS

Line 84: per_time_periods ptp

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')
88: and c_effective_date between a.effective_start_date and a.effective_end_date

Line 489: per_time_periods ptp

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')
493: and c_effective_date between a.effective_start_date and a.effective_end_date