APPS.ASO_SERVICE_CONTRACTS_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 38: FROM aso_quote_headers_all a,aso_quote_lines_all b

34: where inventory_item_id = inv1
35: and organization_id = lc_organization_id;
36: CURSOR C_qln(c_qln_id NUMBER) IS
37: SELECT b.inventory_item_id,b.organization_id,a.cust_account_id
38: FROM aso_quote_headers_all a,aso_quote_lines_all b
39: WHERE b.quote_line_id = c_qln_id and
40: a.quote_header_id=b.quote_header_id;
41: CURSOR C_get_cust IS
42: SELECT cust_account_id

Line 43: FROM aso_quote_headers_all

39: WHERE b.quote_line_id = c_qln_id and
40: a.quote_header_id=b.quote_header_id;
41: CURSOR C_get_cust IS
42: SELECT cust_account_id
43: FROM aso_quote_headers_all
44: WHERE quote_header_id= P_Qte_Line_Rec.quote_header_id;
45: /*
46: CURSOR C_cs_item(cs_prd_id NUMBER) IS
47: SELECT a.inventory_item_id

Line 69: FROM aso_quote_headers_all

65: FROM oe_order_lines_All
66: WHERE line_id=ord_line_id;
67: CURSOR C_cust_id (Quote_hd_id NUMBER)IS
68: SELECT cust_account_id
69: FROM aso_quote_headers_all
70: WHERE quote_header_id= Quote_hd_id;
71: l_api_version_number NUMBER := 1.0;
72: l_api_name VARCHAR2(50) := 'Get_service_attributes';
73: l_inventory_item_id NUMBER ;