DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on CSD_REPAIR_ESTIMATE_LINES

Line 3884: from csd_repair_estimate_lines

3880: BEGIN
3881:
3882: select 'X'
3883: into l_dummy
3884: from csd_repair_estimate_lines
3885: where repair_estimate_line_id = p_estimate_line_id;
3886:
3887: RETURN TRUE;
3888:

Line 4046: csd_repair_estimate_lines crel,

4042: Select
4043: sum(ced.after_warranty_cost)
4044: into l_amount
4045: from csd_repair_estimate cre,
4046: csd_repair_estimate_lines crel,
4047: cs_estimate_details ced,
4048: cs_txn_billing_types ctbt
4049: where cre.repair_estimate_id = crel.repair_estimate_id
4050: and crel.estimate_detail_id = ced.estimate_detail_id

Line 4061: csd_repair_estimate_lines crel,

4057: Select
4058: sum(ced.after_warranty_cost)
4059: into l_amount
4060: from csd_repair_estimate cre,
4061: csd_repair_estimate_lines crel,
4062: cs_estimate_details ced,
4063: cs_txn_billing_types ctbt
4064: where cre.repair_estimate_id = crel.repair_estimate_id
4065: and crel.estimate_detail_id = ced.estimate_detail_id

Line 4076: csd_repair_estimate_lines crel,

4072: Select
4073: sum(ced.after_warranty_cost)
4074: into l_amount
4075: from csd_repair_estimate cre,
4076: csd_repair_estimate_lines crel,
4077: cs_estimate_details ced,
4078: cs_txn_billing_types ctbt
4079: where cre.repair_estimate_id = crel.repair_estimate_id
4080: and crel.estimate_detail_id = ced.estimate_detail_id

Line 4091: csd_repair_estimate_lines crel,

4087: Select
4088: sum(ced.after_warranty_cost)
4089: into l_amount
4090: from csd_repair_estimate cre,
4091: csd_repair_estimate_lines crel,
4092: cs_estimate_details ced
4093: where cre.repair_estimate_id = crel.repair_estimate_id
4094: and crel.estimate_detail_id = ced.estimate_detail_id
4095: and cre.repair_line_id = p_repair_line_id ;