APPS.PQP_NL_ABP_FUNCTIONS dependencies on FND_SESSIONS

Line 489: FROM fnd_sessions

485:
486: --cursor to fetch the effective date the user has datetracked to
487: CURSOR c_get_eff_date IS
488: SELECT effective_date
489: FROM fnd_sessions
490: WHERE session_id IN
491: (SELECT userenv('sessionid')
492: FROM dual
493: );

Line 1138: FROM fnd_sessions

1134: );
1135:
1136: CURSOR c_get_eff_date IS
1137: SELECT effective_date
1138: FROM fnd_sessions
1139: WHERE session_id IN
1140: (SELECT userenv('sessionid')
1141: FROM dual
1142: );

Line 1929: FROM fnd_sessions

1925: where assignment_id = p_assignment_id;
1926:
1927: CURSOR c_get_eff_date IS
1928: SELECT effective_date
1929: FROM fnd_sessions
1930: WHERE session_id = userenv('sessionid');
1931:
1932: CURSOR cur_ret_addl_info_calc IS
1933: SELECT aei_information1

Line 2884: FROM fnd_sessions

2880:
2881: --cursor to find the eff date
2882: CURSOR c_get_eff_date IS
2883: SELECT effective_date
2884: FROM fnd_sessions
2885: WHERE session_id = userenv('sessionid');
2886:
2887: CURSOR c_get_person_id IS
2888: Select person_id from per_all_assignments_f

Line 5907: FROM fnd_sessions

5903:
5904: --cursor to fetch the effective date the user has datetracked to
5905: CURSOR c_get_eff_date IS
5906: SELECT effective_date
5907: FROM fnd_sessions
5908: WHERE session_id = userenv('sessionid');
5909:
5910: --cursor to check to see if there are any rows in the ORG EIT
5911: CURSOR c_rows_exist IS

Line 5976: FROM fnd_sessions

5972: ) IS
5973:
5974: CURSOR c_get_eff_date IS
5975: SELECT effective_date
5976: FROM fnd_sessions
5977: WHERE session_id = userenv('sessionid');
5978:
5979: l_eff_date DATE;
5980: