APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_CA_INST_ALL

Line 473: CURSOR cur_get_cal_inst_desc(p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

469: WHERE ps.person_id = p_person_id
470: AND ps.course_cd = p_course_cd;
471:
472: -- Bug 5123583, Created the Cursor to fetch Teaching calendar description
473: CURSOR cur_get_cal_inst_desc(p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
474: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
475: ) IS
476: SELECT description
477: FROM igs_ca_inst_all ca

Line 474: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

470: AND ps.course_cd = p_course_cd;
471:
472: -- Bug 5123583, Created the Cursor to fetch Teaching calendar description
473: CURSOR cur_get_cal_inst_desc(p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
474: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
475: ) IS
476: SELECT description
477: FROM igs_ca_inst_all ca
478: WHERE ca.cal_type = p_v_cal_type

Line 477: FROM igs_ca_inst_all ca

473: CURSOR cur_get_cal_inst_desc(p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
474: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
475: ) IS
476: SELECT description
477: FROM igs_ca_inst_all ca
478: WHERE ca.cal_type = p_v_cal_type
479: AND ca.sequence_number = p_n_sequence_number;
480:
481: -- Declaration of local variables

Line 516: l_v_cal_inst_desc igs_ca_inst_all.description%TYPE := NULL;

512:
513: l_v_dcnt_reason_cd_desc igs_en_dcnt_reasoncd_v.description%TYPE;
514:
515: --Bug 5123583, variable declared to fetch calendar description from cur_get_cal_inst_desc.
516: l_v_cal_inst_desc igs_ca_inst_all.description%TYPE := NULL;
517:
518:
519: TYPE tab_chrgs_rec IS TABLE OF cur_person_chrgs%ROWTYPE INDEX BY BINARY_INTEGER;
520: v_tab_chrgs_rec tab_chrgs_rec;