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_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_HZ_REL_V

Line 4592: FROM igs_pe_hz_rel_v hz

4588: WHERE person_id = p_id;
4589:
4590: CURSOR c_spouse_of_rel IS
4591: SELECT COUNT(1)
4592: FROM igs_pe_hz_rel_v hz
4593: WHERE hz.subject_id = p_person_rec.person_id AND
4594: hz.relationship_code= 'SPOUSE_OF' and
4595: sysdate BETWEEN hz.start_date AND NVL(hz.end_date, sysdate+1)
4596: AND EXISTS (SELECT 1 FROM igs_pe_depd_active pdep

Line 10585: FROM igs_pe_hz_rel_v hz, igs_pe_depd_active pdep

10581: l_rel_type_count NUMBER := 0;
10582:
10583: /* CURSOR c_spouse_of_rel IS
10584: SELECT COUNT(1)
10585: FROM igs_pe_hz_rel_v hz, igs_pe_depd_active pdep
10586: WHERE hz.subject_id = p_person_rec.person_id AND
10587: hz.relationship_code= 'SPOUSE_OF' and
10588: pdep.relationship_id = hz.relationship_id
10589: and pdep.action_code <> 'T'