APPS.IGS_CO_PROCESS dependencies on IGS_CO_COV_LTR_RELS

Line 499: Pacross 12-Sep-2005 Included references into the IGS_CO_COV_LTR_RELS table, to ensure all

495: Change History
496: Who When What
497:
498: (reverse chronological order - newest change first)
499: Pacross 12-Sep-2005 Included references into the IGS_CO_COV_LTR_RELS table, to ensure all
500: letters that were created as an edit of the current one are included in the
501: count
502: Bayadav 24-MAY-2002 Included two system letter codes 'ENADHOC', 'SFADHOC' for adhoc letters as
503: a part of bug 2376434

Line 532: FROM IGS_CO_COV_LTR_RELS

528: cp_adm_seq_no NUMBER)IS
529: SELECT count(1) cnt, max(requested_date) max_requested_date
530: FROM igs_co_interaction_history_v
531: WHERE document_id in (SELECT CHILD_ITEM_ID
532: FROM IGS_CO_COV_LTR_RELS
533: WHERE BASE_ITEM_ID = cp_document_id)
534: and student_id = cp_person_id
535: and adm_application_number = cp_application_id
536: and nominated_course_cd = cp_course_cd

Line 558: FROM IGS_CO_COV_LTR_RELS

554: cp_person_id NUMBER)IS
555: SELECT count(1) cnt, max(requested_date) max_requested_date
556: FROM igs_co_interaction_history_v
557: WHERE document_id in (SELECT CHILD_ITEM_ID
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));

Line 584: FROM IGS_CO_COV_LTR_RELS

580: cp_application_id NUMBER)IS
581: SELECT count(1) cnt, max(requested_date) max_requested_date
582: FROM igs_co_interaction_history_v
583: WHERE document_id in (SELECT CHILD_ITEM_ID
584: FROM IGS_CO_COV_LTR_RELS
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