APPS.IGS_PS_SCH_INT_API_PUB dependencies on IGS_CA_INST

Line 65: CURSOR c_cal(cp_c_cal_type igs_ca_inst.cal_type%TYPE,

61: FROM igs_ps_usec_occurs_all
62: WHERE unit_section_occurrence_id = cp_n_usec_id;
63:
64: -- Cursor added as part of Enh bug#2833850
65: CURSOR c_cal(cp_c_cal_type igs_ca_inst.cal_type%TYPE,
66: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
67: SELECT start_dt ,end_dt
68: FROM igs_ca_inst
69: WHERE cal_type = cp_c_cal_type AND

Line 66: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS

62: WHERE unit_section_occurrence_id = cp_n_usec_id;
63:
64: -- Cursor added as part of Enh bug#2833850
65: CURSOR c_cal(cp_c_cal_type igs_ca_inst.cal_type%TYPE,
66: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
67: SELECT start_dt ,end_dt
68: FROM igs_ca_inst
69: WHERE cal_type = cp_c_cal_type AND
70: sequence_number = cp_n_sequence_number;

Line 68: FROM igs_ca_inst

64: -- Cursor added as part of Enh bug#2833850
65: CURSOR c_cal(cp_c_cal_type igs_ca_inst.cal_type%TYPE,
66: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
67: SELECT start_dt ,end_dt
68: FROM igs_ca_inst
69: WHERE cal_type = cp_c_cal_type AND
70: sequence_number = cp_n_sequence_number;
71:
72: -- Cursor added as part of Enh bug#2833850

Line 414: FROM igs_ca_inst_all

410: DECLARE
411: CURSOR cur_cal(cp_cal_type IN VARCHAR2,
412: cp_sequence_number IN NUMBER) IS
413: SELECT *
414: FROM igs_ca_inst_all
415: WHERE cal_type=cp_cal_type
416: AND sequence_number=cp_sequence_number;
417: l_cur_cal cur_cal%ROWTYPE;
418: