APPS.HZP_CPROF_PKG dependencies on DUAL

Line 296: FROM dual;

292: IF ( x_customer_profile_id is null ) THEN
293: --
294: SELECT hz_customer_profiles_s.nextval
295: INTO x_customer_profile_id
296: FROM dual;
297: --
298: END IF;
299: --
300: --

Line 478: FROM DUAL;

474: CLOSE cu_class;
475: --
476: SELECT hz_customer_profiles_s.NEXTVAL
477: INTO l_customer_profile_id
478: FROM DUAL;
479: --
480: x_cust_prof_rec.cust_account_profile_id := l_customer_profile_id;
481: x_cust_prof_rec.cust_account_id := x_customer_id;
482: x_cust_prof_rec.site_use_id := x_site_use_id;

Line 1216: SELECT hz_cust_accounts_s.NEXTVAL INTO x_customer_id FROM DUAL;

1212: -- and not null if they are updating an existing profile.
1213: --
1214: --
1215: IF ( x_customer_id IS NULL ) THEN
1216: SELECT hz_cust_accounts_s.NEXTVAL INTO x_customer_id FROM DUAL;
1217: END IF;
1218: --
1219: --
1220: IF (x_customer_profile_id is null ) THEN

Line 1221: SELECT hz_customer_profiles_s.NEXTVAL INTO x_customer_profile_id FROM DUAL;

1217: END IF;
1218: --
1219: --
1220: IF (x_customer_profile_id is null ) THEN
1221: SELECT hz_customer_profiles_s.NEXTVAL INTO x_customer_profile_id FROM DUAL;
1222: END IF;
1223: --
1224: --
1225: --

Line 1743: SELECT hz_cust_accounts_s.NEXTVAL INTO x_customer_id FROM DUAL;

1739: -- and not null if they are updating an existing profile.
1740: --
1741: --
1742: IF ( x_customer_id IS NULL ) THEN
1743: SELECT hz_cust_accounts_s.NEXTVAL INTO x_customer_id FROM DUAL;
1744: END IF;
1745: --
1746: --
1747: IF (x_customer_profile_id is null ) THEN

Line 1748: SELECT hz_customer_profiles_s.NEXTVAL INTO x_customer_profile_id FROM DUAL;

1744: END IF;
1745: --
1746: --
1747: IF (x_customer_profile_id is null ) THEN
1748: SELECT hz_customer_profiles_s.NEXTVAL INTO x_customer_profile_id FROM DUAL;
1749: END IF;
1750: --
1751: --
1752: --