DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 1766: FROM HZ_CUSTOMER_PROFILES

1762: x_object_version_number OUT NOCOPY NUMBER
1763: ) IS
1764: CURSOR is_cust_profile_id_exist(l_cust_acct_prof_id NUMBER) IS
1765: SELECT nvl(object_version_number,1), cust_account_id, site_use_id
1766: FROM HZ_CUSTOMER_PROFILES
1767: WHERE cust_account_profile_id = l_cust_acct_prof_id
1768: AND rownum = 1;
1769:
1770: CURSOR is_cust_profile_exist(l_ca_id NUMBER, l_site_use_id NUMBER, l_profile_class_id NUMBER) IS

Line 1772: FROM HZ_CUSTOMER_PROFILES

1768: AND rownum = 1;
1769:
1770: CURSOR is_cust_profile_exist(l_ca_id NUMBER, l_site_use_id NUMBER, l_profile_class_id NUMBER) IS
1771: SELECT nvl(object_version_number,1), cust_account_profile_id
1772: FROM HZ_CUSTOMER_PROFILES
1773: WHERE cust_account_id = l_ca_id
1774: AND nvl(site_use_id, -99) = nvl(l_site_use_id, -99)
1775: AND profile_class_id = l_profile_class_id
1776: AND status in ('A','I')