APPS.IEX_DUNNING_PVT dependencies on IEX_DUNNING_PLANS_B

Line 2717: iex_dunning_plans_b dunn

2713: cursor c_dunn_plan_line_dtls (p_ag_dn_xref_id number) is
2714: select nvl(dunn.include_current ,'N'),
2715: nvl(dunn.include_unused_payments_flag,'N')
2716: from iex_ag_dn_xref xref,
2717: iex_dunning_plans_b dunn
2718: where AG_DN_XREF_ID = p_ag_dn_xref_id
2719: and xref.dunning_plan_id = dunn.dunning_plan_id;
2720:
2721: x_dunning_trx_id number;

Line 4238: from iex_dunning_plans_b dunn

4234: cursor c_dunning_plan_dtl (p_dunn_plan_id number) is
4235: select nvl(dunn.INCLUDE_CURRENT,'N'),
4236: nvl(dunn.grace_days ,'N'),
4237: nvl(dunn.dun_disputed_items, 'N')
4238: from iex_dunning_plans_b dunn
4239: where dunning_plan_id = p_dunn_plan_id;
4240:
4241: cursor c_cust_acct_amt_due_rem(p_party_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
4242: select nvl(sum(aps.acctd_amount_due_remaining),0)

Line 5349: from iex_dunning_plans_b dunn

5345: cursor c_dunning_plan_dtl (p_dunn_plan_id number) is
5346: select nvl(dunn.INCLUDE_CURRENT,'N'),
5347: nvl(dunn.grace_days ,'N'),
5348: nvl(dunn.dun_disputed_items, 'N')
5349: from iex_dunning_plans_b dunn
5350: where dunning_plan_id = p_dunn_plan_id;
5351:
5352: l_dunningplan_lines c_dunningplan_lines%rowtype;
5353:

Line 6984: from iex_dunning_plans_b dunn

6980: --
6981: cursor c_dunning_plan_dtl (p_dunn_plan_id number) is
6982: select nvl(dunn.grace_days ,'N'),
6983: nvl(dunn.dun_disputed_items, 'N')
6984: from iex_dunning_plans_b dunn
6985: where dunning_plan_id = p_dunn_plan_id;
6986:
6987: cursor c_billto (p_customer_site_use_id number,p_org_id number) is
6988: select currency_code, nvl(min_dunning_invoice_amount,0) from hz_cust_profile_amts

Line 8119: from iex_dunning_plans_b dunn

8115:
8116: cursor c_dunning_plan_dtl (p_dunn_plan_id number) is
8117: select nvl(dunn.grace_days ,'N'),
8118: nvl(dunn.dun_disputed_items, 'N')
8119: from iex_dunning_plans_b dunn
8120: where dunning_plan_id = p_dunn_plan_id;
8121:
8122: cursor c_billto_min_dunn_amt (p_site_use_id number, p_currency_code varchar) is
8123: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)

Line 9194: from iex_dunning_plans_b dunn

9190:
9191: cursor c_dunning_plan_dtl (p_dunn_plan_id number) is
9192: select nvl(dunn.grace_days ,'N'),
9193: nvl(dunn.dun_disputed_items, 'N')
9194: from iex_dunning_plans_b dunn
9195: where dunning_plan_id = p_dunn_plan_id;
9196:
9197: cursor c_as_of_date (p_dunning_id number) is
9198: select nvl(dunn.as_of_date,sysdate)

Line 11237: from iex_dunning_plans_b dunn

11233: --
11234: cursor c_dunning_plan_dtl (p_dunn_plan_id number) is
11235: select nvl(dunn.grace_days ,'N'),
11236: nvl(dunn.dun_disputed_items, 'N')
11237: from iex_dunning_plans_b dunn
11238: where dunning_plan_id = p_dunn_plan_id;
11239:
11240: l_AMOUNT NUMBER;
11241: l_CURR_CODE VARCHAR2(15);

Line 14345: from IEX_DUNNING_PLANS_B plan, iex_dunnings dunn

14341:
14342: If p_request_id is not null then
14343: select nvl(plan.dunning_type,'DAYS_OVERDUE')
14344: into l_dunning_type
14345: from IEX_DUNNING_PLANS_B plan, iex_dunnings dunn
14346: where dunn.xml_request_id = p_request_id
14347: and plan.dunning_plan_id = dunn.dunning_plan_id;
14348: end if;
14349:

Line 18424: iex_dunning_plans_b dunn

18420: cursor c_dunn_plan_line_dtls (p_ag_dn_xref_id number) is
18421: select nvl(dunn.include_current ,'N'),
18422: nvl(dunn.include_unused_payments_flag,'N')
18423: from iex_ag_dn_xref xref,
18424: iex_dunning_plans_b dunn
18425: where AG_DN_XREF_ID = p_ag_dn_xref_id
18426: and xref.dunning_plan_id = dunn.dunning_plan_id;
18427:
18428: x_dunning_trx_id number;