APPS.PAY_NL_SI_PKG dependencies on FND_SESSIONS

Line 51: fnd_sessions ses

47:
48: cursor c_wp_dets(p_assignment_id NUMBER ) is
49: select *
50: from pqp_assignment_attributes_f paa,
51: fnd_sessions ses
52: where assignment_id = p_assignment_id
53: and ses.session_id = userenv('sessionid')
54: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;
55: --

Line 397: fnd_sessions ses

393: FETCH c_wp_dets INTO l_assgn_attr;
394: CLOSE c_wp_dets;
395: select person_id into l_person_id
396: from per_all_assignments_f paa,
397: fnd_sessions ses
398: where paa.assignment_id =p_assignment_id
399: and ses.session_id = userenv('sessionid')
400: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;
401: for l_absence_record in Get_Non_SI_Absence(l_person_id)

Line 493: fnd_sessions ses

489: select count(uci.value)
490: from pay_user_tables put,
491: pay_user_columns puc,
492: pay_user_column_instances_f uci,
493: fnd_sessions ses
494: where put.user_table_id = puc.user_table_id
495: and puc.business_group_id = p_business_group_id -- Fix for bug 3977437
496: and uci.user_column_id = puc.user_column_id
497: and put.user_table_name = g_udt_name

Line 523: fnd_sessions ses

519: select count(uci.value)
520: from pay_user_tables put,
521: pay_user_columns puc,
522: pay_user_column_instances_f uci,
523: fnd_sessions ses
524: where put.user_table_id = puc.user_table_id
525: and puc.business_group_id = p_business_group_id -- Fix for bug 3977437
526: and uci.user_column_id = puc.user_column_id
527: and put.user_table_name = g_udt_name