APPS.MSC_PHUB_PKG dependencies on MSC_DEMANTRA_ODS_F

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

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;
2039: if (l_n > 0) then
2040: msc_phub_util.log('update msc_demantra_ods_f set region_id=-23453 where customer_id>0');
2041: update msc_demantra_ods_f set region_id=-23453 where customer_id>0;
2042: commit;

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

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;
2039: if (l_n > 0) then
2040: msc_phub_util.log('update msc_demantra_ods_f set region_id=-23453 where customer_id>0');
2041: update msc_demantra_ods_f set region_id=-23453 where customer_id>0;
2042: commit;
2043: end if;
2044:

Line 2041: update msc_demantra_ods_f set region_id=-23453 where customer_id>0;

2037:
2038: select count(*) into l_n from msc_demantra_ods_f where customer_id>0 and region_id>0 and rownum=1;
2039: if (l_n > 0) then
2040: msc_phub_util.log('update msc_demantra_ods_f set region_id=-23453 where customer_id>0');
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;