APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on ASO_QUOTE_HEADERS

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 1115: from aso_quote_headers

1111: and record_type = 'CART';
1112:
1113: cursor c_check_guest_oneclk(c_qte_hdr_id NUMBER) is
1114: select quote_source_code
1115: from aso_quote_headers
1116: where quote_header_id = c_qte_hdr_id;
1117:
1118: cursor c_check_ac_qh(c_qh_id NUMBER) is
1119: select quote_header_id, quote_name

Line 1120: from aso_quote_headers

1116: where quote_header_id = c_qte_hdr_id;
1117:
1118: cursor c_check_ac_qh(c_qh_id NUMBER) is
1119: select quote_header_id, quote_name
1120: from aso_quote_headers
1121: where quote_header_id = c_qh_id;
1122:
1123: rec_check_ac_qh c_check_ac_qh%rowtype;
1124: rec_check_ac_aqa c_check_ac_aqa%rowtype;

Line 2039: from aso_quote_headers

2035: and sh.created_by = fnd.user_id;
2036:
2037: CURSOR c_get_owner(c_quote_header_id NUMBER) is
2038: select party_id, cust_account_id
2039: from aso_quote_headers
2040: where quote_header_id = c_quote_header_id;
2041:
2042:
2043: rec_get_recipients c_get_recipients%rowtype;

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: