APPS.OKS_AUTO_REMINDER dependencies on HZ_RELATIONSHIPS

Line 128: --Replaced hz_party_relationships table with hz_relationships table

124: hz_parties hp,
125: --NPALEPU
126: --08-AUG-2005
127: --TCA Project
128: --Replaced hz_party_relationships table with hz_relationships table
129: -- hz_party_relationships hpr --
130: hz_relationships hpr
131: --END NPALEPU
132: WHERE okpr.rle_code = 'CUSTOMER'

Line 130: hz_relationships hpr

126: --08-AUG-2005
127: --TCA Project
128: --Replaced hz_party_relationships table with hz_relationships table
129: -- hz_party_relationships hpr --
130: hz_relationships hpr
131: --END NPALEPU
132: WHERE okpr.rle_code = 'CUSTOMER'
133: AND jtot_object1_code = 'OKX_PARTY'
134: AND okpr.object1_id1 = hp.party_id

Line 164: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts with OKS_RA_HCONTACTS_V

160: FROM oks_k_headers_b kh,
161: --NPALEPU
162: --08-AUG-2005
163: --TCA Project
164: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts with OKS_RA_HCONTACTS_V
165: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
166: --ra_hcontacts rah,
167: hz_party_relationships hzr
168: WHERE kh.chr_id = p_chr_id

Line 172: hz_relationships hzr

168: WHERE kh.chr_id = p_chr_id
169: AND kh.quote_to_contact_id = rah.contact_id
170: AND rah.party_relationship_id = hzr.party_relationship_id;
171: OKS_RA_HCONTACTS_V rah,
172: hz_relationships hzr
173: WHERE kh.chr_id = p_chr_id
174: AND kh.quote_to_contact_id = rah.contact_id
175: AND rah.party_relationship_id = hzr.relationship_id
176: AND hzr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 199: hz_relationships rln,

195: )
196: IS
197: SELECT hzp.party_id
198: FROM hz_cust_account_roles car,
199: hz_relationships rln,
200: hz_parties hzp
201: WHERE car.cust_account_role_id = p_quote_to_contact_id
202: AND car.party_id = rln.party_id
203: AND rln.subject_id = hzp.party_id

Line 399: hz_relationships rln,

395: CURSOR csr_qtc_person_party_id
396: IS
397: SELECT hzp.party_id
398: FROM hz_cust_account_roles car,
399: hz_relationships rln,
400: hz_parties hzp,
401: oks_k_headers_b ks
402: WHERE ks.quote_to_contact_id = car.cust_account_role_id
403: AND car.party_id = rln.party_id

Line 2632: hz_relationships rln,

2628: )
2629: IS
2630: SELECT hzp.party_id
2631: FROM hz_cust_account_roles car,
2632: hz_relationships rln,
2633: hz_parties hzp
2634: WHERE car.cust_account_role_id = p_quote_to_contact_id
2635: AND car.party_id = rln.party_id
2636: AND rln.subject_id = hzp.party_id

Line 2692: FROM hz_relationships r , hz_parties p

2688: l_fnd_per_party_name hz_parties.party_name%TYPE;
2689:
2690: CURSOR csr_get_party_name (p_party_id IN NUMBER) IS
2691: SELECT p.party_name , p.party_id
2692: FROM hz_relationships r , hz_parties p
2693: WHERE p.party_id = r.object_id
2694: AND r.subject_type='PERSON'
2695: AND r.object_type='ORGANIZATION'
2696: AND r.subject_id = p_party_id;