DBA Data[Home] [Help]

APPS.PAY_IP_PAYROLL_ARCH dependencies on PER_TIME_PERIODS

Line 3373: ,per_time_periods ptp

3369: FROM pay_assignment_actions paa
3370: ,pay_payroll_actions ppa
3371: ,pay_run_results prr
3372: ,pay_run_result_values prrv
3373: ,per_time_periods ptp
3374: ,pay_element_types_f pet
3375: ,pay_input_values_f piv
3376: ,pay_element_entries_f pee
3377: ,per_absence_attendance_types pat

Line 3723: per_time_periods ptp

3719: ppa.date_earned,
3720: ppa.effective_date
3721: FROM pay_assignment_actions paa,
3722: pay_payroll_actions ppa,
3723: per_time_periods ptp
3724: WHERE paa.assignment_action_id = cp_run_assignment_action
3725: AND ppa.payroll_action_id = paa.payroll_action_id
3726: AND ptp.payroll_id = ppa.payroll_id
3727: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date;