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_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_DEPD_ACTIVE

Line 3648: FROM igs_pe_depd_active dep,

3644: reason_code,
3645: dep.REMARKS comments,
3646: rel.COMMENTS rel_remarks,
3647: decode (RELATIONSHIP_CODE,'PARENT_OF','02','SPOUSE_OF','01','XX' ) relationship
3648: FROM igs_pe_depd_active dep,
3649: HZ_RELATIONSHIPS rel
3650: WHERE subject_id = p_person_rec.person_id
3651: AND rel.relationship_id = dep.relationship_id
3652: AND (p_person_rec.record_status = 'C' OR dep.action_code ='A') --In the new mode report only about active dependents

Line 3657: FROM igs_pe_depd_active dep1

3653: AND RELATIONSHIP_CODE IN ('PARENT_OF','SPOUSE_OF' )
3654: AND (dep.relationship_id, effective_date) IN
3655: ( SELECT dep1.relationship_id,
3656: MAX(dep1.effective_date)
3657: FROM igs_pe_depd_active dep1
3658: WHERE dep1.relationship_id = rel.relationship_id
3659: GROUP BY dep1.relationship_id)
3660: AND rel.status = 'A';
3661: