DBA Data[Home] [Help]

APPS.PN_RIGHTS_PKG dependencies on DUAL

Line 78: FROM DUAL;

74: IF ( X_RIGHT_ID IS NULL) THEN
75:
76: SELECT pn_rights_s.NEXTVAL
77: INTO x_right_id
78: FROM DUAL;
79: END IF;
80:
81: IF x_org_id IS NULL THEN
82: FOR rec IN org_cur LOOP

Line 431: FROM DUAL;

427: IF (recInfoForHist.LEASE_CHANGE_ID <> X_LEASE_CHANGE_ID) THEN
428:
429: SELECT PN_RIGHTS_HISTORY_S.NEXTVAL
430: INTO l_rightHistoryId
431: FROM DUAL;
432:
433: INSERT INTO PN_RIGHTS_HISTORY
434: (
435: RIGHT_HISTORY_ID,