APPS.IGS_PR_PROUT_LGCY_PUB dependencies on IGS_EN_UNIT_SET

Line 999: (NOT igs_en_unit_set_pkg.get_pk_for_validation (

995: -- Unit Set Existence
996: --
997: IF ((p_lgcy_prout_rec.unit_set_cd IS NOT NULL) AND
998: (p_lgcy_prout_rec.us_version_number IS NOT NULL) AND
999: (NOT igs_en_unit_set_pkg.get_pk_for_validation (
1000: p_lgcy_prout_rec.unit_set_cd,
1001: p_lgcy_prout_rec.us_version_number
1002: ))) THEN
1003: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_USET_UNITSET_FK');

Line 1058: FROM igs_en_unit_set us,

1054: ) RETURN BOOLEAN IS
1055: --
1056: CURSOR cur_us_uss IS
1057: SELECT 'Y'
1058: FROM igs_en_unit_set us,
1059: igs_en_unit_set_stat uss
1060: WHERE us.unit_set_cd = p_lgcy_prout_rec.unit_set_cd
1061: AND us.version_number = p_lgcy_prout_rec.us_version_number
1062: AND us.unit_set_status = uss.unit_set_status

Line 1059: igs_en_unit_set_stat uss

1055: --
1056: CURSOR cur_us_uss IS
1057: SELECT 'Y'
1058: FROM igs_en_unit_set us,
1059: igs_en_unit_set_stat uss
1060: WHERE us.unit_set_cd = p_lgcy_prout_rec.unit_set_cd
1061: AND us.version_number = p_lgcy_prout_rec.us_version_number
1062: AND us.unit_set_status = uss.unit_set_status
1063: AND uss.s_unit_set_status <> 'PLANNED';