APPS.HR_UTIL_MISC_SS dependencies on DUAL

Line 232: FROM dual

228: AND ce.competence_id = p_cid
229: AND paf.person_id = p_pid
230: UNION ALL
231: SELECT 0 rank, hr_general.decode_lookup('STRUCTURE_TYPE','ADD')||'##' src
232: FROM dual
233: ORDER BY RANK DESC;
234:
235: BEGIN
236: For I in c_srcInfo(p_competence_id, p_person_id) Loop

Line 579: SELECT 'C' FROM dual

575: -- 'HR_ASSIGNMENT_TOP_SS',
576: -- 'HR_NEWHIRE_PERSON_TOP_SS',
577: -- 'HR_CAED_TOP_SS'
578: CURSOR csr_akregion_list IS
579: SELECT 'C' FROM dual
580: WHERE UPPER(p_ak_region) IN (
581: 'HR_CCMGR_OVERVIEW_TOP_SS',
582: 'PQH_ACADEMIC_RANK_TOP',
583: 'PQH_ACADEMIC_RANK_OVRVW_TOP',

Line 1406: select INSTR(l_web_html_call,'/oracle/apps/per/selfservice/talentmanagement/webui/MgrTalentManagementPG') as str_index into l_appr_index from dual;

1402: l_func_name := l_func_details.function_name;
1403: l_param_name := nvl(get_parameter_value(l_func_details.parameters,'pCalledFrom'),l_func_name);
1404: l_web_html_call := l_func_details.WEB_HTML_CALL;
1405: begin
1406: select INSTR(l_web_html_call,'/oracle/apps/per/selfservice/talentmanagement/webui/MgrTalentManagementPG') as str_index into l_appr_index from dual;
1407: if(l_appr_index=0)then
1408: select INSTR(l_web_html_call,'/oracle/apps/per/selfservice/appraisals/webui/MgrMainAppraiserPG&') as str_index into l_appr_index from dual;
1409: end if;
1410: end;

Line 1408: select INSTR(l_web_html_call,'/oracle/apps/per/selfservice/appraisals/webui/MgrMainAppraiserPG&') as str_index into l_appr_index from dual;

1404: l_web_html_call := l_func_details.WEB_HTML_CALL;
1405: begin
1406: select INSTR(l_web_html_call,'/oracle/apps/per/selfservice/talentmanagement/webui/MgrTalentManagementPG') as str_index into l_appr_index from dual;
1407: if(l_appr_index=0)then
1408: select INSTR(l_web_html_call,'/oracle/apps/per/selfservice/appraisals/webui/MgrMainAppraiserPG&') as str_index into l_appr_index from dual;
1409: end if;
1410: end;
1411:
1412: select INSTR(l_web_html_call,'/ghr/') as str_index into l_ghr_index from dual;

Line 1412: select INSTR(l_web_html_call,'/ghr/') as str_index into l_ghr_index from dual;

1408: select INSTR(l_web_html_call,'/oracle/apps/per/selfservice/appraisals/webui/MgrMainAppraiserPG&') as str_index into l_appr_index from dual;
1409: end if;
1410: end;
1411:
1412: select INSTR(l_web_html_call,'/ghr/') as str_index into l_ghr_index from dual;
1413:
1414: -- This logic for SSHR Manager Self-Service fucntion and for Appraisal Manager Fucntion
1415: IF (l_func_name <> l_param_name) OR (l_appr_index > 0 ) OR (l_ghr_index > 0)THEN
1416: begin

Line 1425: ),p_bg_id)) into l_bg_id from dual;

1421: ,null,fnd_profile.value('PER_BUSINESS_GROUP_ID'),
1422: FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1423: )
1424: ,p_bg_id
1425: ),p_bg_id)) into l_bg_id from dual;
1426: end;
1427: END IF; -- end of IF (l_func_name <> l_param_name) OR (l_appr_index > 0 )THEN
1428: end if; -- end of if csr_fnd_func_details%found then
1429: CLOSE csr_fnd_func_details;

Line 1464: select userenv('LANG') into l_language from dual;

1460: l_doc_pre_upd csr_get_doc%rowtype;
1461: l_doc_tl_pre_upd csr_get_doc_tl%rowtype;
1462: Begin
1463: hr_utility.set_location(' Entering:' || l_proc,10);
1464: select userenv('LANG') into l_language from dual;
1465: Open csr_get_attached_doc;
1466: fetch csr_get_attached_doc into l_attached_doc_pre_upd;
1467: IF csr_get_attached_doc%NOTFOUND THEN
1468: close csr_get_attached_doc;