DBA Data[Home] [Help]

APPS.OE_ITORD_UTIL dependencies on HZ_CUSTOMER_PROFILES

Line 51: HZ_CUSTOMER_PROFILES cp ,

47:
48: SELECT cp.profile_class_id
49: into l_customer_class_id
50: FROM
51: HZ_CUSTOMER_PROFILES cp ,
52: hz_cust_profile_classes cpc
53: WHERE cpc.profile_class_id=cp.PROFILE_CLASS_ID
54: AND cp.site_use_id IS NULL
55: AND cp.cust_account_id= p_customer_id;