APPS.OE_OE_FORM_HEADER dependencies on HZ_PARTIES

Line 2356: hz_parties party,

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

Line 2845: FROM hz_parties party,

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

Line 3400: hz_parties party

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

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

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

Line 4060: from hz_parties

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