APPS.PN_SET_TYPES_PKG dependencies on PN_SET_TYPES_S

Line 26: select PN_SET_TYPES_s.nextval

22: begin
23:
24: IF X_SET_ID is null then
25:
26: select PN_SET_TYPES_s.nextval
27: into X_SET_ID
28: from dual;
29:
30: END IF;

Line 178: from PN_SET_TYPES SUBB,

174: T.LANGUAGE
175: ) in (
176: select SUBT.SET_ID,
177: SUBT.LANGUAGE
178: from PN_SET_TYPES SUBB,
179: PN_SET_TYPES SUBT
180: where SUBB.SET_ID = SUBT.SET_ID
181: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
182: and (SUBB.SET_NAME <> SUBT.SET_NAME or

Line 179: PN_SET_TYPES SUBT

175: ) in (
176: select SUBT.SET_ID,
177: SUBT.LANGUAGE
178: from PN_SET_TYPES SUBB,
179: PN_SET_TYPES SUBT
180: where SUBB.SET_ID = SUBT.SET_ID
181: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
182: and (SUBB.SET_NAME <> SUBT.SET_NAME or
183: SUBB.DESCRIPTION <> SUBT.DESCRIPTION or