APPS.IBE_ONECLK_PVT dependencies on ASO_QUOTE_STATUSES_VL

Line 43: l_quote_status aso_quote_statuses_vl.status_code%type;

39:
40: my_message VARCHAR2(2000);
41: l_count_good NUMBER := 0;
42: l_count_fail NUMBER := 0;
43: l_quote_status aso_quote_statuses_vl.status_code%type;
44: l_contract_template_id NUMBER;
45: l_hold_flag VARCHAR2(1);
46:
47:

Line 70: from aso_quote_headers_all a, aso_quote_statuses_vl b

66: cust_account_id = c_acct_id;
67:
68: CURSOR c_quote_status_code (quote_hdr_id number) is
69: select status_code
70: from aso_quote_headers_all a, aso_quote_statuses_vl b
71: where quote_header_id = quote_hdr_id
72: and a.quote_status_id = b.quote_status_id;
73:
74: rec_quote_status_code c_quote_status_code%rowtype;