APPS.CSD_REPAIR_MANAGER_UTIL dependencies on CSD_AGING_THRESHOLDS_B

Line 597: FROM csd_aging_thresholds_b cat,

593: begin
594:
595: SELECT to_number('1')
596: into l_aging_threshold
597: FROM csd_aging_thresholds_b cat,
598: csd_repairs cr ,
599: (select * from csd_repair_history
600: where repair_line_id = p_repair_line_id and event_code = 'SC') crh ,
601: csd_flow_statuses_b cfs

Line 638: from csd_aging_thresholds_b

634: end;
635:
636: /*select threshold_days
637: into l_aging_threshold
638: from csd_aging_thresholds_b
639: where inventory_org_id = p_organization_id
640: and p_inventory_item_id =
641: ( select mic.inventory_item_id
642: from mtl_item_categories mic

Line 649: FROM csd_aging_thresholds_b cat,

645: and mic.inventory_item_id = p_inventory_item_id
646: );*/
647: SELECT to_number('1')
648: INTO l_aging_threshold
649: FROM csd_aging_thresholds_b cat,
650: csd_repairs cr ,
651: (select * from csd_repair_history
652: where repair_line_id = p_repair_line_id and event_code = 'SC') crh,
653: csd_flow_statuses_b cfs