APPS.IGS_UC_QUAL_DETS_IMP_PKG dependencies on IGS_UC_APPLICANTS

Line 49: IGS_UC_APPLICANTS iua,

45: SELECT iua.app_no, pe.party_number person_number, iua.Oss_person_id person_id,
46: NVL(UPPER(TRIM(iuar.EBL_AMENDED_RESULT)),UPPER(TRIM(iuar.EBL_result))) ebl_result,
47: UPPER(TRIM(iuar.Claimed_result)) claimed_result
48: FROM IGS_UC_APP_RESULTS iuar,
49: IGS_UC_APPLICANTS iua,
50: HZ_PARTIES pe
51: WHERE iuar.Subject_id = l_subject_id
52: AND iuar.App_id = iua.App_id
53: AND iua.oss_person_id IS NOT NULL

Line 150: FROM igs_uc_applicants

146: cp_approved_result igs_uc_qual_dets.approved_result%TYPE) IS
147: SELECT 'X'
148: FROM igs_uc_app_results apr
149: WHERE apr.app_no IN ( SELECT app_no
150: FROM igs_uc_applicants
151: WHERE oss_person_id = cp_person_id
152: )
153: AND apr.subject_id IN ( SELECT subject_id
154: FROM igs_uc_com_ebl_subj