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 231: l_cs_org_id := cs_std.get_item_valdn_orgzn_id;

227: 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');
228:
229: END IF;
230:
231: l_cs_org_id := cs_std.get_item_valdn_orgzn_id;
232:
233: OPEN C_cs_item( P_Qte_Line_Dtl_tbl(i).SERVICE_REF_LINE_ID, l_cs_org_id);
234: FETCH C_cs_item INTO l_inventory_item_id;
235: IF C_cs_item%NOTFOUND THEN