APPS.IGF_AP_LG_TD_IMP dependencies on IGS_CA_INST

Line 230: FROM igs_ca_inst

226: CURSOR c_get_alternate_code(cp_cal_type VARCHAR2,
227: cp_seq_number NUMBER)
228: IS
229: SELECT alternate_code
230: FROM igs_ca_inst
231: WHERE cal_type = cp_cal_type
232: AND sequence_number = cp_seq_number;
233:
234: l_get_alternate_code c_get_alternate_code%ROWTYPE;

Line 324: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

320:
321: -- museshad (FA 140)
322: CURSOR c_item_system_todo_type_code(
323: cp_item_code VARCHAR2,
324: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
325: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
326: )
327: IS
328: SELECT system_todo_type_code

Line 325: cp_seq_number igs_ca_inst_all.sequence_number%TYPE

321: -- museshad (FA 140)
322: CURSOR c_item_system_todo_type_code(
323: cp_item_code VARCHAR2,
324: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
325: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
326: )
327: IS
328: SELECT system_todo_type_code
329: FROM igf_ap_td_item_mst_all