DBA Data[Home] [Help]

APPS.HZP_CPROF_PKG dependencies on HZ_CUSTOMER_PROFILES_S

Line 294: SELECT hz_customer_profiles_s.nextval

290: -- in order bt create profile ammounts from a prfile class
291: --
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;

Line 476: SELECT hz_customer_profiles_s.NEXTVAL

472: OPEN cu_class;
473: FETCH cu_class INTO lrec;
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;

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 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: --