APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_CUST_SITE_USES_ALL

Line 1226: hz_cust_site_uses_all u

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

Line 4740: from hz_cust_acct_sites s,hz_cust_site_uses_all u

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

Line 5484: hz_cust_site_uses_all u

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