DBA Data[Home] [Help]

APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_PRICE_PLANS_B

Line 1472: from qpr_price_plans_b

1468: cursor c_get_price_plan(pp_id number) is
1469: select INSTANCE_ID, AW_TYPE_CODE, AW_CODE, AW_STATUS_CODE, START_DATE,
1470: END_DATE,BASE_UOM_CODE,
1471: CURRENCY_CODE
1472: from qpr_price_plans_b
1473: where PRICE_PLAN_ID = pp_id
1474: and rownum = 1;
1475:
1476: cursor c_get_price_plan_tl(pp_id number) is

Line 1516: insert into QPR_PRICE_PLANS_B(PRICE_PLAN_ID, INSTANCE_ID, AW_TYPE_CODE,

1512: end if;
1513:
1514: fnd_file.put_line(fnd_file.log,'Copying from price plan id:' || g_src_pplan_id);
1515:
1516: insert into QPR_PRICE_PLANS_B(PRICE_PLAN_ID, INSTANCE_ID, AW_TYPE_CODE,
1517: AW_STATUS_CODE, AW_CODE, AW_CREATED_FLAG,
1518: START_DATE, END_DATE,BASE_UOM_CODE,
1519: CURRENCY_CODE, AW_XML,
1520: TEMPLATE_FLAG,CREATION_DATE,