DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_ALL_PAYROLLS_F

Line 413: from pay_payroll_actions ppa, per_time_periods ptp, pay_all_payrolls_f papf

409: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%type
410: ) is
411: select papf.payroll_id, papf.payroll_name, ptp.start_date, ptp.end_date, ptp.period_name, ptp.period_type,
412: ptp.regular_payment_date, ptp.time_period_id
413: from pay_payroll_actions ppa, per_time_periods ptp, pay_all_payrolls_f papf
414: where ptp.time_period_id = ppa.time_period_id
415: and ppa.payroll_id = papf.payroll_id
416: and ppa.payroll_action_id = csr_v_payroll_action_id;
417: