APPS.JL_AR_DOC_NUMBERING_PKG dependencies on JG_ZZ_AR_SRC_TRX_TY

Line 32: FROM jg_zz_ar_src_trx_ty st, ra_batch_sources_all src

28: END IF;
29: BEGIN
30: SELECT 'Success'
31: INTO l_dummy_code
32: FROM jg_zz_ar_src_trx_ty st, ra_batch_sources_all src
33: WHERE st.cust_trx_type_id = p_trx_type
34: AND st.batch_source_id = p_batch_source_id
35: AND invoice_class = p_invoice_class
36: AND st.batch_source_id = src.batch_source_id

Line 79: FROM jg_zz_ar_src_trx_ty ty, ra_batch_sources_all src

75: WHERE a.batch_source_id = p_batch_source_id;
76: --
77: SELECT count(*)
78: INTO l_count
79: FROM jg_zz_ar_src_trx_ty ty, ra_batch_sources_all src
80: WHERE ty.cust_trx_type_id = p_trx_type
81: AND ty.batch_source_id = src.batch_source_id
82: AND substr(src.global_attribute3,1,1) <> p_document_letter
83: AND substr(src.global_attribute2,1,4) <> l_branch_number