DBA Data[Home] [Help]

APPS.PQH_FR_EMP_STAT_SIT_UTILITY dependencies on DUAL

Line 99: FROM DUAL

95: p_person_id NUMBER,
96: p_emp_stat_situation_id NUMBER,
97: p_iand_stat_sit_id NUMBER) IS
98: SELECT 'x'
99: FROM DUAL
100: WHERE EXISTS(SELECT 'x'
101: FROM pqh_fr_emp_stat_situations
102: WHERE person_id = p_person_id
103: -- AND emp_stat_situation_id <> NVL(p_emp_stat_situation_id,-1)

Line 408: FROM DUAL

404: p_person_id NUMBER,
405: p_emp_stat_situation_id NUMBER,
406: p_iand_stat_sit_id NUMBER) IS
407: SELECT 'x'
408: FROM DUAL
409: WHERE EXISTS(SELECT 'x'
410: FROM pqh_fr_emp_stat_situations
411: WHERE person_id = p_person_id
412: AND emp_stat_situation_id <> NVL(p_emp_stat_situation_id,-1)