APPS.AMS_SCHEDULERULES_PVT dependencies on HZ_RELATIONSHIPS

Line 4445: from hz_relationships

4441: l_csch_offer_id NUMBER := null;
4442:
4443: cursor c_party_relationships_csr(p_party_id NUMBER) is
4444: select subject_id, object_id
4445: from hz_relationships
4446: where party_id = p_party_id;
4447:
4448: -- anchaudh 17th Mar'05 : modified the cursor to pull up only purchasable products for bug#3607972.
4449: cursor c_assoc_products_csr(p_schedule_id NUMBER) is

Line 4488: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel

4484: select decode(pa.party_type,'PARTY_RELATIONSHIP','ORGANIZATION','PERSON') party_type,
4485: decode(pa.party_type,'PARTY_RELATIONSHIP',rel.subject_id,null) contact_party_id,
4486: decode(pa.party_type,'PARTY_RELATIONSHIP',TO_NUMBER(le.col147),le.party_id) main_party_id,
4487: decode(pa.party_type,'PARTY_RELATIONSHIP',le.party_id,null) rel_party_id
4488: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel
4489: where la.list_header_id = le.list_header_id
4490: and la.list_act_type = 'TARGET'
4491: and la.list_used_by = 'CSCH'
4492: and la.list_used_by_id = p_obj_id