APPS.OKS_EXTWARPRGM_PVT dependencies on HZ_PARTIES

Line 2239: AND hzr.subject_table_name = 'HZ_PARTIES'

2235: AND rah.party_relationship_id = hzr.party_relationship_id;*/
2236: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2237: WHERE rah.contact_id = p_contact_id
2238: AND rah.party_relationship_id = hzr.relationship_id
2239: AND hzr.subject_table_name = 'HZ_PARTIES'
2240: AND hzr.object_table_name = 'HZ_PARTIES'
2241: AND hzr.directional_flag = 'F';
2242:
2243: --END NPALEPU

Line 2240: AND hzr.object_table_name = 'HZ_PARTIES'

2236: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2237: WHERE rah.contact_id = p_contact_id
2238: AND rah.party_relationship_id = hzr.relationship_id
2239: AND hzr.subject_table_name = 'HZ_PARTIES'
2240: AND hzr.object_table_name = 'HZ_PARTIES'
2241: AND hzr.directional_flag = 'F';
2242:
2243: --END NPALEPU
2244:

Line 2287: AND hzr.subject_table_name = 'HZ_PARTIES'

2283: AND rah.party_relationship_id = hzr.party_relationship_id;*/
2284: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2285: WHERE rah.contact_id = p_contact_id
2286: AND rah.party_relationship_id = hzr.relationship_id
2287: AND hzr.subject_table_name = 'HZ_PARTIES'
2288: AND hzr.object_table_name = 'HZ_PARTIES'
2289: AND hzr.directional_flag = 'F';
2290:
2291: --END NPALEPU

Line 2288: AND hzr.object_table_name = 'HZ_PARTIES'

2284: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2285: WHERE rah.contact_id = p_contact_id
2286: AND rah.party_relationship_id = hzr.relationship_id
2287: AND hzr.subject_table_name = 'HZ_PARTIES'
2288: AND hzr.object_table_name = 'HZ_PARTIES'
2289: AND hzr.directional_flag = 'F';
2290:
2291: --END NPALEPU
2292:

Line 3813: AND hzr.subject_table_name = 'HZ_PARTIES'

3809: AND rah.party_relationship_id = hzr.party_relationship_id; */
3810: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
3811: WHERE rah.contact_id = p_contact_id
3812: AND rah.party_relationship_id = hzr.relationship_id
3813: AND hzr.subject_table_name = 'HZ_PARTIES'
3814: AND hzr.object_table_name = 'HZ_PARTIES'
3815: AND hzr.directional_flag = 'F';
3816:
3817: --END NPALEPU

Line 3814: AND hzr.object_table_name = 'HZ_PARTIES'

3810: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
3811: WHERE rah.contact_id = p_contact_id
3812: AND rah.party_relationship_id = hzr.relationship_id
3813: AND hzr.subject_table_name = 'HZ_PARTIES'
3814: AND hzr.object_table_name = 'HZ_PARTIES'
3815: AND hzr.directional_flag = 'F';
3816:
3817: --END NPALEPU
3818:

Line 16803: FROM hr_locations b, hr_all_organization_units c, hz_parties a

16799: -- Fix for bug 4142999
16800: CURSOR get_vendor_details
16801: IS
16802: SELECT a.party_name, b.country, b.region_2
16803: FROM hr_locations b, hr_all_organization_units c, hz_parties a
16804: WHERE b.location_id = c.location_id
16805: AND c.organization_id = p_authorg_id
16806: AND a.party_id = p_party_id;
16807:

Line 16811: FROM hz_parties hz, hz_party_sites hzs, hz_locations hzl

16807:
16808: CURSOR get_party_details
16809: IS
16810: SELECT hz.party_name, hzl.country, hzl.state
16811: FROM hz_parties hz, hz_party_sites hzs, hz_locations hzl
16812: WHERE hz.party_id = p_party_id
16813: AND hzs.party_id = hz.party_id
16814: AND hzs.identifying_address_flag = 'Y'
16815: AND hzl.location_id = hzs.location_id;