[Home] [Help]
659: and d.object_type = 'IEX_INVOICES');
660:
661: cursor c_get_invoice_ct (p_conc_req_id number) is
662: select count(idt.cust_trx_id)
663: from iex_dunning_transactions idt,
664: iex_dunnings dunn,
665: iex_ag_dn_xref xref,
666: ra_customer_trx trx
667: where idt.dunning_id = dunn.dunning_id
673: and trx.printing_option = 'PRI';
674:
675: cursor c_get_inv_count_in_errmode (p_conc_req_id number, p_max_dunn_trx_id number) is
676: select count(idt.cust_trx_id)
677: from iex_dunning_transactions idt,
678: iex_dunnings dunn,
679: iex_ag_dn_xref xref,
680: ra_customer_trx trx
681: where idt.dunning_id = dunn.dunning_id
688: and trx.printing_option = 'PRI';
689:
690: cursor c_max_dunning_trx_id (p_conc_req_id number) is
691: select max(idt.dunning_trx_id)
692: from iex_dunning_transactions idt,
693: iex_dunnings dunn
694: where idt.dunning_id = dunn.dunning_id
695: and dunn.request_id = p_conc_req_id;
696:
1404: end if; --if (p_dunning_mode = 'FINAL' and l_confirmation_mode is not null) then
1405:
1406: if p_dunning_mode = 'FINAL' and l_dunning_type = 'STAGED_DUNNING' then
1407: vPLSQL5 := 'select iet.payment_schedule_id, iet.stage_number ' ||
1408: 'from iex_dunnings dun, iex_dunning_transactions iet ' ||
1409: 'where dun.request_id = :1 ' ||
1410: ' and dun.dunning_id = iet.dunning_id ' ||
1411: ' and dun.delivery_status is null ' ||
1412: ' and iet.cust_trx_id is not null ' ||