APPS.HZ_EMPLOYMENT_HISTORY_PKG dependencies on HZ_EMPLOYMENT_HISTORY_S

Line 80: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, NULL, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, x_EMPLOYMENT_HISTORY_ID ),

76: EMPLOYED_AS_TITLE_CODE,
77: WEEKLY_WORK_HOURS,
78: COMMENTS
79: ) VALUES (
80: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, NULL, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, x_EMPLOYMENT_HISTORY_ID ),
81: decode( x_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_BEGIN_DATE),
82: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),
84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),

Line 135: SELECT HZ_EMPLOYMENT_HISTORY_S.NEXTVAL

131: l_dummy VARCHAR2(1);
132: BEGIN
133: l_count := 1;
134: WHILE l_count > 0 LOOP
135: SELECT HZ_EMPLOYMENT_HISTORY_S.NEXTVAL
136: INTO X_EMPLOYMENT_HISTORY_ID FROM dual;
137: BEGIN
138: SELECT 'Y' INTO l_dummy
139: FROM HZ_EMPLOYMENT_HISTORY