DBA Data[Home] [Help]

APPS.AR_BR_FORMAT_WRAPPER_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 30: from ra_cust_trx_types_all types

26:
27: -- Cursor For BR batches
28: CURSOR c_programs_br IS
29: select distinct prog.program_name program_name
30: from ra_cust_trx_types_all types
31: , ap_payment_programs prog
32: , ra_customer_trx trx
33: where types.format_program_id = prog.program_id
34: and types.cust_trx_type_id = trx.cust_trx_type_id

Line 40: from ra_cust_trx_types_all types

36:
37: -- Cursor for Remittance batches
38: CURSOR c_programs_remit IS
39: select distinct prog.program_name program_name
40: from ra_cust_trx_types_all types
41: , ap_payment_programs prog
42: , ra_customer_trx trx
43: , ar_payment_schedules sched
44: where types.format_program_id = prog.program_id

Line 53: from ra_cust_trx_types_all types

49:
50: -- For Individual BRs
51: CURSOR c_programs_ind IS
52: select distinct prog.program_name program_name
53: from ra_cust_trx_types_all types
54: , ap_payment_programs prog
55: , ra_customer_trx trx
56: where types.format_program_id = prog.program_id
57: and types.cust_trx_type_id = trx.cust_trx_type_id