DBA Data[Home] [Help]

APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 758: FROM pay_payrolls_f pp,

754: , NULL assignment_id
755: ,ppa.effective_date run_effective_date
756: ,ppa.date_earned date_earned
757: ,ppa.pay_advice_message payroll_message
758: FROM pay_payrolls_f pp,
759: pay_payroll_actions ppa
760: WHERE ppa.payroll_id = p_payroll_id
761: AND ppa.effective_date BETWEEN p_start_date AND p_end_date
762: AND ppa.action_type = 'R'

Line 776: FROM pay_payrolls_f pp,

772: ,paa.assignment_id assignment_id
773: ,ppa.effective_date run_effective_date
774: ,ppa.date_earned date_earned
775: ,ppa.pay_advice_message payroll_message
776: FROM pay_payrolls_f pp,
777: pay_payroll_actions ppa,
778: pay_assignment_actions paa
779: WHERE ppa.payroll_id = p_payroll_id
780: AND ppa.effective_date BETWEEN p_start_date AND p_end_date