APPS.AMS_SCHEDULERULES_PVT dependencies on HZ_RELATIONSHIPS

Line 4475: from hz_relationships

4471: l_csch_offer_id NUMBER := null;
4472:
4473: cursor c_party_relationships_csr(p_party_id NUMBER) is
4474: select subject_id, object_id
4475: from hz_relationships
4476: where party_id = p_party_id;
4477:
4478: -- anchaudh 17th Mar'05 : modified the cursor to pull up only purchasable products for bug#3607972.
4479: cursor c_assoc_products_csr(p_schedule_id NUMBER) is

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

4514: select decode(pa.party_type,'PARTY_RELATIONSHIP','ORGANIZATION','PERSON') party_type,
4515: decode(pa.party_type,'PARTY_RELATIONSHIP',rel.subject_id,null) contact_party_id,
4516: decode(pa.party_type,'PARTY_RELATIONSHIP',TO_NUMBER(le.col147),le.party_id) main_party_id,
4517: decode(pa.party_type,'PARTY_RELATIONSHIP',le.party_id,null) rel_party_id
4518: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel
4519: where la.list_header_id = le.list_header_id
4520: and la.list_act_type = 'TARGET'
4521: and la.list_used_by = 'CSCH'
4522: and la.list_used_by_id = p_obj_id