APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on FND_USER

Line 26: from FND_USER

22: rec_get_cart_name c_get_cart_name%rowtype;
23: rec_check_active_cart c_check_active_cart%rowtype;
24: cursor c_userenv_partyid is
25: select customer_id
26: from FND_USER
27: where user_id = FND_GLOBAL.USER_ID;
28: rec_userenv_partyid c_userenv_partyid%rowtype;
29:
30: /*This procedure is used to save the missing party_id and cust_account_id

Line 504: from ibe_sh_quote_access ibe, fnd_user fnd

500: quote_header_id,
501: quote_sharee_number,
502: quote_sharee_id,
503: fnd.customer_id shared_by_party_id
504: from ibe_sh_quote_access ibe, fnd_user fnd
505: where ibe.created_by = fnd.user_id
506: and (quote_sharee_id = c_recip_id
507: or (quote_header_id = c_quote_header_id
508: and party_id = c_party_id));

Line 505: where ibe.created_by = fnd.user_id

501: quote_sharee_number,
502: quote_sharee_id,
503: fnd.customer_id shared_by_party_id
504: from ibe_sh_quote_access ibe, fnd_user fnd
505: where ibe.created_by = fnd.user_id
506: and (quote_sharee_id = c_recip_id
507: or (quote_header_id = c_quote_header_id
508: and party_id = c_party_id));
509:

Line 2015: FND_USER FND

2011: HZ.EMAIL_ADDRESS,
2012: FND.customer_id shared_by_party_id
2013: from IBE_SH_QUOTE_ACCESS SH,
2014: HZ_CONTACT_POINTS HZ,
2015: FND_USER FND
2016: where SH.contact_point_id = HZ.Contact_point_id
2017: and quote_header_id = c_qte_hdr_id
2018: and nvl(end_date_active, sysdate+1) > sysdate
2019: and sh.created_by = fnd.user_id;

Line 2019: and sh.created_by = fnd.user_id;

2015: FND_USER FND
2016: where SH.contact_point_id = HZ.Contact_point_id
2017: and quote_header_id = c_qte_hdr_id
2018: and nvl(end_date_active, sysdate+1) > sysdate
2019: and sh.created_by = fnd.user_id;
2020:
2021: cursor c_get_recipient_info(c_recipient_id NUMBER) is
2022: select quote_sharee_id,
2023: party_id,

Line 2031: FND_USER FND

2027: HZ.EMAIL_ADDRESS,
2028: FND.customer_id shared_by_party_id
2029: from IBE_SH_QUOTE_ACCESS SH,
2030: HZ_CONTACT_POINTS HZ,
2031: FND_USER FND
2032: where SH.contact_point_id = HZ.Contact_point_id
2033: and quote_sharee_id = c_recipient_id
2034: and nvl(end_date_active, sysdate+1) > sysdate
2035: and sh.created_by = fnd.user_id;

Line 2035: and sh.created_by = fnd.user_id;

2031: FND_USER FND
2032: where SH.contact_point_id = HZ.Contact_point_id
2033: and quote_sharee_id = c_recipient_id
2034: and nvl(end_date_active, sysdate+1) > sysdate
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