APPS.CZ_IMP_ALL dependencies on CZ_XFR_PRICE_LISTS

Line 540: select price_list_id from cz_xfr_price_lists

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

Line 547: nPriceListId cz_xfr_price_lists.price_list_id%type;

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

Line 573: update cz_xfr_price_lists set

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

Line 580: update cz_xfr_price_lists set

576: last_import_date=sysdate
577: where
578: price_list_id=nPriceListId;
579: else
580: update cz_xfr_price_lists set
581: source_price_deleted='1'
582: where
583: price_list_id=nPriceListId;
584: end if;