DBA Data[Home] [Help]

APPS.HZ_PARTIES_PKG dependencies on DUAL

Line 360: INTO X_PARTY_ID FROM dual;

356: BEGIN
357: l_count := 1;
358: WHILE l_count > 0 LOOP
359: SELECT HZ_PARTIES_S.NEXTVAL
360: INTO X_PARTY_ID FROM dual;
361: BEGIN
362: SELECT 'Y' INTO l_dummy
363: FROM HZ_PARTIES
364: WHERE PARTY_ID = X_PARTY_ID;

Line 380: INTO X_PARTY_NUMBER FROM dual;

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
384: WHERE PARTY_NUMBER = X_PARTY_NUMBER;