APPS.HZ_CITIZENSHIP_PKG dependencies on HZ_CITIZENSHIP_S

Line 55: decode( X_CITIZENSHIP_ID, FND_API.G_MISS_NUM, HZ_CITIZENSHIP_S.NEXTVAL, NULL, HZ_CITIZENSHIP_S.NEXTVAL, X_CITIZENSHIP_ID ),

51: OBJECT_VERSION_NUMBER,
52: CREATED_BY_MODULE,
53: APPLICATION_ID
54: ) VALUES (
55: decode( X_CITIZENSHIP_ID, FND_API.G_MISS_NUM, HZ_CITIZENSHIP_S.NEXTVAL, NULL, HZ_CITIZENSHIP_S.NEXTVAL, X_CITIZENSHIP_ID ),
56: decode( x_BIRTH_OR_SELECTED, FND_API.G_MISS_CHAR, NULL,x_BIRTH_OR_SELECTED),
57: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
58: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,x_COUNTRY_CODE),
59: decode( x_DATE_DISOWNED, FND_API.G_MISS_DATE, TO_DATE(NULL),x_DATE_DISOWNED),

Line 96: SELECT HZ_CITIZENSHIP_S.NEXTVAL

92: l_dummy VARCHAR2(1);
93: BEGIN
94: l_count := 1;
95: WHILE l_count > 0 LOOP
96: SELECT HZ_CITIZENSHIP_S.NEXTVAL
97: INTO X_CITIZENSHIP_ID FROM dual;
98: BEGIN
99: SELECT 'Y' INTO l_dummy
100: FROM HZ_CITIZENSHIP