APPS.PAY_P45_PKG dependencies on FND_SESSIONS

Line 1123: fnd_sessions sess

1119: from hr_organization_information oi,
1120: pay_payrolls_f roll,
1121: hr_soft_coding_keyflex flex,
1122: per_assignments_f ass,
1123: fnd_sessions sess
1124: where oi.ORG_INFORMATION_CONTEXT = 'Tax Details References'
1125: and roll.business_group_id + 0 = oi.organization_id
1126: /* normally P45 is for leaver so pick up data on the assignment_end_date */
1127: /* for non leavers eg. tax district change use the session date */

Line 1321: , fnd_sessions sess

1317: from per_all_people_f p
1318: , per_all_assignments_f a
1319: , per_periods_of_service serv
1320: , hr_all_organization_units org
1321: , fnd_sessions sess
1322: where a.assignment_id = p_assignment_id
1323: and sess.session_id = userenv('sessionid')
1324: and sess.effective_date between
1325: a.effective_start_date and a.effective_end_date

Line 2633: -- fnd_sessions used in cursor employer_addr (only when asg terminated

2629: BEGIN
2630: hr_utility.set_location('Entering: '||l_proc,1);
2631: IF NOT g_asg_process_cache_populated THEN
2632: -- does session date need to be set?
2633: -- fnd_sessions used in cursor employer_addr (only when asg terminated
2634: -- with null last std proc date).
2635: -- Get required SRS Parameters
2636: OPEN csr_parameter_info(p_payroll_action_id);
2637: FETCH csr_parameter_info INTO g_payroll_id,