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 505: from dual;

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