DBA Data[Home] [Help]

APPS.CS_SYSTEMS_COMMON_PUB dependencies on HZ_CUST_ACCOUNTS

Line 359: cs_systems_all_b a, hz_cust_accounts b,

355:
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

Line 375: cs_systems_all_b a, hz_cust_accounts b,

371: end if;
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