APPS.MSC_PHUB_PKG dependencies on MSC_DEMANDS_F

Line 2017: select count(*) into l_n from msc_demands_f where customer_id>0 and region_id>0 and rownum=1;

2013: l_n number := 0;
2014: begin
2015: msc_phub_util.log('msc_phub_pkg.clean_up_customer_keys');
2016:
2017: select count(*) into l_n from msc_demands_f where customer_id>0 and region_id>0 and rownum=1;
2018: if (l_n > 0) then
2019: msc_phub_util.log('update msc_demands_f set region_id=-23453 where customer_id>0');
2020: update msc_demands_f set region_id=-23453 where customer_id>0;
2021: commit;

Line 2019: msc_phub_util.log('update msc_demands_f set region_id=-23453 where customer_id>0');

2015: msc_phub_util.log('msc_phub_pkg.clean_up_customer_keys');
2016:
2017: select count(*) into l_n from msc_demands_f where customer_id>0 and region_id>0 and rownum=1;
2018: if (l_n > 0) then
2019: msc_phub_util.log('update msc_demands_f set region_id=-23453 where customer_id>0');
2020: update msc_demands_f set region_id=-23453 where customer_id>0;
2021: commit;
2022: end if;
2023:

Line 2020: update msc_demands_f set region_id=-23453 where customer_id>0;

2016:
2017: select count(*) into l_n from msc_demands_f where customer_id>0 and region_id>0 and rownum=1;
2018: if (l_n > 0) then
2019: msc_phub_util.log('update msc_demands_f set region_id=-23453 where customer_id>0');
2020: update msc_demands_f set region_id=-23453 where customer_id>0;
2021: commit;
2022: end if;
2023:
2024: select count(*) into l_n from msc_demands_cum_f where customer_id>0 and region_id>0 and rownum=1;