APPS.PE_POI_BUS dependencies on FND_SESSIONS

Line 892: from fnd_sessions

888: l_effective_date date := trunc(sysdate);
889: --
890: cursor c_effective_date is
891: select effective_date
892: from fnd_sessions
893: where session_id = userenv('sessionid');
894: --
895: cursor c_position(p_position_id number, p_effective_date date) is
896: select *

Line 1047: from fnd_sessions

1043: l_effective_date date := trunc(sysdate);
1044: --
1045: cursor c_effective_date is
1046: select effective_date
1047: from fnd_sessions
1048: where session_id = userenv('sessionid');
1049: --
1050: cursor c_position(p_position_id number, p_effective_date date) is
1051: select *

Line 1175: from fnd_sessions

1171: l_effective_date date := trunc(sysdate);
1172: --
1173: cursor c_effective_date is
1174: select effective_date
1175: from fnd_sessions
1176: where session_id = userenv('sessionid');
1177: --
1178: cursor c_position(p_position_id number, p_effective_date date) is
1179: select *