APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on MRP_REGION_SITES

Line 2524: /* Also if the table MRP_REGION_SITES is empty */

2520: END IF; --- pCALLING_MODULE
2521:
2522: /* Before calling the function, check if sourcing actually is required */
2523: /* bug 5172853*/
2524: /* Also if the table MRP_REGION_SITES is empty */
2525: IF (( pCALLING_MODULE = G_COLLECTIONS
2526: AND lv_map_region_during_coll = SYS_YES
2527: AND ( pREFRESH_TYPE='C' OR pREFRESH_TYPE='P')
2528: AND lv_sourcing_flag = 1 )

Line 2537: FROM MRP_REGION_SITES;

2533: 'before calling MRP_MAP_REG_SITE.MAP_REGION_TO_SITE');
2534:
2535: SELECT max(last_update_date)
2536: INTO max_lrd
2537: FROM MRP_REGION_SITES;
2538:
2539: /* msx_lrd may have null value or a valid value */
2540:
2541: lv_task_start_time := SYSDATE;