DBA Data[Home] [Help]

APPS.CSD_RETURNS_UTIL dependencies on FND_USER

Line 1453: FROM hz_contact_points contacts,hz_parties parties,fnd_user usr

1449: AND ROWNUM < 2;
1450: ELSE
1451: SELECT contacts.contact_point_id,contacts.owner_table_id
1452: INTO l_contact_point_id,l_contact_party_id
1453: FROM hz_contact_points contacts,hz_parties parties,fnd_user usr
1454: WHERE contacts.owner_table_name = 'HZ_PARTIES'
1455: AND contacts.email_address = p_email
1456: AND usr.user_id = fnd_global.user_id
1457: AND parties.party_id = usr.customer_id

Line 1471: FROM fnd_user

1467: l_contact_party_id := p_party_id;
1468: ELSE
1469: SELECT customer_id
1470: INTO l_contact_party_id
1471: FROM fnd_user
1472: WHERE user_id = fnd_global.user_id;
1473: END IF;
1474: END;
1475:

Line 1516: FROM hz_parties party,fnd_user usr

1512: WHERE party.party_id = p_party_id;
1513: ELSE
1514: SELECT party.party_type,party.party_id
1515: INTO l_service_request_rec.contact_type,l_service_request_rec.party_id
1516: FROM hz_parties party,fnd_user usr
1517: WHERE usr.user_id = fnd_global.user_id
1518: AND usr.customer_id = party.party_id;
1519: END IF;
1520: ELSE