DBA Data[Home] [Help]

APPS.PAY_NL_TAX_PKG dependencies on FND_SESSIONS

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

523: -- Cursor get_lbr_tx_red_ind
524: --
525: CURSOR get_lbr_tx_red_ind(p_person_id number,p_assignment_id number) IS
526: SELECT scl.segment7
527: FROM hr_soft_coding_keyflex scl,per_all_assignments_f paa,fnd_sessions ses
528: WHERE
529: paa.person_id=p_person_id and
530: paa.assignment_id <> nvl(p_assignment_id,-1) and
531: scl.soft_coding_keyflex_id=paa.soft_coding_keyflex_id and

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