APPS.IGF_GR_LI_IMPORT dependencies on IGS_CA_INST

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;

Line 2498: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

2494: lc_get_alternate_code c_get_alternate_code%ROWTYPE;
2495:
2496: -- cursor to verify if the cal_type and seq_number are present in the system award year
2497: CURSOR c_sys_awd_yr_dtls(
2498: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
2499: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
2500: ) IS
2501: SELECT bam.alternate_code, bam.award_year_status_code, bam.sys_award_year
2502: FROM igf_ap_batch_aw_map_v bam

Line 2499: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE

2495:
2496: -- cursor to verify if the cal_type and seq_number are present in the system award year
2497: CURSOR c_sys_awd_yr_dtls(
2498: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
2499: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
2500: ) IS
2501: SELECT bam.alternate_code, bam.award_year_status_code, bam.sys_award_year
2502: FROM igf_ap_batch_aw_map_v bam
2503: WHERE bam.ci_cal_type = cp_ci_cal_type

Line 2510: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

2506: lc_sys_awd_yr_dtls c_sys_awd_yr_dtls%ROWTYPE;
2507:
2508: -- Get the details of
2509: CURSOR c_check_setups(
2510: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
2511: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
2512: ) IS
2513: SELECT 'x'
2514: FROM DUAL

Line 2511: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE

2507:
2508: -- Get the details of
2509: CURSOR c_check_setups(
2510: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
2511: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
2512: ) IS
2513: SELECT 'x'
2514: FROM DUAL
2515: WHERE EXISTS(