DBA Data[Home] [Help]

APPS.CSD_CHARGE_LINE_UTIL dependencies on CSD_REPAIRS

Line 358: FROM csd_repairs

354: l_price_list_id NUMBER;
355: BEGIN
356: SELECT price_list_header_id
357: INTO l_price_list_id
358: FROM csd_repairs
359: WHERE repair_line_id = p_repair_line_id;
360:
361: IF (l_price_list_id is NOT NULL) THEN
362: return l_price_list_id;

Line 392: FROM cs_incidents_all_b ciab, csd_repairs cr

388: BEGIN
389:
390: SELECT account_id
391: INTO l_account_id
392: FROM cs_incidents_all_b ciab, csd_repairs cr
393: WHERE cr.repair_line_id = p_repair_line_id and cr.incident_id = ciab.incident_id;
394:
395: IF (l_account_id is NOT NULL) THEN
396: return l_account_id;

Line 429: FROM csd_repairs

425:
426: -- get default contract using repair order number
427: SELECT contract_line_id
428: INTO l_contract_line_id
429: FROM csd_repairs
430: WHERE repair_line_id = p_repair_line_id;
431:
432: IF (l_contract_line_id IS NOT NULL) THEN
433: RETURN l_contract_line_id;