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)
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)