DBA Data[Home] [Help]

APPS.PAY_FI_PAYLIST_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 253: ptp.regular_payment_date from pay_payroll_actions ppa,per_time_periods ptp,pay_all_payrolls_f papf

249: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
250: )
251: IS
252: select papf.payroll_name,ptp.end_date , ptp.period_name ,
253: ptp.regular_payment_date from pay_payroll_actions ppa,per_time_periods ptp,pay_all_payrolls_f papf
254: where ptp.time_period_id=ppa.time_period_id
255: and ppa.PAYROLL_ID=papf.PAYROLL_ID
256: and ppa.payroll_action_id=csr_v_payroll_action_id;
257: