APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 18: from aso_quote_headers_all

14: cursor c_get_cart_name(c_q_hdr_id number,
15: c_party_id number,
16: c_cust_account_id number) is
17: select quote_name
18: from aso_quote_headers_all
19: where party_id = c_party_id
20: and cust_account_id = c_cust_account_id
21: and quote_header_id = c_q_hdr_id;
22: rec_get_cart_name c_get_cart_name%rowtype;

Line 44: from aso_quote_headers_all a, hz_parties p

40: where quote_sharee_number = c_retrieval_num ;
41:
42: cursor c_get_sold_to(c_quote_header_id NUMBER) is
43: select cust_account_id, party_type
44: from aso_quote_headers_all a, hz_parties p
45: where a.party_id = p.party_id
46: and quote_header_id = c_quote_header_id;
47:
48: rec_get_sold_to c_get_sold_to%rowtype;

Line 512: from ASO_QUOTE_HEADERS_ALL

508: and party_id = c_party_id));
509:
510: cursor c_get_owner_ids(c_quote_id number) is
511: select party_id, cust_account_id
512: from ASO_QUOTE_HEADERS_ALL
513: where quote_header_id = c_quote_id;
514:
515: cursor c_get_created_recip(c_quote_header_id number,
516: c_party_id number,

Line 2686: from ASO_QUOTE_HEADERS_ALL

2682: and record_type= 'CART';
2683:
2684: cursor c_get_owner_ids(c_quote_id number) is
2685: select party_id, cust_account_id
2686: from ASO_QUOTE_HEADERS_ALL
2687: where quote_header_id = c_quote_id;
2688:
2689: cursor c_get_contact_point_ovn(c_quote_sharee_id Number) IS
2690: select QUOTE_ACCESS.party_id, CNTCT_POINTS.contact_point_id, CNTCT_POINTS.object_version_number

Line 2931: from ASO_QUOTE_HEADERS_ALL

2927: l_env_user_id NUMBER;
2928:
2929: cursor c_get_owner_partyid(c_quote_id number) is
2930: select party_id
2931: from ASO_QUOTE_HEADERS_ALL
2932: where quote_header_id = c_quote_id;
2933:
2934: rec_get_owner_partyid c_get_owner_partyid%rowtype;
2935: