APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on FND_SESSIONS

Line 347: from fnd_sessions

343: and p_eff_date between effective_start_date and effective_end_date ;
344: --
345: cursor csr_get_session_id is
346: select session_id
347: from fnd_sessions
348: where session_id = userenv('sessionid');
349:
350: -- End of 4915940
351: --

Line 371: -- Insert a row into fnd_sessions if reqd

367: end if;
368: --
369: -- Bug 4915940: Setting profiles PER_PERSON_ID and PER_ASSIGNMENT_ID
370:
371: -- Insert a row into fnd_sessions if reqd
372: open csr_get_session_id;
373: fetch csr_get_session_id into l_session_id;
374: if csr_get_session_id%notfound then
375: insert into fnd_sessions(session_id,effective_date)

Line 375: insert into fnd_sessions(session_id,effective_date)

371: -- Insert a row into fnd_sessions if reqd
372: open csr_get_session_id;
373: fetch csr_get_session_id into l_session_id;
374: if csr_get_session_id%notfound then
375: insert into fnd_sessions(session_id,effective_date)
376: values (userenv('sessionid'),l_effective_date);
377: end if;
378: close csr_get_session_id;
379:

Line 863: select session_id from fnd_sessions

859: and p_effective_date between effective_start_date and effective_end_date;
860: --
861: CURSOR csr_get_session_id
862: is
863: select session_id from fnd_sessions
864: where session_id = userenv('sessionid');
865: --
866: CURSOR csr_get_person_id(p_assignment_id NUMBER)
867: is

Line 905: insert into fnd_sessions(session_id,effective_date)

901:
902: OPEN csr_get_session_id;
903: FETCH csr_get_session_id into l_session_id;
904: IF csr_get_session_id%NOTFOUND then
905: insert into fnd_sessions(session_id,effective_date)
906: values (userenv('sessionid'),l_effective_date);
907: END IF;
908: CLOSE csr_get_session_id;
909: