DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on CSD_REPAIR_ESTIMATE_LINES

Line 3653: from csd_repair_estimate_lines

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:

Line 3815: csd_repair_estimate_lines crel,

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

Line 3830: csd_repair_estimate_lines crel,

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

Line 3845: csd_repair_estimate_lines crel,

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

Line 3860: csd_repair_estimate_lines crel,

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 ;