APPS.OKS_IB_UTIL_PVT dependencies on HZ_RELATIONSHIPS

Line 331: ,hz_relationships hr

327: Cursor l_bill_contact_csr Is
328: Select Decode(SUBSTR (hz.person_last_name || ','|| hz.person_first_name, 1,255),',',null,SUBSTR (hz.person_last_name || ', '|| hz.person_first_name, 1,255)) Billing_contact
329: From hz_parties hz
330: , okc_contacts oc2
331: ,hz_relationships hr
332: Where oc2.jtot_object1_code = 'OKX_PCONTACT'
333: And oc2.cro_code = 'BILLING'
334: AND oc2.dnz_chr_id = p_contract_id
335: AND hr.party_id = oc2.object1_id1

Line 1147: From Hz_relationships

1143: , p_transfer_date Date)
1144: Is
1145:
1146: Select distinct relationship_type
1147: From Hz_relationships
1148: Where ((object_id = p_new_customer And subject_id = p_old_customer)
1149: Or (object_id = p_old_customer And subject_id = p_new_customer))
1150: and relationship_type = p_relation
1151: And status = 'A'

Line 1248: From Hz_relationships

1244: , p_transfer_date Date)
1245: Is
1246:
1247: Select distinct relationship_type
1248: From Hz_relationships
1249: Where ((object_id = p_new_customer And subject_id = p_old_customer)
1250: Or (object_id = p_old_customer And subject_id = p_new_customer))
1251: and relationship_type = p_relation
1252: And status = 'A'

Line 1322: From Hz_relationships

1318: Cursor l_cust_rel_csr(p_old_customer Number, p_new_customer Number, p_relation Varchar2, p_transfer_date Date)
1319: Is
1320:
1321: Select distinct relationship_type
1322: From Hz_relationships
1323: Where ((object_id = p_new_customer And subject_id = p_old_customer)
1324: Or (object_id = p_old_customer And subject_id = p_new_customer))
1325: and relationship_type = p_relation
1326: And status = 'A'

Line 2265: FROM hz_relationships

2261: p_transfer_date DATE
2262: )
2263: IS
2264: SELECT DISTINCT relationship_type
2265: FROM hz_relationships
2266: WHERE ( ( object_id = p_new_customer
2267: AND subject_id = p_old_customer
2268: )
2269: OR ( object_id = p_old_customer