DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on JL_AR_AP_TRX_DGI_CODES

Line 7834: FROM jl_ar_ap_trx_dgi_codes dgi,

7830: ' GET_DGI_CODE : i : '||to_char(p_org_id_tbl(i)));
7831: END IF;
7832: SELECT dgi_code
7833: INTO x_dgi_code_tbl(i)
7834: FROM jl_ar_ap_trx_dgi_codes dgi,
7835: ra_cust_trx_types_all rctt
7836: WHERE trx_letter = substr(p_trx_number_tbl(i),1,1)
7837: AND rctt.cust_trx_type_id = P_TRX_CATEGORY_TBL(i)
7838: AND rctt.org_id = p_org_id_tbl(i)