APPS.OKS_EXTWARPRGM_PVT dependencies on HZ_PARTIES

Line 2279: AND hzr.subject_table_name = 'HZ_PARTIES'

2275: AND rah.party_relationship_id = hzr.party_relationship_id;*/
2276: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2277: WHERE rah.contact_id = p_contact_id
2278: AND rah.party_relationship_id = hzr.relationship_id
2279: AND hzr.subject_table_name = 'HZ_PARTIES'
2280: AND hzr.object_table_name = 'HZ_PARTIES'
2281: AND hzr.directional_flag = 'F';
2282:
2283: --END NPALEPU

Line 2280: AND hzr.object_table_name = 'HZ_PARTIES'

2276: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2277: WHERE rah.contact_id = p_contact_id
2278: AND rah.party_relationship_id = hzr.relationship_id
2279: AND hzr.subject_table_name = 'HZ_PARTIES'
2280: AND hzr.object_table_name = 'HZ_PARTIES'
2281: AND hzr.directional_flag = 'F';
2282:
2283: --END NPALEPU
2284:

Line 2336: AND hzr.subject_table_name = 'HZ_PARTIES'

2332: AND rah.party_relationship_id = hzr.party_relationship_id;*/
2333: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2334: WHERE rah.contact_id = p_contact_id
2335: AND rah.party_relationship_id = hzr.relationship_id
2336: AND hzr.subject_table_name = 'HZ_PARTIES'
2337: AND hzr.object_table_name = 'HZ_PARTIES'
2338: AND hzr.directional_flag = 'F';
2339:
2340: --END NPALEPU

Line 2337: AND hzr.object_table_name = 'HZ_PARTIES'

2333: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2334: WHERE rah.contact_id = p_contact_id
2335: AND rah.party_relationship_id = hzr.relationship_id
2336: AND hzr.subject_table_name = 'HZ_PARTIES'
2337: AND hzr.object_table_name = 'HZ_PARTIES'
2338: AND hzr.directional_flag = 'F';
2339:
2340: --END NPALEPU
2341:

Line 3884: AND hzr.subject_table_name = 'HZ_PARTIES'

3880: AND rah.party_relationship_id = hzr.party_relationship_id; */
3881: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
3882: WHERE rah.contact_id = p_contact_id
3883: AND rah.party_relationship_id = hzr.relationship_id
3884: AND hzr.subject_table_name = 'HZ_PARTIES'
3885: AND hzr.object_table_name = 'HZ_PARTIES'
3886: AND hzr.directional_flag = 'F';
3887:
3888: --END NPALEPU

Line 3885: AND hzr.object_table_name = 'HZ_PARTIES'

3881: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
3882: WHERE rah.contact_id = p_contact_id
3883: AND rah.party_relationship_id = hzr.relationship_id
3884: AND hzr.subject_table_name = 'HZ_PARTIES'
3885: AND hzr.object_table_name = 'HZ_PARTIES'
3886: AND hzr.directional_flag = 'F';
3887:
3888: --END NPALEPU
3889:

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

17097: -- Fix for bug 4142999
17098: CURSOR get_vendor_details
17099: IS
17100: SELECT a.party_name, b.country, b.region_2
17101: FROM hr_locations b, hr_all_organization_units c, hz_parties a
17102: WHERE b.location_id = c.location_id
17103: AND c.organization_id = p_authorg_id
17104: AND a.party_id = p_party_id;
17105:

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

17105:
17106: CURSOR get_party_details
17107: IS
17108: SELECT hz.party_name, hzl.country, hzl.state
17109: FROM hz_parties hz, hz_party_sites hzs, hz_locations hzl
17110: WHERE hz.party_id = p_party_id
17111: AND hzs.party_id = hz.party_id
17112: AND hzs.identifying_address_flag = 'Y'
17113: AND hzl.location_id = hzs.location_id;