APPS.JL_AR_RECUR_PKG dependencies on RA_BATCH_SOURCES

Line 19: p_batch_source_id IN ra_batch_sources.batch_source_id%type,

15: p_term_discount_date IN DATE,
16: p_request_id IN ra_recur_interim.request_id%type,
17: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
18: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
19: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
20: p_trx_number_out OUT ra_recur_interim.trx_number%type) IS
21:
22: l_country_code VARCHAR2(2);
23: l_trx_num_cursor INTEGER;

Line 63: 'from ra_batch_sources ' ||

59: 'select ra_trx_number_' ||
60: REPLACE(p_batch_source_id, '-', 'N') ||
61: l_org_str||
62: '_s.nextval trx_number ' ||
63: 'from ra_batch_sources ' ||
64: 'where batch_source_id = ' ||
65: p_batch_source_id ||
66: ' and auto_trx_numbering_flag = ''Y''',
67: dbms_sql.v7);