APPS.HZ_PARTIES_PKG dependencies on HZ_PARTY_NUMBER_S

Line 240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),

236: APPLICATION_ID
237: )
238: VALUES (
239: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),
240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),
241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 379: SELECT TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL )

375: l_dummy VARCHAR2(1);
376: BEGIN
377: l_count := 1;
378: WHILE l_count > 0 LOOP
379: SELECT TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL )
380: INTO X_PARTY_NUMBER FROM dual;
381: BEGIN
382: SELECT 'Y' INTO l_dummy
383: FROM HZ_PARTIES