APPS.IGF_AP_LI_BASE_REC_IMPORT dependencies on IGF_AP_BATCH_AW_MAP

Line 78: CURSOR c_get_status(cp_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE,

74: l_create_base_rec BOOLEAN;
75:
76:
77: -- Cursor for getting the context award year details
78: CURSOR c_get_status(cp_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE,
79: cp_seq_number igf_ap_batch_aw_map.ci_sequence_number%TYPE)
80: IS
81: SELECT sys_award_year,
82: batch_year,

Line 79: cp_seq_number igf_ap_batch_aw_map.ci_sequence_number%TYPE)

75:
76:
77: -- Cursor for getting the context award year details
78: CURSOR c_get_status(cp_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE,
79: cp_seq_number igf_ap_batch_aw_map.ci_sequence_number%TYPE)
80: IS
81: SELECT sys_award_year,
82: batch_year,
83: award_year_status_code,

Line 85: FROM igf_ap_batch_aw_map

81: SELECT sys_award_year,
82: batch_year,
83: award_year_status_code,
84: css_academic_year
85: FROM igf_ap_batch_aw_map
86: WHERE ci_cal_type = cp_cal_type
87: AND ci_sequence_number = cp_seq_number;
88:
89: l_get_status c_get_status%ROWTYPE;