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 2775: hz_relationships rln,

2771: )
2772: IS
2773: SELECT hzp.party_id
2774: FROM hz_cust_account_roles car,
2775: hz_relationships rln,
2776: hz_parties hzp
2777: WHERE car.cust_account_role_id = p_quote_to_contact_id
2778: AND car.party_id = rln.party_id
2779: AND rln.subject_id = hzp.party_id

Line 2835: FROM hz_relationships r , hz_parties p

2831: l_fnd_per_party_name hz_parties.party_name%TYPE;
2832:
2833: CURSOR csr_get_party_name (p_party_id IN NUMBER) IS
2834: SELECT p.party_name , p.party_id
2835: FROM hz_relationships r , hz_parties p
2836: WHERE p.party_id = r.object_id
2837: AND r.subject_type='PERSON'
2838: AND r.object_type='ORGANIZATION'
2839: AND r.subject_id = p_party_id;