APPS.IGF_AP_LI_BASE_REC_IMPORT dependencies on IGS_CA_INST

Line 91: CURSOR c_get_alternate_code(cp_cal_type igs_ca_inst.cal_type%TYPE,

87: AND ci_sequence_number = cp_seq_number;
88:
89: l_get_status c_get_status%ROWTYPE;
90:
91: CURSOR c_get_alternate_code(cp_cal_type igs_ca_inst.cal_type%TYPE,
92: cp_seq_number igs_ca_inst.sequence_number%TYPE)
93: IS
94: SELECT alternate_code
95: FROM igs_ca_inst

Line 92: cp_seq_number igs_ca_inst.sequence_number%TYPE)

88:
89: l_get_status c_get_status%ROWTYPE;
90:
91: CURSOR c_get_alternate_code(cp_cal_type igs_ca_inst.cal_type%TYPE,
92: cp_seq_number igs_ca_inst.sequence_number%TYPE)
93: IS
94: SELECT alternate_code
95: FROM igs_ca_inst
96: WHERE cal_type = cp_cal_type

Line 95: FROM igs_ca_inst

91: CURSOR c_get_alternate_code(cp_cal_type igs_ca_inst.cal_type%TYPE,
92: cp_seq_number igs_ca_inst.sequence_number%TYPE)
93: IS
94: SELECT alternate_code
95: FROM igs_ca_inst
96: WHERE cal_type = cp_cal_type
97: AND sequence_number = cp_seq_number;
98:
99: l_get_alternate_code c_get_alternate_code%ROWTYPE;