APPS.IEX_DUNNING_PUB dependencies on IEX_AG_DN_XREF

Line 665: iex_ag_dn_xref xref,

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
668: and dunn.request_id = p_conc_req_id
669: and dunn.ag_dn_xref_id = xref.ag_dn_xref_id

Line 679: iex_ag_dn_xref xref,

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
682: and dunn.request_id = p_conc_req_id
683: and dunn.ag_dn_xref_id = xref.ag_dn_xref_id

Line 2729: --l_ag_dn_xref_id := IEX_AG_DN_XREF_S.nextval;

2725:
2726: for dunn_letter_set_lines_rec in c_dunning_letter_set_lines (l_dunning_letter_set_id)
2727: loop
2728: --Start bug 9725204 gnramasa 19th May 10
2729: --l_ag_dn_xref_id := IEX_AG_DN_XREF_S.nextval;
2730: select IEX_AG_DN_XREF_S.nextval
2731: into l_ag_dn_xref_id
2732: from dual;
2733: --End bug 9725204 gnramasa 19th May 10

Line 2730: select IEX_AG_DN_XREF_S.nextval

2726: for dunn_letter_set_lines_rec in c_dunning_letter_set_lines (l_dunning_letter_set_id)
2727: loop
2728: --Start bug 9725204 gnramasa 19th May 10
2729: --l_ag_dn_xref_id := IEX_AG_DN_XREF_S.nextval;
2730: select IEX_AG_DN_XREF_S.nextval
2731: into l_ag_dn_xref_id
2732: from dual;
2733: --End bug 9725204 gnramasa 19th May 10
2734: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_ag_dn_xref_id= ' || l_ag_dn_xref_id);

Line 2736: INSERT INTO IEX_AG_DN_XREF

2732: from dual;
2733: --End bug 9725204 gnramasa 19th May 10
2734: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_ag_dn_xref_id= ' || l_ag_dn_xref_id);
2735:
2736: INSERT INTO IEX_AG_DN_XREF
2737: (AG_DN_XREF_ID,
2738: LAST_UPDATE_DATE,
2739: LAST_UPDATED_BY,
2740: LAST_UPDATE_LOGIN,