DBA Data[Home] [Help]

APPS.ARH_CPC_PKG dependencies on DUAL

Line 158: from dual

154: profile_class_count number;
155: BEGIN
156: select 1
157: into profile_class_count
158: from dual
159: where not exists ( select 1
160: from hz_cust_profile_classes
161: where name = c_profile_class_name
162: and profile_class_id >= 0

Line 502: from dual;

498: BEGIN
499: IF X_CUSTOMER_PROFILE_CLASS_ID IS NULL THEN
500: select hz_cust_profile_classes_s.nextval
501: into x_customer_profile_class_id
502: from dual;
503: END IF;
504:
505: -- Calling check_unique Procedure To Verify The Uniqueness Of The Customer
506: -- Profile Class Id