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
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
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