DBA Data[Home] [Help]

APPS.PAY_FI_RULES dependencies on PER_TIME_PERIODS

Line 637: FROM per_time_periods ptp

633: ,ptp.period_type period_type
634: ,ptp.start_date start_date
635: ,ptp.end_date end_date
636: ,pai.effective_date payment_date
637: FROM per_time_periods ptp
638: ,pay_payrolls_f ppf
639: ,pay_action_information pai
640: WHERE ppf.payroll_id = ptp.payroll_id
641: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 653: FROM per_time_periods ptp

649: ,ptp.period_type period_type
650: ,ptp.start_date start_date
651: ,ptp.end_date end_date
652: ,pai.effective_date payment_date
653: FROM per_time_periods ptp
654: ,pay_payrolls_f ppf
655: ,pay_action_information pai
656: ,pay_assignment_actions paa
657: WHERE ppf.payroll_id = ptp.payroll_id

Line 673: FROM per_time_periods ptp

669: ,ptp.start_date start_date
670: ,ptp.end_date end_date
671: ,pai.effective_date payment_date
672: -- ,pai1.action_information4 ss_days
673: FROM per_time_periods ptp
674: ,pay_payrolls_f ppf
675: ,pay_action_information pai
676: -- ,pay_action_information pai1
677: WHERE ppf.payroll_id = ptp.payroll_id