APPS.JAI_CMN_SETUP_PKG dependencies on RA_BATCH_SOURCES_ALL

Line 18: v_order_type ra_batch_sources_all.name%type; --Ramananda bug#4171671

14: As
15:
16: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
17: v_register_meaning ja_lookups.meaning%type;
18: v_order_type ra_batch_sources_all.name%type; --Ramananda bug#4171671
19: v_invoice_type ra_batch_sources_all.name%type;
20: v_start_number Number;
21: v_prefix JAI_CMN_RG_EXC_INV_NOS.prefix%type;
22: v_jump_by Number;

Line 19: v_invoice_type ra_batch_sources_all.name%type;

15:
16: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
17: v_register_meaning ja_lookups.meaning%type;
18: v_order_type ra_batch_sources_all.name%type; --Ramananda bug#4171671
19: v_invoice_type ra_batch_sources_all.name%type;
20: v_start_number Number;
21: v_prefix JAI_CMN_RG_EXC_INV_NOS.prefix%type;
22: v_jump_by Number;
23: v_end_number Number;

Line 56: from ra_batch_sources_all

52: where transaction_type_id = p_order_invoice_type_id;
53:
54: Cursor c_get_invoice_type is
55: Select name
56: from ra_batch_sources_all
57: where batch_source_id = p_order_invoice_type_id;
58:
59: Cursor c_get_register(p_orgn_id number,p_locn_id number,p_order_flag varchar2) is
60: select a.register_code