APPS.IEX_UTILITIES dependencies on IEX_DELINQUENCIES_ALL

Line 1448: select customer_site_use_id from iex_delinquencies_all

1444: -- where party_id = p_party_id and status = 'A' and site_use_id is null and cust_account_id is null;
1445: -- end bug 4587842 ctlee 09/06/2005
1446:
1447: cursor c_get_billto (p_delinquency_id number) is
1448: select customer_site_use_id from iex_delinquencies_all
1449: where delinquency_id = p_delinquency_id;
1450: BEGIN
1451:
1452: l_party_id := p_party_id;

Line 1580: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

1576:
1577: -- only open status
1578: cursor c_amount_billto (p_site_use_id number) is
1579: select nvl(a.amount_due_remaining, 0), a.invoice_currency_code, class
1580: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
1581: where a.payment_schedule_id = b.payment_schedule_id
1582: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1583: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1584: and a.status = 'OP'

Line 1597: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

1593:
1594: -- only open status
1595: cursor c_amount_account (p_cust_account_id number) is
1596: select nvl(a.amount_due_remaining,0), a.invoice_currency_code, class
1597: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
1598: where a.payment_schedule_id = b.payment_schedule_id
1599: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1600: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1601: and a.status = 'OP'

Line 1610: from ar_payment_schedules_all a, iex_delinquencies_all b

1606: l_tot_amt_due_rem number;
1607:
1608: cursor c_billto_dist_inv_cur (p_site_use_id number) is
1609: select distinct a.invoice_currency_code
1610: from ar_payment_schedules_all a, iex_delinquencies_all b
1611: where a.payment_schedule_id = b.payment_schedule_id
1612: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1613: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1614: and a.status = 'OP'

Line 1626: from ar_payment_schedules_all a, iex_delinquencies_all b

1622: and currency_code = p_currency_code;
1623:
1624: cursor c_billto_tot_amt_due_rem (p_site_use_id number, p_currency_code varchar, p_min_dun_inv_amt number) is
1625: select sum(nvl(a.amount_due_remaining,0))
1626: from ar_payment_schedules_all a, iex_delinquencies_all b
1627: where a.payment_schedule_id = b.payment_schedule_id
1628: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1629: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1630: and a.status = 'OP'

Line 1637: from ar_payment_schedules_all a, iex_delinquencies_all b

1633: and a.amount_due_remaining >= p_min_dun_inv_amt;
1634:
1635: cursor c_acc_dist_inv_cur (p_cust_account_id number) is
1636: select distinct a.invoice_currency_code
1637: from ar_payment_schedules_all a, iex_delinquencies_all b
1638: where a.payment_schedule_id = b.payment_schedule_id
1639: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1640: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1641: and a.status = 'OP'

Line 1654: from ar_payment_schedules_all a, iex_delinquencies_all b

1650: and site_use_id is null;
1651:
1652: cursor c_acc_tot_amt_due_rem (p_cust_account_id number, p_currency_code varchar, p_min_dun_inv_amt number) is
1653: select sum(nvl(a.amount_due_remaining,0))
1654: from ar_payment_schedules_all a, iex_delinquencies_all b
1655: where a.payment_schedule_id = b.payment_schedule_id
1656: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1657: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1658: and a.status = 'OP'

Line 2436: from iex_delinquencies_all del,ra_customer_trx_lines_all trl

2432: iex_debug_pub.logmessage ('p_contract_number :' || p_contract_number);
2433:
2434: IF p_contract_number IS NOT NULL then
2435: select count(1) into l_count
2436: from iex_delinquencies_all del,ra_customer_trx_lines_all trl
2437: where del.TRANSACTION_ID = trl.CUSTOMER_TRX_ID
2438: and del.status not in ('CURRENT', 'CLOSE')
2439: and trl.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS'
2440: and trl.INTERFACE_LINE_ATTRIBUTE6 = p_contract_number;