DBA Data[Home] [Help]

APPS.IGS_AD_IMP_013 dependencies on IGS_PE_HZ_PARTIES

Line 1041: igs_pe_hz_parties hp

1037: CURSOR c_val_inst_cd_non_uk_cur IS
1038: SELECT hp.rowid row_id
1039: FROM
1040: hz_parties p,
1041: igs_pe_hz_parties hp
1042: WHERE hp.party_id = p.party_id
1043: AND hp.inst_org_ind = 'I'
1044: AND p.party_number = person_history_rec.institution_code;
1045:

Line 1049: IGS_PE_HZ_PARTIES HP,

1045:
1046: CURSOR c_val_inst_cd_uk_cur IS
1047: SELECT HP.rowid row_id
1048: FROM HZ_PARTIES P,
1049: IGS_PE_HZ_PARTIES HP,
1050: IGS_OR_ORG_INST_TYPE_ALL OIT
1051: WHERE HP.PARTY_ID = P.PARTY_ID
1052: AND HP.INST_ORG_IND = 'I'
1053: AND p.party_number = person_history_rec.institution_code