DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_LINE dependencies on HZ_PARTY_SITES

Line 1176: l_ship_to_party_site_id hz_party_sites.party_site_id%type;

1172:
1173: -- eBTax Changes
1174: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1175: l_ship_to_party_id hz_cust_accounts.party_id%type;
1176: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
1177: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1178: l_bill_to_party_id hz_cust_accounts.party_id%type;
1179: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
1180: l_org_id NUMBER;

Line 1179: l_bill_to_party_site_id hz_party_sites.party_site_id%type;

1175: l_ship_to_party_id hz_cust_accounts.party_id%type;
1176: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
1177: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
1178: l_bill_to_party_id hz_cust_accounts.party_id%type;
1179: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
1180: l_org_id NUMBER;
1181: -- l_legal_entity_id NUMBER;
1182:
1183: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is