DBA Data[Home] [Help]

APPS.PAY_NL_TAX_PKG dependencies on FND_SESSIONS

Line 215: FROM hr_soft_coding_keyflex scl,per_all_assignments_f paa,fnd_sessions ses

211: -- Cursor get_lbr_tx_red_ind
212: --
213: CURSOR get_lbr_tx_red_ind(p_person_id number,p_assignment_id number) IS
214: SELECT scl.segment7
215: FROM hr_soft_coding_keyflex scl,per_all_assignments_f paa,fnd_sessions ses
216: WHERE
217: paa.person_id=p_person_id and
218: paa.assignment_id <> nvl(p_assignment_id,-1) and
219: scl.soft_coding_keyflex_id=paa.soft_coding_keyflex_id and

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