DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on AP_BATCHES_ALL

Line 2115: lv_batch_name ap_batches_all.batch_name%TYPE;

2111: FUNCTION get_tds_invoice_batch(p_invoice_id IN NUMBER)
2112: RETURN VARCHAR2 IS
2113:
2114: lv_same_tds_batch VARCHAR2(1);
2115: lv_batch_name ap_batches_all.batch_name%TYPE;
2116: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type ;
2117: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_Value%type ;
2118:
2119: CURSOR c_regime_cur IS

Line 2135: ap_batches_all b

2131: CURSOR c_batch_name(cp_invoice_id NUMBER)
2132: IS
2133: SELECT b.batch_name
2134: FROM ap_invoices_all a,
2135: ap_batches_all b
2136: WHERE a.batch_id = b.batch_id
2137: AND a.invoice_id = cp_invoice_id;
2138:
2139: BEGIN