APPS.PAY_GB_TAX_CREDIT_PKG dependencies on FND_SESSIONS

Line 43: from fnd_sessions

39: ) RETURN number is
40:
41: Cursor c_effective_date is
42: select effective_date
43: from fnd_sessions
44: where session_id = userenv('sessionid');
45:
46: Cursor c_element_type is
47: select element_type_id

Line 263: fnd_sessions ses,

259: select actual_termination_date,
260: last_standard_process_date,
261: final_process_date
262: from per_periods_of_service pos,
263: fnd_sessions ses,
264: per_all_assignments_f asg
265: where asg.assignment_id = p_asg
266: and ses.session_id = userenv('sessionid')
267: and ses.effective_date between asg.effective_start_date and asg.effective_end_date

Line 698: fnd_sessions ses

694: paa.assignment_action_id),16))
695: FROM pay_assignment_actions paa,
696: pay_payroll_actions ppa,
697: per_time_periods ptp,
698: fnd_sessions ses
699: WHERE paa.assignment_id = p_asg
700: AND ses.session_id = userenv('sessionid')
701: AND ppa.payroll_action_id = paa.payroll_action_id
702: AND ses.effective_date between ptp.start_date and ptp.end_date

Line 721: fnd_sessions ses,

717: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
718: paa.assignment_action_id),16))
719: from pay_assignment_actions paa,
720: pay_payroll_actions ppa,
721: fnd_sessions ses,
722: per_time_periods ptp,
723: per_all_assignments per
724: where paa.assignment_id = p_asg
725: and ses.session_id = userenv('sessionid')