APPS.IEX_UTILITIES dependencies on HZ_CUST_PROFILE_AMTS

Line 1572: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0) from hz_cust_profile_amts

1568: -- there is no status to check if active or not,
1569: -- field expiration_date is null only - not used
1570: -- because there is more than 1 record for the same site_use_id, so we pick the functional currency one
1571: cursor c_billto (p_customer_site_use_id number) is
1572: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0) from hz_cust_profile_amts
1573: where site_use_id = p_customer_site_use_id and currency_code = (
1574: SELECT sob.currency_code FROM ar_system_parameters sp, gl_sets_of_books sob
1575: WHERE sob.set_of_books_id = sp.set_of_books_id);
1576:

Line 1589: from hz_cust_profile_amts

1585: and b.customer_site_use_id = p_site_use_id;
1586:
1587: cursor c_account (p_cust_account_id number) is
1588: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
1589: from hz_cust_profile_amts
1590: where cust_account_id = p_cust_account_id and currency_code = (
1591: SELECT sob.currency_code FROM ar_system_parameters sp, gl_sets_of_books sob
1592: WHERE sob.set_of_books_id = sp.set_of_books_id);
1593:

Line 1620: from hz_cust_profile_amts

1616: order by 1;
1617:
1618: cursor c_billto_min_dunn_amt (p_site_use_id number, p_currency_code varchar) is
1619: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
1620: from hz_cust_profile_amts
1621: where site_use_id = p_site_use_id
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

Line 1647: from hz_cust_profile_amts

1643: order by 1;
1644:
1645: cursor c_acc_min_dunn_amt (p_cust_account_id number, p_currency_code varchar) is
1646: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
1647: from hz_cust_profile_amts
1648: where cust_account_id = p_cust_account_id
1649: and currency_code = p_currency_code
1650: and site_use_id is null;
1651:

Line 1693: -- no need to set up party id because there is no party level record in hz_cust_profile_amts

1689: fetch c_billto into l_min_currency_code, l_min_dunning_amount, l_min_dunning_invoice_amount;
1690: close c_billto;
1691:
1692: elsif (l_cust_account_id is not null ) Then
1693: -- no need to set up party id because there is no party level record in hz_cust_profile_amts
1694: open c_account(l_cust_account_id);
1695: fetch c_account into l_min_currency_code, l_min_dunning_amount, l_min_dunning_invoice_amount;
1696: close c_account;
1697: end if;