APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on HZ_PARTIES

Line 110: hz_parties hzp

106: nvl(edt.contract_discount_amount,0) contract_discount_amount,
107: edt.after_warranty_cost
108: FROM cs_estimate_details edt,
109: cs_incidents_all_b inc,
110: hz_parties hzp
111: WHERE edt.incident_id = inc.incident_id
112: AND edt.bill_to_party_id = hzp.party_id;
113:
114:

Line 309: hz_parties hzp

305: nvl(ced.contract_discount_amount,0) contract_discount_amount,
306: ced.after_warranty_cost
307: FROM cs_incidents_all_b ciab,
308: cs_estimate_details ced,
309: hz_parties hzp
310: WHERE ciab.incident_id = ced.incident_id
311: AND ced.bill_to_party_id = hzp.party_id
312: AND ced.line_submitted = 'N'
313: AND ced.order_line_id IS NULL --bug 7692111

Line 340: hz_parties hzp

336: nvl(ced.contract_discount_amount,0) contract_discount_amount,
337: ced.after_warranty_cost
338: FROM cs_incidents_all_b ciab,
339: cs_estimate_details ced,
340: hz_parties hzp
341: WHERE ciab.incident_id = ced.incident_id
342: AND ced.bill_to_party_id = hzp.party_id
343: AND ced.line_submitted = 'N'
344: AND ced.charge_line_type = 'ACTUAL'

Line 382: hz_parties hzp

378: nvl(ced.contract_discount_amount,0) contract_discount_amount,
379: ced.after_warranty_cost
380: FROM cs_incidents_all_b ciab,
381: cs_estimate_details ced,
382: hz_parties hzp
383: WHERE ciab.incident_id = ced.incident_id
384: AND ced.bill_to_party_id = hzp.party_id
385: AND ced.line_submitted = 'N'
386: AND ced.order_line_id IS NULL --bug 7647091

Line 424: hz_parties hzp,

420: ced.selling_price,
421: nvl(ced.contract_discount_amount,0) contract_discount_amount,
422: ced.after_warranty_cost
423: FROM cs_incidents_all_b ciab,
424: hz_parties hzp,
425: cs_estimate_details ced
426: WHERE ciab.incident_id = ced.incident_id
427: AND ced.bill_to_party_id = hzp.party_id
428: AND ciab.status_flag = 'C'