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 ses.session_id = userenv('sessionid')
76: AND ppa.payroll_action_id = paa.payroll_action_id

Line 98: fnd_sessions ses,

94: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
95: paa.assignment_action_id),16))
96: FROM pay_assignment_actions paa,
97: pay_payroll_actions ppa,
98: fnd_sessions ses,
99: per_time_periods ptp
100: WHERE paa.assignment_id = p_asg
101: AND paa.action_status = 'C'
102: AND ses.session_id = userenv('sessionid')

Line 269: from fnd_sessions

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

Line 463: fnd_sessions fs,

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

Line 497: FROM fnd_sessions fs,

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

Line 533: fnd_sessions fs

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

Line 1017: FROM fnd_sessions fs,

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