APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_PRICE_PLANS_TL

Line 1478: from qpr_price_plans_tl

1474: and rownum = 1;
1475:
1476: cursor c_get_price_plan_tl(pp_id number) is
1477: select LANGUAGE,SOURCE_LANG, NAME, DESCRIPTION
1478: from qpr_price_plans_tl
1479: where PRICE_PLAN_ID = pp_id;
1480:
1481: cursor c_scopes is
1482: select DIM_CODE,HIERARCHY_ID,LEVEL_ID,OPERATOR,SCOPE_VALUE,

Line 1539: insert into QPR_PRICE_PLANS_TL(PRICE_PLAN_ID, LANGUAGE, SOURCE_LANG,

1535: g_request_id)
1536: returning PRICE_PLAN_ID into g_new_pp_id;
1537:
1538: for rec_pp_tl in c_get_price_plan_tl(p_from_pp_id) loop
1539: insert into QPR_PRICE_PLANS_TL(PRICE_PLAN_ID, LANGUAGE, SOURCE_LANG,
1540: NAME, DESCRIPTION, CREATION_DATE,
1541: CREATED_BY, LAST_UPDATE_DATE,LAST_UPDATED_BY,
1542: LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
1543: PROGRAM_ID, REQUEST_ID)