APPS.CSP_PORTAL_EXCESS_PARTS_PVT dependencies on CSP_PLANNING_PARAMETERS

Line 35: select level_id from csp_planning_parameters

31: (EFFECTIVE_DATE_END is null or trunc(EFFECTIVE_DATE_END) > trunc(sysdate));
32:
33: Cursor planning(p_organization_id NUMBER,p_subinventory_code VARCHAR2,p_condition_type VARCHAR2)
34: is
35: select level_id from csp_planning_parameters
36: where organization_id = p_organization_id and
37: secondary_inventory = p_subinventory_code and
38: condition_type = p_condition_type;
39: