DBA Data[Home] [Help]

APPS.PAY_CA_PAYROLL_ARCH dependencies on PER_TIME_PERIODS

Line 738: per_time_periods ptp

734: ppa.date_earned,
735: ppa.effective_date
736: from pay_assignment_actions paa,
737: pay_payroll_actions ppa,
738: per_time_periods ptp
739: where paa.assignment_action_id = cp_run_assignment_action
740: and ppa.payroll_action_id = paa.payroll_action_id
741: and ptp.payroll_id = ppa.payroll_id
742: and ppa.date_earned between ptp.start_date and ptp.end_date;