APPS.PAY_NL_SI_PKG dependencies on FND_SESSIONS

Line 49: fnd_sessions ses

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

Line 380: fnd_sessions ses

376: FETCH c_wp_dets INTO l_assgn_attr;
377: CLOSE c_wp_dets;
378: select person_id into l_person_id
379: from per_all_assignments_f paa,
380: fnd_sessions ses
381: where paa.assignment_id =p_assignment_id
382: and ses.session_id = userenv('sessionid')
383: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;
384: for l_absence_record in Get_Non_SI_Absence(l_person_id)

Line 476: fnd_sessions ses

472: select count(uci.value)
473: from pay_user_tables put,
474: pay_user_columns puc,
475: pay_user_column_instances_f uci,
476: fnd_sessions ses
477: where put.user_table_id = puc.user_table_id
478: and puc.business_group_id = p_business_group_id -- Fix for bug 3977437
479: and uci.user_column_id = puc.user_column_id
480: and put.user_table_name = g_udt_name

Line 506: fnd_sessions ses

502: select count(uci.value)
503: from pay_user_tables put,
504: pay_user_columns puc,
505: pay_user_column_instances_f uci,
506: fnd_sessions ses
507: where put.user_table_id = puc.user_table_id
508: and puc.business_group_id = p_business_group_id -- Fix for bug 3977437
509: and uci.user_column_id = puc.user_column_id
510: and put.user_table_name = g_udt_name