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_CO_PROCESS dependencies on JTF_FM_STATUS

Line 520: request_id IN (SELECT request_id FROM jtf_fm_status));

516: and adm_application_number = cp_application_id
517: and nominated_course_cd = cp_course_cd
518: and sequence_number = cp_adm_seq_no
519: and ( comp_status = 'SUCCESS' OR
520: request_id IN (SELECT request_id FROM jtf_fm_status));
521:
522: l_cur_c1_part1 cur_c1_part1%ROWTYPE;
523:
524: CURSOR cur_c1_part2 (cp_document_id NUMBER,

Line 539: request_id IN (SELECT request_id FROM jtf_fm_status));

535: and adm_application_number = cp_application_id
536: and nominated_course_cd = cp_course_cd
537: and sequence_number = cp_adm_seq_no
538: and ( comp_status = 'SUCCESS' OR
539: request_id IN (SELECT request_id FROM jtf_fm_status));
540:
541: l_cur_c1_part2 cur_c1_part2%ROWTYPE;
542:
543: CURSOR cur_adhoc1_part1 (cp_document_id NUMBER,

Line 550: request_id IN (SELECT request_id FROM jtf_fm_status));

546: FROM igs_co_interaction_history_v
547: WHERE document_id = cp_document_id
548: and student_id = cp_person_id
549: and ( comp_status = 'SUCCESS' OR
550: request_id IN (SELECT request_id FROM jtf_fm_status));
551:
552:
553: CURSOR cur_adhoc1_part2 (cp_document_id NUMBER,
554: cp_person_id NUMBER)IS

Line 562: request_id IN (SELECT request_id FROM jtf_fm_status));

558: FROM IGS_CO_COV_LTR_RELS
559: WHERE BASE_ITEM_ID = cp_document_id)
560: and student_id = cp_person_id
561: and ( comp_status = 'SUCCESS' OR
562: request_id IN (SELECT request_id FROM jtf_fm_status));
563:
564: l_cur_adhoc1_part1 cur_adhoc1_part1%ROWTYPE;
565: l_cur_adhoc1_part2 cur_adhoc1_part2%ROWTYPE;
566:

Line 576: request_id IN (SELECT request_id FROM jtf_fm_status));

572: WHERE document_id = cp_document_id
573: and student_id = cp_person_id
574: and adm_application_number = cp_application_id
575: and ( comp_status = 'SUCCESS' OR
576: request_id IN (SELECT request_id FROM jtf_fm_status));
577:
578: CURSOR cur_adackmt1_part2 (cp_document_id NUMBER,
579: cp_person_id NUMBER,
580: cp_application_id NUMBER)IS

Line 589: request_id IN (SELECT request_id FROM jtf_fm_status));

585: WHERE BASE_ITEM_ID = cp_document_id)
586: and student_id = cp_person_id
587: and adm_application_number = cp_application_id
588: and ( comp_status = 'SUCCESS' OR
589: request_id IN (SELECT request_id FROM jtf_fm_status));
590:
591:
592: l_cur_adackmt1_part1 cur_adackmt1_part1%ROWTYPE;
593: l_cur_adackmt1_part2 cur_adackmt1_part2%ROWTYPE;