DBA Data[Home] [Help]

APPS.GMD_ROUTINGS_PVT dependencies on GMD_OPERATIONS_B

Line 257: FROM gmd_operations_b o, fm_rout_dtl d

253:
254: CURSOR Get_oprn_start_end_dates(vRouting_id NUMBER) IS
255: SELECT max(effective_start_date) effective_start_date
256: , min(effective_end_date) effective_end_date
257: FROM gmd_operations_b o, fm_rout_dtl d
258: WHERE o.oprn_id = d.oprn_id
259: AND d.routing_id = vRouting_id
260: AND o.delete_mark = 0;
261:

Line 632: FROM gmd_operations_b o, fm_rout_dtl d

628:
629: CURSOR Get_oprn_start_end_dates(vRouting_id NUMBER) IS
630: SELECT max(effective_start_date) effective_start_date
631: , min(effective_end_date) effective_end_date
632: FROM gmd_operations_b o, fm_rout_dtl d
633: WHERE o.oprn_id = d.oprn_id
634: AND d.routing_id = vRouting_id
635: AND o.delete_mark = 0;
636: BEGIN