DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_RULES dependencies on PER_TIME_PERIODS

Line 90: per_time_periods ptp

86: FROM per_all_assignments_f a,
87: per_assignment_status_types past,
88: pay_assignment_actions act,
89: pay_payroll_actions pact,
90: per_time_periods ptp
91: where a.payroll_id = c_payroll_id
92: and a.assignment_status_type_id = past.assignment_status_type_id
93: and past.per_system_status IN ('TERM_ASSIGN')
94: and c_effective_date between a.effective_start_date and a.effective_end_date

Line 521: per_time_periods ptp

517: FROM per_all_assignments_f a,
518: per_assignment_status_types past,
519: pay_assignment_actions act,
520: pay_payroll_actions pact,
521: per_time_periods ptp
522: where a.payroll_id = c_payroll_id
523: and a.assignment_status_type_id = past.assignment_status_type_id
524: and past.per_system_status IN ('TERM_ASSIGN')
525: and c_effective_date between a.effective_start_date and a.effective_end_date