APPS.PQH_SS_PRINT dependencies on DUAL

Line 40: select userenv('sessionid') into p_session_id from dual;

36: return number
37: IS
38: BEGIN
39:
40: select userenv('sessionid') into p_session_id from dual;
41: select trunc(sysdate) into p_effective_date from dual;
42: p_txn_id :=g_transaction_id;
43:
44: return 0;

Line 41: select trunc(sysdate) into p_effective_date from dual;

37: IS
38: BEGIN
39:
40: select userenv('sessionid') into p_session_id from dual;
41: select trunc(sysdate) into p_effective_date from dual;
42: p_txn_id :=g_transaction_id;
43:
44: return 0;
45:

Line 87: SELECT userenv('sessionid') into l_session_id from dual;

83: --
84:
85:
86:
87: SELECT userenv('sessionid') into l_session_id from dual;
88:
89: OPEN csr_check_tag_exists(p_tag_name,l_session_id);
90:
91: FETCH csr_check_tag_exists into l_result;

Line 438: FROM DUAL;

434: l_meaning hr_lookups.meaning%type :=null;
435: BEGIN
436:
437: SELECT hr_general.decode_lookup('PQH_TENURE_STATUS',p_lookup_code) into l_meaning
438: FROM DUAL;
439:
440: return l_meaning;
441:
442: END get_tenure_status;

Line 1356: select userenv('sessionid') into p_session_id from dual;

1352:
1353: hr_utility.set_location('Effective Date' || p_effective_date,12);
1354: hr_utility.set_location('Document Short Name' || l_pdf_short_name,12);
1355:
1356: select userenv('sessionid') into p_session_id from dual;
1357:
1358:
1359: IF l_pdf_short_name <> 'N/A' THEN
1360: