APPS.OE_DEFAULT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 152: From HZ_CUST_SITE_USES_ALL SITE,

148: --R12 CC Encryption
149: Begin
150: Select party_site.party_id, acct_site.cust_account_id
151: Into l_party_id, l_cust_account_id
152: From HZ_CUST_SITE_USES_ALL SITE,
153: HZ_PARTY_SITES PARTY_SITE,
154: HZ_CUST_ACCT_SITES ACCT_SITE
155: Where SITE.SITE_USE_ID = l_invoice_to_org_id
156: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 780: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

776: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
777: l_org_id NUMBER;
778: -- l_legal_entity_id NUMBER;
779:
780: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
781: SELECT cust_acct.cust_account_id,
782: cust_Acct.party_id,
783: acct_site.party_site_id,
784: site_use.org_id

Line 786: HZ_CUST_SITE_USES_ALL site_use,

782: cust_Acct.party_id,
783: acct_site.party_site_id,
784: site_use.org_id
785: FROM
786: HZ_CUST_SITE_USES_ALL site_use,
787: HZ_CUST_ACCT_SITES_ALL acct_site,
788: HZ_CUST_ACCOUNTS_ALL cust_Acct
789: WHERE site_use.site_use_id = p_site_org_id
790: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1577: ,HZ_CUST_SITE_USES_ALL SITE

1573:
1574: SELECT /* MOAC_SQL_CHANGE */ SITE.SITE_USE_ID
1575: INTO l_site_use_id
1576: FROM HZ_CUST_ACCT_SITES ADDR
1577: ,HZ_CUST_SITE_USES_ALL SITE
1578: WHERE ADDR.CUST_ACCOUNT_ID = l_sold_to_org_id
1579: AND ADDR.STATUS = 'A'
1580: AND SITE.CUST_ACCT_SITE_ID = ADDR.CUST_ACCT_SITE_ID
1581: AND ADDR.ORG_ID = SITE.ORG_ID

Line 1747: ,HZ_CUST_SITE_USES_ALL SITE

1743:
1744: SELECT /* MOAC_SQL_CHANGE */ SITE.SITE_USE_ID
1745: INTO l_site_use_id
1746: FROM HZ_CUST_ACCT_SITES ADDR
1747: ,HZ_CUST_SITE_USES_ALL SITE
1748: WHERE ADDR.CUST_ACCOUNT_ID = l_sold_to_org_id
1749: AND ADDR.STATUS = 'A'
1750: AND SITE.CUST_ACCT_SITE_ID = ADDR.CUST_ACCT_SITE_ID
1751: AND SITE.ORG_ID = ADDR.ORG_ID