APPS.IGS_FI_CRDAPI_UTIL dependencies on IGF_AP_BATCH_AW_MAP

Line 48: FROM igf_ap_batch_aw_map

44: --Cursor to fetch the award year status code for the specified award year.
45: CURSOR cur_awd_yr_status(cp_v_cal_type VARCHAR2,
46: cp_n_ci_seq_number NUMBER) IS
47: SELECT award_year_status_code
48: FROM igf_ap_batch_aw_map
49: WHERE ci_cal_type = cp_v_cal_type
50: AND ci_sequence_number = cp_n_ci_seq_number;
51:
52: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;

Line 52: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;

48: FROM igf_ap_batch_aw_map
49: WHERE ci_cal_type = cp_v_cal_type
50: AND ci_sequence_number = cp_n_ci_seq_number;
51:
52: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
53:
54: BEGIN
55:
56: --Both input parameters are mandatory to this procedure, if either of them is null, return from the procedure

Line 332: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;

328: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
329: l_v_ld_ci_seq_num igs_ca_inst.sequence_number%TYPE;
330: l_b_return_status BOOLEAN;
331: l_v_message_name fnd_new_messages.message_name%TYPE;
332: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
333:
334: FUNCTION get_cr_type(p_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) RETURN VARCHAR2 AS
335: /***********************************************************************************************
336: Created By: shtatiko