APPS.PN_NOTE_DETAILS_PKG dependencies on PN_NOTE_DETAILS_S

Line 26: select PN_NOTE_DETAILS_S.nextval

22: where NOTE_DETAIL_ID = X_NOTE_DETAIL_ID
23: and LANGUAGE = userenv('LANG');
24: BEGIN
25: IF (X_NOTE_DETAIL_ID IS NULL) THEN
26: select PN_NOTE_DETAILS_S.nextval
27: into X_NOTE_DETAIL_ID
28: from dual;
29: END IF;
30:

Line 180: from PN_NOTE_DETAILS SUBB,

176: ) IN
177: (
178: select SUBT.NOTE_DETAIL_ID,
179: SUBT.LANGUAGE
180: from PN_NOTE_DETAILS SUBB,
181: PN_NOTE_DETAILS SUBT
182: where SUBB.NOTE_DETAIL_ID = SUBT.NOTE_DETAIL_ID
183: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
184: and (SUBB.TEXT <> SUBT.TEXT)

Line 181: PN_NOTE_DETAILS SUBT

177: (
178: select SUBT.NOTE_DETAIL_ID,
179: SUBT.LANGUAGE
180: from PN_NOTE_DETAILS SUBB,
181: PN_NOTE_DETAILS SUBT
182: where SUBB.NOTE_DETAIL_ID = SUBT.NOTE_DETAIL_ID
183: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
184: and (SUBB.TEXT <> SUBT.TEXT)
185: );