APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on FND_SESSIONS

Line 72: fnd_sessions ses

68: paa.assignment_action_id),16))
69: FROM pay_assignment_actions paa,
70: pay_payroll_actions ppa,
71: per_time_periods ptp,
72: fnd_sessions ses
73: WHERE paa.assignment_id = p_asg
74: --AND paa.action_status = 'C'
75: AND paa.action_status in ('C','S') --Modified for the bug 10066755
76: AND ses.session_id = userenv('sessionid')

Line 99: fnd_sessions ses,

95: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
96: paa.assignment_action_id),16))
97: FROM pay_assignment_actions paa,
98: pay_payroll_actions ppa,
99: fnd_sessions ses,
100: per_time_periods ptp
101: WHERE paa.assignment_id = p_asg
102: --AND paa.action_status = 'C'
103: AND paa.action_status in ('C','S') --Modified for the bug 10066755

Line 271: from fnd_sessions

267: P_OBJECT_VERSION_NUMBER out nocopy Number) is
268:
269: cursor c_effective_date is
270: select effective_date
271: from fnd_sessions
272: where session_id = userenv('sessionid');
273:
274: cursor c_element_type is
275: select element_type_id

Line 465: fnd_sessions fs,

461:
462: CURSOR get_asg_tax_ref IS
463: SELECT scl.segment1
464: FROM hr_soft_coding_keyflex scl,
465: fnd_sessions fs,
466: pay_payrolls_f ppf,
467: per_all_assignments_f paaf
468: WHERE paaf.assignment_id = p_assignment_id
469: AND fs.session_id = userenv('sessionid')

Line 499: FROM fnd_sessions fs,

495: FUNCTION get_input_value(p_ele_name IN VARCHAR2, p_iv_name IN VARCHAR2) RETURN NUMBER IS
496:
497: CURSOR get_input_value_ids IS
498: SELECT piv.input_value_id
499: FROM fnd_sessions fs,
500: pay_element_types_f pet,
501: pay_input_values_f piv
502: WHERE fs.session_id = userenv('sessionid')
503: AND pet.element_name = p_ele_name

Line 535: fnd_sessions fs

531:
532: CURSOR get_person(p_assignment_id IN NUMBER) IS
533: SELECT person_id
534: FROM per_all_assignments_f paaf,
535: fnd_sessions fs
536: WHERE fs.session_id = userenv('sessionid')
537: AND paaf.assignment_id =p_assignment_id
538: AND fs.effective_date between paaf.effective_start_date and paaf.effective_end_date;
539:

Line 1019: FROM fnd_sessions fs,

1015: AND papf.person_id = paaf2.person_id;
1016: --
1017: CURSOR get_prim_payroll_id(p_asg_tax_ref VARCHAR2) IS
1018: SELECT ppf.payroll_id
1019: FROM fnd_sessions fs,
1020: per_all_assignments_f paaf1,
1021: per_all_assignments_f paaf2,
1022: pay_all_payrolls_f ppf,
1023: hr_soft_coding_keyflex scl,