APPS.CSFW_ORDER_PARTS dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 59: from csp_inv_loc_assignments

55: l_dest_sub_inv varchar2(30);
56:
57: cursor c_default_org (v_resource_id Number) is
58: Select ORGANIZATION_ID ,SUBINVENTORY_CODE
59: from csp_inv_loc_assignments
60: where resource_id = v_resource_id
61: and DEFAULT_CODE = 'IN'
62: and sysdate between nvl(EFFECTIVE_DATE_START, sysdate) and nvl(EFFECTIVE_DATE_END, sysdate);
63:

Line 212: from csp_inv_loc_assignments

208: l_dest_sub_inv VARCHAR2(30);
209:
210: cursor c_default_org (v_resource_id Number) is
211: Select ORGANIZATION_ID ,SUBINVENTORY_CODE
212: from csp_inv_loc_assignments
213: where resource_id = v_resource_id
214: and DEFAULT_CODE = 'IN'
215: and sysdate between nvl(EFFECTIVE_DATE_START, sysdate) and nvl(EFFECTIVE_DATE_END, sysdate);
216: