DBA Data[Home] [Help]

APPS.IGF_SE_GEN_001 dependencies on IGF_AP_BATCH_AW_MAP

Line 1240: l_sys_awd_status igf_ap_batch_aw_map.award_year_status_code%TYPE;

1236: l_paid_amount igf_se_payment_int.paid_amount%TYPE;
1237: l_status igf_se_payment_int.status%TYPE;
1238: l_error_cd igf_se_payment_int.error_code%TYPE;
1239: l_disb_amount igf_aw_awd_disb.disb_accepted_amt%TYPE DEFAULT 0;
1240: l_sys_awd_status igf_ap_batch_aw_map.award_year_status_code%TYPE;
1241:
1242: CURSOR c_auth (cv_auth_id igf_se_auth.auth_id%TYPE) IS
1243: SELECT rowid row_id,auth.*
1244: FROM igf_se_auth auth

Line 1251: FROM igf_ap_batch_aw_map

1247:
1248: CURSOR c_award_det(cp_cal_type VARCHAR2,
1249: cp_seq_number NUMBER) IS
1250: SELECT award_year_status_code
1251: FROM igf_ap_batch_aw_map
1252: WHERE ci_cal_type = cp_cal_type
1253: AND ci_sequence_number = cp_seq_number;
1254:
1255: CURSOR c_sum(