APPS.BOM_DEPARTMENTS_PKG dependencies on BOM_DEPARTMENTS_S

Line 41: CURSOR C2 IS SELECT bom_departments_s.nextval FROM sys.dual;

37: X_Maint_Cost_Category VARCHAR2 DEFAULT NULL
38: ) IS
39: CURSOR C IS SELECT rowid FROM BOM_DEPARTMENTS
40: WHERE department_id = X_Department_Id;
41: CURSOR C2 IS SELECT bom_departments_s.nextval FROM sys.dual;
42: BEGIN
43: if (X_Department_Id is NULL) then
44: OPEN C2;
45: FETCH C2 INTO X_Department_Id;