APPS.MSC_PHUB_PKG dependencies on MSC_DEMANTRA_F

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

2027: update msc_demands_cum_f set region_id=-23453 where customer_id>0;
2028: commit;
2029: end if;
2030:
2031: select count(*) into l_n from msc_demantra_f where customer_id>0 and region_id>0 and rownum=1;
2032: if (l_n > 0) then
2033: msc_phub_util.log('update msc_demantra_f set region_id=-23453 where customer_id>0');
2034: update msc_demantra_f set region_id=-23453 where customer_id>0;
2035: commit;

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

2029: end if;
2030:
2031: select count(*) into l_n from msc_demantra_f where customer_id>0 and region_id>0 and rownum=1;
2032: if (l_n > 0) then
2033: msc_phub_util.log('update msc_demantra_f set region_id=-23453 where customer_id>0');
2034: update msc_demantra_f set region_id=-23453 where customer_id>0;
2035: commit;
2036: end if;
2037:

Line 2034: update msc_demantra_f set region_id=-23453 where customer_id>0;

2030:
2031: select count(*) into l_n from msc_demantra_f where customer_id>0 and region_id>0 and rownum=1;
2032: if (l_n > 0) then
2033: msc_phub_util.log('update msc_demantra_f set region_id=-23453 where customer_id>0');
2034: update msc_demantra_f set region_id=-23453 where customer_id>0;
2035: commit;
2036: end if;
2037:
2038: select count(*) into l_n from msc_demantra_ods_f where customer_id>0 and region_id>0 and rownum=1;