DBA Data[Home] [Help]

APPS.PAY_NL_TAX_PKG dependencies on PAY_PAYROLLS_F

Line 257: FROM pay_payrolls_f pp,fnd_sessions ses

253: -- Cursor get_pay_prd
254: --
255: CURSOR get_pay_prd(p_payroll_id NUMBER) IS
256: SELECT pp.period_type
257: FROM pay_payrolls_f pp,fnd_sessions ses
258: WHERE
259: pp.payroll_id=p_payroll_id and
260: ses.effective_date between nvl(pp.effective_start_date,ses.effective_date) and
261: nvl(pp.effective_end_date,ses.effective_date) and