DBA Data[Home] [Help]

APPS.IGS_AD_IMP_002 dependencies on IGS_PE_PERSON_ID_TYPE_V

Line 1145: igs_pe_person_id_type_v pit

1141: FROM
1142: hz_parties p,
1143: igs_pe_hz_parties pd,
1144: hz_person_profiles pp,
1145: igs_pe_person_id_type_v pit
1146: WHERE p.party_id = cp_person_id
1147: AND p.party_id = pit.pe_person_id (+)
1148: AND p.party_id = pd.party_id (+)
1149: AND p.party_id = pp.party_id

Line 3093: igs_pe_person_id_type_v pit

3089: SELECT 'X'
3090: FROM hz_parties p,
3091: igs_pe_hz_parties pd,
3092: hz_person_profiles pp,
3093: igs_pe_person_id_type_v pit
3094: WHERE p.party_id = cp_person_id
3095: AND p.party_id = pit.pe_person_id (+)
3096: AND p.party_id = pd.party_id (+)
3097: AND p.party_id = pp.party_id