APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on HZ_PARTIES

Line 87: hz_parties hp

83: hp.party_type
84: From ahl_unit_effectivities_app_v aueb,
85: csi_item_instances csi,
86: ahl_mr_headers_vl amh,
87: hz_parties hp
88: Where nvl(aueb.earliest_due_date,aueb.due_date) <= trunc(sysdate) + p_period_size
89: -- Get only the open UMPs and SR not created
90: and (aueb.status_code is NULL or aueb.status_code = 'INIT-DUE')
91: -- Application_usg_code PM for Preventive Maintenance seeded for CMRO 11.5.10 changes

Line 119: Hz_Parties hp_obj,

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
123: and hr.status = 'A'

Line 120: Hz_Parties hp_sub,

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
123: and hr.status = 'A'
124: and NVL(hr.start_date, SYSDATE-1) < SYSDATE

Line 133: and hcp.owner_table_name(+) = 'HZ_PARTIES'

129: and hp_obj.party_id = hr.object_id
130: and hp_obj.status = 'A'
131: and hp_obj.party_type = 'ORGANIZATION'
132: and hcp.owner_table_id(+) = hr.party_id
133: and hcp.owner_table_name(+) = 'HZ_PARTIES'
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

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