APPS.OE_DEFAULT_HEADER dependencies on HZ_CUST_ACCOUNTS

Line 175: from hz_cust_accounts

171:
172: Cursor C1 IS
173: Select SHIP_SETS_INCLUDE_LINES_FLAG,
174: ARRIVALSETS_INCLUDE_LINES_FLAG
175: from hz_cust_accounts
176: where
177: cust_account_id = p_header_rec.sold_to_org_id;
178: Cursor C2 IS
179: Select SHIP_SETS_INCLUDE_LINES_FLAG,

Line 875: FROM hz_cust_accounts cust_acct,

871: IF l_exists = 'Y' THEN
872: BEGIN
873: SELECT party.party_type
874: INTO l_party_type
875: FROM hz_cust_accounts cust_acct,
876: hz_parties party
877: WHERE party.party_id = cust_acct.party_id
878: AND cust_acct.cust_account_id = g_header_rec.sold_to_org_id;
879: EXCEPTION WHEN NO_DATA_FOUND THEN