APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on HZ_RELATIONSHIPS

Line 127: From Hz_Relationships hr,

123: hcp.primary_flag,
124: decode(primary_flag,'Y','Y',NULL)
125: primary_contact,
126: timezone_id
127: From Hz_Relationships hr,
128: Hz_Parties hp_obj,
129: Hz_Parties hp_sub,
130: Hz_Contact_points hcp
131: Where hr.object_id = p_party_id

Line 148: from hz_relationships hr,hz_parties hp

144: and hr.party_id is not null;
145:
146: cursor c_billto_shipto(p_billto_party NUMBER,p_shipto_party NUMBER) is
147: select hr.object_id,max(hr.party_id) party_id
148: from hz_relationships hr,hz_parties hp
149: where hr.object_id in (p_billto_party,p_shipto_party)
150: AND hr.status = 'A'
151: AND NVL(hr.start_date, SYSDATE-1) < SYSDATE
152: AND NVL(hr.end_date, SYSDATE+1) > SYSDATE