APPS.PAY_P45_PKG dependencies on FND_SESSIONS

Line 1230: fnd_sessions sess

1226: from hr_organization_information oi,
1227: pay_payrolls_f roll,
1228: hr_soft_coding_keyflex flex,
1229: per_assignments_f ass,
1230: fnd_sessions sess
1231: where oi.ORG_INFORMATION_CONTEXT = 'Tax Details References'
1232: and roll.business_group_id + 0 = oi.organization_id
1233: /* normally P45 is for leaver so pick up data on the assignment_end_date */
1234: /* for non leavers eg. tax district change use the session date */

Line 1435: , fnd_sessions sess

1431: from per_all_people_f p
1432: , per_all_assignments_f a
1433: , per_periods_of_service serv
1434: , hr_all_organization_units org
1435: , fnd_sessions sess
1436: where a.assignment_id = p_assignment_id
1437: and sess.session_id = userenv('sessionid')
1438: and sess.effective_date between
1439: a.effective_start_date and a.effective_end_date

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

2959: BEGIN
2960: hr_utility.set_location('Entering: '||l_proc,1);
2961: IF NOT g_asg_process_cache_populated THEN
2962: -- does session date need to be set?
2963: -- fnd_sessions used in cursor employer_addr (only when asg terminated
2964: -- with null last std proc date).
2965: -- Get required SRS Parameters
2966: OPEN csr_parameter_info(p_payroll_action_id);
2967: FETCH csr_parameter_info INTO g_payroll_id,