APPS.OE_DEFAULT_PVT dependencies on HZ_PARTY_SITES

Line 153: HZ_PARTY_SITES PARTY_SITE,

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'
157: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 773: l_ship_to_party_site_id hz_party_sites.party_site_id%type;

769: */
770:
771: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
772: l_ship_to_party_id hz_cust_accounts.party_id%type;
773: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
774: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
775: l_bill_to_party_id hz_cust_accounts.party_id%type;
776: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
777: l_org_id NUMBER;

Line 776: l_bill_to_party_site_id hz_party_sites.party_site_id%type;

772: l_ship_to_party_id hz_cust_accounts.party_id%type;
773: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
774: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
775: l_bill_to_party_id hz_cust_accounts.party_id%type;
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