APPS.IGS_PR_GEN_005 dependencies on IGS_AD_ADM_UNIT_STAT

Line 1559: FROM igs_ad_adm_unit_stat aus

1555: AND cir.sub_cal_type = sua.cal_type
1556: AND cir.sub_ci_sequence_number = sua.ci_sequence_number
1557: AND (sua.administrative_unit_status IS NULL
1558: OR sua.administrative_unit_status IN (SELECT aus.administrative_unit_status
1559: FROM igs_ad_adm_unit_stat aus
1560: WHERE aus.effective_progression_ind = 'Y')
1561: )
1562: ORDER BY DECODE (sua.unit_attempt_status, cst_enrolled, 1, cst_discontin, 2, cst_completed, 3);
1563: BEGIN