APPS.ARW_SEARCH_CUSTOMERS dependencies on FND_USER

Line 1057: select person_party_id into p_party_id from fnd_user where user_id = p_user_id;

1053:
1054: BEGIN
1055: delete from ar_irec_user_acct_sites_all where session_id=p_session_id AND RELATED_CUSTOMER_FLAG = 'Y';
1056:
1057: select person_party_id into p_party_id from fnd_user where user_id = p_user_id;
1058:
1059: IF (p_is_internal_user='Y') THEN
1060: FOR account_assigned_site IN (
1061: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id