DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on AP_BATCHES_ALL

Line 2338: lv_batch_name ap_batches_all.batch_name%TYPE;

2334: p_org_id number default null) --added org_id parameter for bug#9149941
2335: RETURN VARCHAR2 IS
2336:
2337: lv_same_tds_batch VARCHAR2(1);
2338: lv_batch_name ap_batches_all.batch_name%TYPE;
2339: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type ;
2340: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_Value%type ;
2341:
2342: CURSOR c_regime_cur IS

Line 2359: ap_batches_all b

2355: CURSOR c_batch_name(cp_invoice_id NUMBER)
2356: IS
2357: SELECT b.batch_name
2358: FROM ap_invoices_all a,
2359: ap_batches_all b
2360: WHERE a.batch_id = b.batch_id
2361: AND a.invoice_id = cp_invoice_id;
2362:
2363: BEGIN