DBA Data[Home] [Help]

APPS.CSP_PLANNING_PARAMETERS_PVT dependencies on DUAL

Line 158: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;

154: and secondary_inventory_name not in
155: (Select secondary_inventory from csp_planning_parameters
156: where organization_id = L_ORGANIZATION_ID);
157:
158: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;
159:
160: CURSOR C3(l_secondary_inventory Varchar2,l_organization_id Number) IS
161: SELECT SECONDARY_INVENTORY_ID
162: FROM CSP_SEC_INVENTORIES_V