APPS.IGF_GR_LI_IMPORT dependencies on IGS_CA_INST_ALL

Line 2486: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

2482: */
2483:
2484: -- Cursor to fetch alternate code for the given Cal Type and Sequence Number
2485: CURSOR c_get_alternate_code(
2486: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2487: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
2488: ) IS
2489: SELECT ca.alternate_code
2490: FROM igs_ca_inst_all ca

Line 2487: cp_seq_number igs_ca_inst_all.sequence_number%TYPE

2483:
2484: -- Cursor to fetch alternate code for the given Cal Type and Sequence Number
2485: CURSOR c_get_alternate_code(
2486: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2487: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
2488: ) IS
2489: SELECT ca.alternate_code
2490: FROM igs_ca_inst_all ca
2491: WHERE ca.cal_type = cp_cal_type

Line 2490: FROM igs_ca_inst_all ca

2486: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2487: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
2488: ) IS
2489: SELECT ca.alternate_code
2490: FROM igs_ca_inst_all ca
2491: WHERE ca.cal_type = cp_cal_type
2492: AND ca.sequence_number = cp_seq_number;
2493:
2494: lc_get_alternate_code c_get_alternate_code%ROWTYPE;