DBA Data[Home] [Help]

APPS.IGS_AD_IMP_013 dependencies on IGS_OR_ORG_INST_TYPE_ALL

Line 1050: IGS_OR_ORG_INST_TYPE_ALL OIT

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
1054: AND HP.OI_INSTITUTION_TYPE = OIT.INSTITUTION_TYPE (+)