APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_CUST_SITE_USES_ALL

Line 1228: hz_cust_site_uses_all u

1224: ,in_party_site_id in number
1225: ,in_site_use_code in varchar2) IS
1226: SELECT s.cust_acct_site_id,u.site_use_id,u.primary_flag
1227: FROM hz_cust_acct_sites s,
1228: hz_cust_site_uses_all u
1229: WHERE s.cust_account_id = in_cust_account_id
1230: AND s.party_site_id = in_party_site_id
1231: AND s.status(+) = 'A'
1232: AND u.cust_acct_site_id(+) = s.cust_acct_site_id

Line 4742: from hz_cust_acct_sites s,hz_cust_site_uses_all u

4738: END IF;
4739: begin
4740: select u.site_use_id
4741: into p_site_use_id
4742: from hz_cust_acct_sites s,hz_cust_site_uses_all u
4743: where s.party_site_id=p_party_site_id
4744: and s.cust_acct_site_id= u.cust_acct_site_id;
4745:
4746: EXCEPTION

Line 5486: hz_cust_site_uses_all u

5482: select a.party_id
5483: into p_party_id
5484: from hz_cust_accounts a,
5485: hz_cust_acct_sites s,
5486: hz_cust_site_uses_all u
5487: where u.site_use_id=p_account_site_use_id
5488: and u.cust_acct_site_id=s.cust_acct_site_id
5489: and s.cust_account_id=a.cust_account_id;
5490: