DBA Data[Home] [Help]

APPS.ONT_OIP_COMMON dependencies on FND_USER

Line 43: from fnd_user fnd,

39: party.email_address,
40: party.party_name,
41: roles.cust_account_id,
42: nvl(roles.cust_acct_site_id,0)
43: from fnd_user fnd,
44: hz_parties party,
45: hz_cust_account_roles roles
46: where fnd.customer_id = party.party_id
47: and party.party_type='PARTY_RELATIONSHIP'

Line 51: and fnd.user_id=lUserID;

47: and party.party_type='PARTY_RELATIONSHIP'
48: and party.party_id = roles.party_id
49: and roles.status ='A'
50: and party.status='A'
51: and fnd.user_id=lUserID;
52: --
53: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
54: --
55: BEGIN