DBA Data[Home] [Help]

APPS.PO_FED_FIELD_FUNCTIONS dependencies on FND_USER

Line 213: AND FND_USER_ID = fnd_global.user_id;

209: INTO addresscode,location
210: FROM po_user_preferences
211: WHERE functional_area = p_functional_area
212: AND address_type= l_addressType
213: AND FND_USER_ID = fnd_global.user_id;
214: EXCEPTION
215: WHEN No_Data_Found THEN
216: NULL;
217: WHEN OTHERS THEN

Line 234: AND FND_USER_ID = fnd_global.user_id;

230: INTO contact
231: FROM po_user_preferences
232: WHERE functional_area = p_functional_area
233: AND address_type= l_addressType
234: AND FND_USER_ID = fnd_global.user_id;
235: EXCEPTION
236: WHEN No_Data_Found THEN
237: NULL;
238: WHEN OTHERS THEN

Line 1846: fnd_user fu

1842: fu.user_name,
1843: pvc.title INTO l_vendor_contact_first_name, l_vendor_contact_email_address, l_vendor_contact_phone, l_vendor_contact_id, l_vendor_contact_full_name,
1844: l_vendor_site_id, l_vendor_contact_fax, l_vendor_contact_last_name, l_user_name, l_vendor_contact_title
1845: FROM po_vendor_contacts pvc,
1846: fnd_user fu
1847: WHERE pvc.per_party_id = fu.person_party_id(+) AND vendor_contact_id = p_contact_id and vendor_site_id = p_supplier_site_id;
1848:
1849: l_vendor_cnt_concat := '';
1850: