APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_HLTH_INS_ALL

Line 3708: SELECT 'x' FROM IGS_PE_HLTH_INS_ALL

3704:
3705: -- Health- HEALTH_INFO
3706: -- Health Insurance
3707: CURSOR c_health_insu(cp_person_id igs_ad_appl.person_id%TYPE) IS
3708: SELECT 'x' FROM IGS_PE_HLTH_INS_ALL
3709: WHERE person_id = cp_person_id
3710: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);
3711:
3712: -- Immunization