APPS.AR_BR_FORMAT_WRAPPER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

select distinct prog.program_name program_name
from ra_cust_trx_types_all types
,  ap_payment_programs prog
,  ra_customer_trx trx
where types.format_program_id = prog.program_id
and types.cust_trx_type_id = trx.cust_trx_type_id
and trx.batch_id = v_br_id;

Line: 39

select distinct prog.program_name program_name
from ra_cust_trx_types_all types
,  ap_payment_programs prog
,  ra_customer_trx trx
,  ar_payment_schedules sched
where types.format_program_id = prog.program_id
and types.cust_trx_type_id = trx.cust_trx_type_id
and sched.customer_trx_id = trx.customer_trx_id
and sched.reserved_type = 'REMITTANCE'
and sched.reserved_value = v_br_id;

Line: 52

select distinct prog.program_name program_name
from ra_cust_trx_types_all types
,  ap_payment_programs prog
,  ra_customer_trx trx
where types.format_program_id = prog.program_id
and types.cust_trx_type_id = trx.cust_trx_type_id
and trx.customer_trx_id = v_br_id;

Line: 63

select org_id
into l_org_id
from fnd_concurrent_requests
where request_id = FND_PROFILE.value('CONC_REQUEST_ID');