APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on HZ_PARTIES

Line 108: hz_parties hzp

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

Line 307: hz_parties hzp

303: nvl(ced.contract_discount_amount,0) contract_discount_amount,
304: ced.after_warranty_cost
305: FROM cs_incidents_all_b ciab,
306: cs_estimate_details ced,
307: hz_parties hzp
308: WHERE ciab.incident_id = ced.incident_id
309: AND ced.bill_to_party_id = hzp.party_id
310: AND ced.line_submitted = 'N'
311: AND ced.charge_line_type = 'ACTUAL'

Line 337: hz_parties hzp

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

Line 378: hz_parties hzp

374: nvl(ced.contract_discount_amount,0) contract_discount_amount,
375: ced.after_warranty_cost
376: FROM cs_incidents_all_b ciab,
377: cs_estimate_details ced,
378: hz_parties hzp
379: WHERE ciab.incident_id = ced.incident_id
380: AND ced.bill_to_party_id = hzp.party_id
381: AND ced.line_submitted = 'N'
382: AND ced.charge_line_type = 'ACTUAL'

Line 419: hz_parties hzp,

415: ced.selling_price,
416: nvl(ced.contract_discount_amount,0) contract_discount_amount,
417: ced.after_warranty_cost
418: FROM cs_incidents_all_b ciab,
419: hz_parties hzp,
420: cs_estimate_details ced
421: WHERE ciab.incident_id = ced.incident_id
422: AND ced.bill_to_party_id = hzp.party_id
423: AND ciab.status_flag = 'C'