APPS.CZ_IMP_ALL dependencies on CZ_XFR_PRICE_LISTS

Line 537: select price_list_id from cz_xfr_price_lists

533:
534: declare
535:
536: cursor c_listcontrol is
537: select price_list_id from cz_xfr_price_lists
538: where deleted_flag='0';
539: cursor c_pricegroup(nPriceListId number) is
540: select desc_text from cz_price_groups
541: where orig_sys_ref=to_char(nPriceListId)

Line 544: nPriceListId cz_xfr_price_lists.price_list_id%type;

540: select desc_text from cz_price_groups
541: where orig_sys_ref=to_char(nPriceListId)
542: and deleted_flag='0';
543:
544: nPriceListId cz_xfr_price_lists.price_list_id%type;
545: sDescription cz_price_groups.desc_text%type;
546: sDisabled cz_xfr_tables.disabled%type;
547: xERROR BOOLEAN := FALSE;
548:

Line 570: update cz_xfr_price_lists set

566: open c_pricegroup(nPriceListId);
567: fetch c_pricegroup into sDescription;
568: begin
569: if(c_pricegroup%found)then
570: update cz_xfr_price_lists set
571: description=sDescription,
572: last_import_run_id=inRUN_ID,
573: last_import_date=sysdate
574: where

Line 577: update cz_xfr_price_lists set

573: last_import_date=sysdate
574: where
575: price_list_id=nPriceListId;
576: else
577: update cz_xfr_price_lists set
578: source_price_deleted='1'
579: where
580: price_list_id=nPriceListId;
581: end if;