APPS.CS_SYSTEMS_COMMON_PUB dependencies on FND_USER

Line 7: SELECT customer_id INTO l_cust_id FROM FND_USER WHERE user_id =

3: function get_party_id (p_user_id IN NUMBER) return NUMBER
4: is
5: l_cust_id NUMBER;
6: begin
7: SELECT customer_id INTO l_cust_id FROM FND_USER WHERE user_id =
8: p_user_id;
9: return l_cust_id;
10: end get_party_id;
11:

Line 360: hz_parties c, fnd_user d

356: if (p_system_name is not null) then
357: l_system_id := get_system_id (p_system_name);
358: SELECT count(*) INTO l_system_count FROM
359: cs_systems_all_b a, hz_cust_accounts b,
360: hz_parties c, fnd_user d
361: WHERE a.system_id=l_system_id AND
362: a.customer_id=b.cust_account_id AND
363: b.party_id=c.party_id AND
364: c.party_type='PERSON' AND

Line 376: hz_parties c, fnd_user d

372:
373: elsif (p_system_id > 0) then
374: SELECT count(*) INTO l_system_count FROM
375: cs_systems_all_b a, hz_cust_accounts b,
376: hz_parties c, fnd_user d
377: WHERE a.system_id=p_system_id AND
378: a.customer_id=b.cust_account_id AND
379: b.party_id=c.party_id AND
380: c.party_type='PERSON' AND