APPS.ASO_SERVICE_CONTRACTS_INT dependencies on CS_STD

Line 52: AND b.organization_id = ( SELECT cs_std.get_item_valdn_orgzn_id FROM DUAL ) ;

48: FROM
49: CS_CUSTOMER_PRODUCTS_All a, mtl_system_items_kfv b
50: WHERE a.inventory_item_id = b.inventory_item_id
51: AND a.customer_product_id = cs_prd_id
52: AND b.organization_id = ( SELECT cs_std.get_item_valdn_orgzn_id FROM DUAL ) ;
53: */
54:
55: CURSOR C_cs_item(p_instance_id NUMBER, cs_org_id NUMBER) IS
56: SELECT a.inventory_item_id

Line 256: l_cs_org_id := cs_std.get_item_valdn_orgzn_id;

252: aso_debug_pub.add('Get Service Attr: CUSTOMER_PRODUCT service ref line id'||P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, 1, 'Y');
253:
254: END IF;
255:
256: l_cs_org_id := cs_std.get_item_valdn_orgzn_id;
257:
258: OPEN C_cs_item( P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, l_cs_org_id);
259: FETCH C_cs_item INTO l_inventory_item_id;
260: IF C_cs_item%NOTFOUND THEN