APPS.IGS_CO_PROCESS dependencies on IGS_CO_INTERACTION_HISTORY_V

Line 513: FROM igs_co_interaction_history_v

509: cp_application_id NUMBER,
510: cp_course_cd VARCHAR2,
511: cp_adm_seq_no NUMBER)IS
512: SELECT count(*) cnt, max(requested_date) max_requested_date
513: FROM igs_co_interaction_history_v
514: WHERE document_id = cp_document_id
515: and student_id = cp_person_id
516: and adm_application_number = cp_application_id
517: and nominated_course_cd = cp_course_cd

Line 530: FROM igs_co_interaction_history_v

526: cp_application_id NUMBER,
527: cp_course_cd VARCHAR2,
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

Line 546: FROM igs_co_interaction_history_v

542:
543: CURSOR cur_adhoc1_part1 (cp_document_id NUMBER,
544: cp_person_id NUMBER)IS
545: SELECT count(1) cnt, max(requested_date) max_requested_date
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));

Line 556: FROM igs_co_interaction_history_v

552:
553: CURSOR cur_adhoc1_part2 (cp_document_id NUMBER,
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

Line 571: FROM igs_co_interaction_history_v

567: CURSOR cur_adackmt1_part1 (cp_document_id NUMBER,
568: cp_person_id NUMBER,
569: cp_application_id NUMBER)IS
570: SELECT count(1) cnt, max(requested_date) max_requested_date
571: FROM igs_co_interaction_history_v
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

Line 582: FROM igs_co_interaction_history_v

578: CURSOR cur_adackmt1_part2 (cp_document_id NUMBER,
579: cp_person_id NUMBER,
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

Line 2288: FROM igs_co_interaction_history_v

2284:
2285: CURSOR cur_gen_update IS
2286: SELECT request_id,
2287: comp_status
2288: FROM igs_co_interaction_history_v
2289: WHERE comp_status IN ('SUBMITTED'); --Modified by Prajeesh to change NOT IN to IN as it will never change SUBMITED TO OTHER
2290: --STATE if it is NOT IN operator
2291: l_cur_gen_update cur_gen_update%ROWTYPE;
2292: l_called_from_conc VARCHAR2(1);