DBA Data[Home] [Help]

APPS.PAY_FI_RULES dependencies on PAY_PAYROLLS_F

Line 638: ,pay_payrolls_f ppf

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
642: AND ptp.time_period_id = pai.action_information16

Line 654: ,pay_payrolls_f ppf

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
658: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 674: ,pay_payrolls_f ppf

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
678: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date