DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 1769: FROM HZ_CUSTOMER_PROFILES

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

Line 1775: FROM HZ_CUSTOMER_PROFILES

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