APPS.HZ_WORK_CLASS_PKG dependencies on HZ_WORK_CLASS_S

Line 41: DECODE( x_WORK_CLASS_ID, FND_API.G_MISS_NUM, HZ_WORK_CLASS_S.NEXTVAL, NULL, HZ_WORK_CLASS_S.NEXTVAL, X_WORK_CLASS_ID ),

37: OBJECT_VERSION_NUMBER,
38: CREATED_BY_MODULE,
39: APPLICATION_ID
40: ) VALUES (
41: DECODE( x_WORK_CLASS_ID, FND_API.G_MISS_NUM, HZ_WORK_CLASS_S.NEXTVAL, NULL, HZ_WORK_CLASS_S.NEXTVAL, X_WORK_CLASS_ID ),
42: decode( x_LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_EXPERIENCE),
43: decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),
44: HZ_UTILITY_V2PUB.CREATED_BY,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),

Line 76: SELECT HZ_WORK_CLASS_S.NEXTVAL

72: l_dummy VARCHAR2(1);
73: BEGIN
74: l_count := 1;
75: WHILE l_count > 0 LOOP
76: SELECT HZ_WORK_CLASS_S.NEXTVAL
77: INTO X_WORK_CLASS_ID FROM dual;
78: BEGIN
79: SELECT 'Y' INTO l_dummy
80: FROM HZ_WORK_CLASS