APPS.PQH_PSU_BUS dependencies on DUAL

Line 775: SELECT 'x' FROM DUAL

771: PROCEDURE chk_situation_dates(p_rec IN pqh_psu_shd.g_rec_type)
772: IS
773: --
774: CURSOR csr_default_sit IS
775: SELECT 'x' FROM DUAL
776: WHERE EXISTS(SELECT statutory_situation_id
777: FROM pqh_fr_stat_situations
778: WHERE statutory_situation_id = p_rec.statutory_situation_id
779: AND situation_type = 'IA'

Line 792: FROM DUAL

788: p_actual_end DATE,
789: p_person_id NUMBER,
790: p_emp_stat_situation_id NUMBER) IS
791: SELECT 'x'
792: FROM DUAL
793: WHERE EXISTS(SELECT 'x'
794: FROM pqh_fr_emp_stat_situations
795: WHERE person_id = p_person_id
796: AND emp_stat_situation_id <> NVL(p_emp_stat_situation_id,-1)