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.IGF_SL_LAR_CREATION dependencies on IGS_PE_RELATIONSHIPS_V

Line 191: igs_pe_relationships_v v,

187: COUNT(v.row_id) parent_count,
188: MIN(v.object_ID) student_id,
189: MIN(v.SUBJECT_ID) parent_id
190: FROM
191: igs_pe_relationships_v v,
192: igf_aw_award_all awd,
193: igf_sl_loans_all loans,
194: igf_ap_fa_base_rec base
195: WHERE

Line 288: igs_pe_relationships_v v

284: l_cur_fa_rec cur_fa_mapping%ROWTYPE;
285: -- Bug # 4636920 - bvisvana
286: CURSOR cur_stud_rel (cp_parent_id NUMBER , cp_student_id NUMBER) IS
287: SELECT relationship_code FROM
288: igs_pe_relationships_v v
289: WHERE v.object_id = cp_student_id AND -- child
290: v.subject_id = cp_parent_id AND -- parent
291: TRUNC(SYSDATE) BETWEEN v.start_date and NVL(v.end_date, SYSDATE);
292: rel_code VARCHAR2(30);

Line 2076: igs_pe_relationships_v v,

2072: ) IS
2073: SELECT
2074: 'X'
2075: FROM
2076: igs_pe_relationships_v v,
2077: igf_aw_award_all awd,
2078: igf_sl_loans_all loans,
2079: igf_ap_fa_base_rec base
2080: WHERE