3649: BEGIN
3650:
3651: select 'X'
3652: into l_dummy
3653: from csd_repair_estimate_lines
3654: where repair_estimate_line_id = p_estimate_line_id;
3655:
3656: RETURN TRUE;
3657:
3811: Select
3812: sum(ced.after_warranty_cost)
3813: into l_amount
3814: from csd_repair_estimate cre,
3815: csd_repair_estimate_lines crel,
3816: cs_estimate_details ced,
3817: cs_txn_billing_types ctbt
3818: where cre.repair_estimate_id = crel.repair_estimate_id
3819: and crel.estimate_detail_id = ced.estimate_detail_id
3826: Select
3827: sum(ced.after_warranty_cost)
3828: into l_amount
3829: from csd_repair_estimate cre,
3830: csd_repair_estimate_lines crel,
3831: cs_estimate_details ced,
3832: cs_txn_billing_types ctbt
3833: where cre.repair_estimate_id = crel.repair_estimate_id
3834: and crel.estimate_detail_id = ced.estimate_detail_id
3841: Select
3842: sum(ced.after_warranty_cost)
3843: into l_amount
3844: from csd_repair_estimate cre,
3845: csd_repair_estimate_lines crel,
3846: cs_estimate_details ced,
3847: cs_txn_billing_types ctbt
3848: where cre.repair_estimate_id = crel.repair_estimate_id
3849: and crel.estimate_detail_id = ced.estimate_detail_id
3856: Select
3857: sum(ced.after_warranty_cost)
3858: into l_amount
3859: from csd_repair_estimate cre,
3860: csd_repair_estimate_lines crel,
3861: cs_estimate_details ced
3862: where cre.repair_estimate_id = crel.repair_estimate_id
3863: and crel.estimate_detail_id = ced.estimate_detail_id
3864: and cre.repair_line_id = p_repair_line_id ;