APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on HZ_RELATIONSHIPS

Line 118: From Hz_Relationships hr,

114: hcp.primary_flag,
115: decode(primary_flag,'Y','Y',NULL)
116: primary_contact,
117: timezone_id
118: From Hz_Relationships hr,
119: Hz_Parties hp_obj,
120: Hz_Parties hp_sub,
121: Hz_Contact_points hcp
122: Where hr.object_id = p_party_id

Line 138: from hz_relationships hr,hz_parties hp

134: and hcp.status(+) = 'A';
135:
136: cursor c_billto_shipto(p_billto_party NUMBER,p_shipto_party NUMBER) is
137: select hr.object_id,max(hr.party_id) party_id
138: from hz_relationships hr,hz_parties hp
139: where hr.object_id in (p_billto_party,p_shipto_party)
140: AND hr.status = 'A'
141: AND NVL(hr.start_date, SYSDATE-1) < SYSDATE
142: AND NVL(hr.end_date, SYSDATE+1) > SYSDATE