DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER dependencies on HZ_PARTY_SITES

Line 938: l_ship_to_party_site_id hz_party_sites.party_site_id%type;

934:
935: -- eBTax Changes
936: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
937: l_ship_to_party_id hz_cust_accounts.party_id%type;
938: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
939: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
940: l_bill_to_party_id hz_cust_accounts.party_id%type;
941: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
942: l_org_id NUMBER;

Line 941: l_bill_to_party_site_id hz_party_sites.party_site_id%type;

937: l_ship_to_party_id hz_cust_accounts.party_id%type;
938: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
939: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
940: l_bill_to_party_id hz_cust_accounts.party_id%type;
941: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
942: l_org_id NUMBER;
943:
944: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
945: SELECT cust_acct.cust_account_id,