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_PE_PERSON_SS_PKG dependencies on IGS_PE_HZ_REL

Line 2310: FROM hz_relationships hrel,igs_pe_hz_rel prel

2306: WHERE forward_rel_code = cp_rel_code;
2307:
2308: CURSOR c_primary(cp_subject_id NUMBER) IS
2309: SELECT 'X' ,prel.LAST_UPDATE_DATE
2310: FROM hz_relationships hrel,igs_pe_hz_rel prel
2311: WHERE hrel.relationship_id = prel.relationship_id
2312: AND hrel.directional_flag = prel.directional_flag
2313: AND hrel.subject_id = cp_subject_id
2314: AND prel.primary = 'Y';

Line 2318: FROM hz_relationships hrel,igs_pe_hz_rel prel

2314: AND prel.primary = 'Y';
2315:
2316: CURSOR c_secondary(cp_subject_id NUMBER) IS
2317: SELECT 'X' ,prel.LAST_UPDATE_DATE
2318: FROM hz_relationships hrel,igs_pe_hz_rel prel
2319: WHERE hrel.relationship_id = prel.relationship_id
2320: AND hrel.directional_flag = prel.directional_flag
2321: AND hrel.subject_id = cp_subject_id
2322: AND prel.secondary = 'Y';