APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on FND_SESSIONS

Line 2895: fnd_sessions fs

2891: pai.action_information13 non_payroll_payments
2892: FROM pay_emp_payslip_action_info_v payslipv,
2893: pay_assignment_actions paa,
2894: pay_action_information pai,
2895: fnd_sessions fs
2896: WHERE paa.assignment_id = cp_assignment_id
2897: AND payslipv.person_id = cp_person_id
2898: AND payslipv.action_context_id = paa.assignment_action_id
2899: AND payslipv.effective_date < cp_effective_date

Line 4545: FROM fnd_sessions fs

4541:
4542: CURSOR get_effective_date
4543: IS
4544: SELECT fs.effective_date
4545: FROM fnd_sessions fs
4546: WHERE fs.session_id = USERENV('SESSIONID');
4547:
4548: CURSOR get_details(cp_assignment_id NUMBER,
4549: cp_effective_date DATE)

Line 4556: fnd_sessions fs

4552: paaf.business_group_id,
4553: paaf.payroll_id,
4554: paaf.pay_basis_id
4555: FROM per_all_assignments_f paaf,
4556: fnd_sessions fs
4557: WHERE paaf.assignment_id = cp_assignment_id
4558: AND cp_effective_date BETWEEN paaf.effective_start_date
4559: AND paaf.effective_end_date;
4560:

Line 4574: fnd_sessions fs

4570: CURSOR get_legislation_code(cp_business_group_id NUMBER)
4571: IS
4572: SELECT pbg.legislation_code
4573: FROM per_business_groups pbg,
4574: fnd_sessions fs
4575: WHERE pbg.business_group_id = cp_business_group_id
4576: AND fs.session_id = USERENV('SESSIONID')
4577: AND fs.effective_date BETWEEN pbg.date_from
4578: AND NVL(pbg.date_to,TO_DATE('31/12/4712','DD/MM/YYYY'));