DBA Data[Home] [Help]

APPS.ARP_STAGED_DUNNING dependencies on ARPT_SQL_FUNC_UTIL

Line 632: WHERE site_use_id = arpt_sql_func_util.get_bill_id(site.site_use_id))

628: FROM hz_cust_profile_amts
629: WHERE CUST_ACCOUNT_PROFILE_ID =
630: (SELECT cust_account_profile_id
631: FROM hz_customer_profiles
632: WHERE site_use_id = arpt_sql_func_util.get_bill_id(site.site_use_id))
633: AND currency_code = curr_code
634: AND CUST_ACCOUNT_ID = site.customer_id;
635: end if;
636: end if;