APPS.OE_OE_FORM_HEADER dependencies on HZ_PARTIES

Line 2357: hz_parties party,

2353:
2354: FROM HZ_CUST_SITE_USES_ALL site,
2355: HZ_CUST_ACCT_SITES_ALL cas,
2356: hz_cust_accounts cust,
2357: hz_parties party,
2358: hz_party_sites ps,
2359: hz_locations addr
2360: WHERE site.cust_acct_site_id = cas.cust_acct_site_id
2361: AND site.site_use_code='DELIVER_TO'

Line 2846: FROM hz_parties party,

2842: BEGIN
2843:
2844: SELECT nvl(gsa_indicator_flag,'N')
2845: INTO x_gsa_indicator
2846: FROM hz_parties party,
2847: hz_cust_accounts acct
2848: WHERE acct.cust_account_id=p_sold_to_org_id
2849: AND party.party_id = acct.party_id;
2850:

Line 3403: hz_parties party

3399: from
3400: hz_cust_site_uses_all site,
3401: hz_cust_acct_sites_all cas,
3402: hz_cust_accounts cust,
3403: hz_parties party
3404: where site.site_use_code = p_site_use_code
3405: and site_use_id = p_site_use_id
3406: and site.cust_acct_site_id = cas.cust_acct_site_id
3407: and cas.cust_account_id = cust.cust_account_id

Line 4061: --check if the record is present in hz_parties

4057: select customer_id into l_customer_id
4058: from fnd_user
4059: where user_id = l_user_id;
4060:
4061: --check if the record is present in hz_parties
4062: select 1 into l_dummy
4063: from hz_parties
4064: where party_id = l_customer_id;
4065:

Line 4063: from hz_parties

4059: where user_id = l_user_id;
4060:
4061: --check if the record is present in hz_parties
4062: select 1 into l_dummy
4063: from hz_parties
4064: where party_id = l_customer_id;
4065:
4066:
4067: ---Get user preferences