APPS.MSC_PHUB_PKG dependencies on MSC_COSTS_F

Line 2045: select count(*) into l_n from msc_costs_f where customer_id>0 and customer_region_id>0 and rownum=1;

2041: update msc_demantra_ods_f set region_id=-23453 where customer_id>0;
2042: commit;
2043: end if;
2044:
2045: select count(*) into l_n from msc_costs_f where customer_id>0 and customer_region_id>0 and rownum=1;
2046: if (l_n > 0) then
2047: msc_phub_util.log('update msc_costs_f set customer_region_id=-23453 where customer_id>0');
2048: update msc_costs_f set customer_region_id=-23453 where customer_id>0;
2049: commit;

Line 2047: msc_phub_util.log('update msc_costs_f set customer_region_id=-23453 where customer_id>0');

2043: end if;
2044:
2045: select count(*) into l_n from msc_costs_f where customer_id>0 and customer_region_id>0 and rownum=1;
2046: if (l_n > 0) then
2047: msc_phub_util.log('update msc_costs_f set customer_region_id=-23453 where customer_id>0');
2048: update msc_costs_f set customer_region_id=-23453 where customer_id>0;
2049: commit;
2050: end if;
2051:

Line 2048: update msc_costs_f set customer_region_id=-23453 where customer_id>0;

2044:
2045: select count(*) into l_n from msc_costs_f where customer_id>0 and customer_region_id>0 and rownum=1;
2046: if (l_n > 0) then
2047: msc_phub_util.log('update msc_costs_f set customer_region_id=-23453 where customer_id>0');
2048: update msc_costs_f set customer_region_id=-23453 where customer_id>0;
2049: commit;
2050: end if;
2051:
2052: select count(*) into l_n from msc_exceptions_f where customer_id>0 and customer_region_id>0 and rownum=1;