APPS.JL_AR_DOC_NUMBERING_PKG dependencies on JG_ZZ_AR_SRC_TRX_TY

Line 36: FROM jg_zz_ar_src_trx_ty st, ra_batch_sources_all src

32: -- Bug 8825457 End
33: BEGIN
34: SELECT 'Success'
35: INTO l_dummy_code
36: FROM jg_zz_ar_src_trx_ty st, ra_batch_sources_all src
37: WHERE st.cust_trx_type_id = p_trx_type
38: AND st.batch_source_id = p_batch_source_id
39: AND invoice_class = p_invoice_class
40: AND st.batch_source_id = src.batch_source_id

Line 86: FROM jg_zz_ar_src_trx_ty ty, ra_batch_sources_all src

82: WHERE a.batch_source_id = p_batch_source_id;
83: --
84: SELECT count(*)
85: INTO l_count
86: FROM jg_zz_ar_src_trx_ty ty, ra_batch_sources_all src
87: WHERE ty.cust_trx_type_id = p_trx_type
88: AND ty.batch_source_id = src.batch_source_id
89: AND substr(src.global_attribute3,1,1) <> p_document_letter
90: AND substr(src.global_attribute2,1,4) <> l_branch_number