APPS.HZ_CUST_ACCT_SITE_BO_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 531: FROM HZ_CUSTOMER_PROFILES

527: l_parent_obj_type VARCHAR2(30);
528:
529: CURSOR get_cap_id(l_ca_id NUMBER, l_casu_id NUMBER, l_profile_class_id NUMBER) IS
530: SELECT cust_account_profile_id
531: FROM HZ_CUSTOMER_PROFILES
532: WHERE cust_account_id = l_ca_id
533: AND site_use_id = l_casu_id
534: AND profile_class_id = l_profile_class_id
535: AND status IN ('A','I');

Line 1613: FROM HZ_CUSTOMER_PROFILES

1609: l_parent_obj_type VARCHAR2(30);
1610:
1611: CURSOR get_cap_id(l_ca_id NUMBER, l_casu_id NUMBER, l_profile_class_id NUMBER) IS
1612: SELECT cust_account_profile_id
1613: FROM HZ_CUSTOMER_PROFILES
1614: WHERE cust_account_id = l_ca_id
1615: AND site_use_id = l_casu_id
1616: AND profile_class_id = l_profile_class_id
1617: AND status IN ('A','I');