eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_002 dependencies on HZ_PERSON_PROFILES

Line 1144: hz_person_profiles pp,

1140: pd.felony_convicted_flag
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 (+)

Line 3066: hz_person_profiles pp

3062: pp.date_of_birth birth_dt
3063: FROM
3064: hz_parties p,
3065: igs_pe_hz_parties pd,
3066: hz_person_profiles pp
3067: WHERE p.party_id = cp_person_id
3068: AND p.party_id = pd.party_id (+)
3069: AND p.party_id = pp.party_id
3070: AND SYSDATE BETWEEN pp.effective_start_date AND NVL(pp.effective_end_date,SYSDATE);

Line 3092: hz_person_profiles pp,

3088: c_person_rec person_cur%ROWTYPE) IS
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 (+)