DBA Data[Home] [Help]

APPS.AR_BR_FORMAT_WRAPPER_PKG dependencies on RA_CUSTOMER_TRX

Line 32: , ra_customer_trx trx

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
35: and trx.batch_id = v_br_id;
36:

Line 42: , ra_customer_trx trx

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
45: and types.cust_trx_type_id = trx.cust_trx_type_id
46: and sched.customer_trx_id = trx.customer_trx_id

Line 55: , ra_customer_trx trx

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
58: and trx.customer_trx_id = v_br_id;
59: