DBA Data[Home] [Help]

APPS.IGS_PS_SCH_INT_API_PUB dependencies on IGS_PS_USEC_OCCURS_ALL

Line 59: CURSOR cur_usec(cp_n_usec_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

55: l_api_name CONSTANT VARCHAR2(30) := 'Insert_sch';
56: l_api_version CONSTANT NUMBER := 1.0;
57:
58: -- Cursor added as part of Enh bug#2833850
59: CURSOR cur_usec(cp_n_usec_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
60: SELECT *
61: FROM igs_ps_usec_occurs_all
62: WHERE unit_section_occurrence_id = cp_n_usec_id;
63:

Line 61: FROM igs_ps_usec_occurs_all

57:
58: -- Cursor added as part of Enh bug#2833850
59: CURSOR cur_usec(cp_n_usec_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
60: SELECT *
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,