DBA Data[Home] [Help]

APPS.PAY_NL_TAX_PKG dependencies on PAY_PAYROLLS_F

Line 569: FROM pay_payrolls_f pp,fnd_sessions ses

565: -- Cursor get_pay_prd
566: --
567: CURSOR get_pay_prd(p_payroll_id NUMBER) IS
568: SELECT pp.period_type
569: FROM pay_payrolls_f pp,fnd_sessions ses
570: WHERE
571: pp.payroll_id=p_payroll_id and
572: ses.effective_date between nvl(pp.effective_start_date,ses.effective_date) and
573: nvl(pp.effective_end_date,ses.effective_date) and