APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_ISIR_CORR_ALL

Line 1444: cp_corr_status igf_ap_isir_corr_all.correction_status%TYPE

1440: AND im.payment_isir = 'Y';
1441:
1442:
1443: CURSOR cur_chk_batched ( cp_base_id igf_ap_isir_matched_all.base_id%TYPE,
1444: cp_corr_status igf_ap_isir_corr_all.correction_status%TYPE
1445: )
1446: IS
1447: SELECT isir.base_id
1448: FROM igf_ap_isir_matched_all isir,

Line 1449: igf_ap_isir_corr_all corr

1445: )
1446: IS
1447: SELECT isir.base_id
1448: FROM igf_ap_isir_matched_all isir,
1449: igf_ap_isir_corr_all corr
1450: WHERE isir.base_id = cp_base_id
1451: AND isir.isir_id = corr.isir_id
1452: AND NVL(corr.correction_status,'X') = cp_corr_status;
1453: