APPS.IGS_UC_QUAL_DETS_IMP_PKG dependencies on HZ_PARTIES

Line 43: --jbaber modified to use hz_parties rather than igs_pe_person for performance - bug 5210481

39:
40: /* This is to get the person id from the oss table for the corresponding person number */
41: --smaddali 27-jun-2002 added condition that oss_person_id should be not null for bug 2430139
42: --smaddali selecting new columns iua.app_no and pe.person_number for bug 2430139 ,to show in log file
43: --jbaber modified to use hz_parties rather than igs_pe_person for performance - bug 5210481
44: CURSOR Cur_person_id (l_subject_id igs_uc_app_results.subject_id%TYPE) IS
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

Line 50: HZ_PARTIES pe

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
54: AND pe.party_id = iua.oss_person_id ;

Line 651: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841

647:
648:
649: -- For validating Awarding Body
650: -- anwest 09-Jun-05
651: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
652: CURSOR cur_awd_body IS
653: SELECT 'X'
654: FROM hz_parties hp,
655: igs_pe_hz_parties ihp,

Line 654: FROM hz_parties hp,

650: -- anwest 09-Jun-05
651: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
652: CURSOR cur_awd_body IS
653: SELECT 'X'
654: FROM hz_parties hp,
655: igs_pe_hz_parties ihp,
656: igs_or_org_inst_type oit,
657: igs_or_inst_stat ois
658: WHERE hp.party_id = ihp.party_id

Line 655: igs_pe_hz_parties ihp,

651: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
652: CURSOR cur_awd_body IS
653: SELECT 'X'
654: FROM hz_parties hp,
655: igs_pe_hz_parties ihp,
656: igs_or_org_inst_type oit,
657: igs_or_inst_stat ois
658: WHERE hp.party_id = ihp.party_id
659: AND ihp.oss_org_unit_cd = p_uc_qual_cur.awarding_body