APPS.PQH_CORPS_UTILITY dependencies on DUAL

Line 378: FROM dual

374: Function chk_steps_exist_for_index(p_gross_index IN NUMBER) RETURN VARCHAR2 IS
375:
376: CURSOR csr_steps_exist_for_index IS
377: SELECT 'Y'
378: FROM dual
379: WHERE EXISTS (SELECT '1'
380: FROM per_parent_spines pps,
381: per_spinal_points psp
382: WHERE psp.information1 = p_gross_index

Line 426: FROM dual

422: ,p_field_of_prof_activity_id IN NUMBER)
423: RETURN VARCHAR2 IS
424: CURSOR csr_if_prim_prof_field IS
425: SELECT 'Y'
426: FROM dual
427: WHERE EXISTS (SELECT 1
428: FROM pqh_corps_definitions
429: WHERE corps_definition_id = p_corps_definition_id
430: AND nvl(primary_prof_field_id,-1) = p_field_of_prof_activity_id);

Line 444: FROM dual

440: ,p_information_type IN VARCHAR2)
441: RETURN VARCHAR2 IS
442: CURSOR csr_corps_info_exists(p_corps_definition_id IN NUMBER, p_information_type IN varchar2) IS
443: SELECT 'Y'
444: FROM dual
445: WHERE EXISTS (SELECT 1
446: FROM pqh_corps_extra_info
447: WHERE corps_definition_id = p_corps_definition_id
448: AND information_type = p_information_type);