DBA Data[Home] [Help]

APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_HE_ST_UNT_VS_ALL

Line 715: igs_he_st_unt_vs_all hunt

711: ua.version_number,
712: DECODE(hunt.hesa_st_unt_vs_id, NULL, 'N', 'Y') unit_flag, sysdate, 1, sysdate, 1
713: FROM igs_en_su_attempt_all ua,
714: igs_he_verify_data_t t,
715: igs_he_st_unt_vs_all hunt
716: WHERE t.person_id = ua.person_id
717: AND ua.unit_cd = hunt.unit_cd (+)
718: AND ua.version_number = hunt.version_number(+)
719: AND ua.unit_attempt_status IN ('ENROLLED','DISCONTIN','COMPLETED')

Line 729: igs_he_st_unt_vs_all hunt,

725: ua.version_number,
726: DECODE(hunt.hesa_st_unt_vs_id, NULL, 'N', 'Y') unit_flag, sysdate, 1, sysdate, 1
727: FROM igs_en_su_attempt_all ua,
728: igs_he_verify_data_t t,
729: igs_he_st_unt_vs_all hunt,
730: igs_as_su_stmptout_all uao
731: WHERE t.person_id = ua.person_id
732: AND ua.unit_cd = hunt.unit_cd (+)
733: AND ua.version_number = hunt.version_number(+)