DBA Data[Home] [Help]

APPS.CS_SYSTEMS_COMMON_PUB dependencies on HZ_PARTIES

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