DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 769: FROM hz_customer_profiles

765:
766: CURSOR cust_profile_csr(p_account_id in number,
767: p_site_use_id in number) is
768: SELECT profile_class_id
769: FROM hz_customer_profiles
770: WHERE cust_account_id = p_account_id
771: AND site_use_id = p_site_use_id;
772:
773:

Line 778: FROM hz_customer_profiles

774: -- For Bug#9146716 (+)
775:
776: CURSOR cust_profile_site_csr(p_account_id in number) is
777: SELECT profile_class_id
778: FROM hz_customer_profiles
779: WHERE cust_account_id = p_account_id
780: AND site_use_id IS NULL;
781:
782: -- For Bug#9146716 (-)