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 571: SELECT 'C' FROM dual

567: -- 'HR_ASSIGNMENT_TOP_SS',
568: -- 'HR_NEWHIRE_PERSON_TOP_SS',
569: -- 'HR_CAED_TOP_SS'
570: CURSOR csr_akregion_list IS
571: SELECT 'C' FROM dual
572: WHERE UPPER(p_ak_region) IN (
573: 'HR_CCMGR_OVERVIEW_TOP_SS',
574: 'PQH_ACADEMIC_RANK_TOP',
575: 'PQH_ACADEMIC_RANK_OVRVW_TOP',