APPS.QPR_COPY_PRICE_PLAN dependencies on QPR_SCOPES

Line 1484: from qpr_scopes

1480:
1481: cursor c_scopes is
1482: select DIM_CODE,HIERARCHY_ID,LEVEL_ID,OPERATOR,SCOPE_VALUE,
1483: SCOPE_VALUE_DESC
1484: from qpr_scopes
1485: where parent_entity_type = 'DATAMART'
1486: and parent_id = p_from_pp_id;
1487:
1488: begin

Line 1551: insert into QPR_SCOPES(SCOPE_ID,PARENT_ENTITY_TYPE, PARENT_ID,

1547: g_prg_appl_id, g_prg_id, g_request_id);
1548: end loop;
1549:
1550: for rec_scope in c_scopes loop
1551: insert into QPR_SCOPES(SCOPE_ID,PARENT_ENTITY_TYPE, PARENT_ID,
1552: DIM_CODE, HIERARCHY_ID, LEVEL_ID,
1553: OPERATOR, SCOPE_VALUE, SCOPE_VALUE_DESC,
1554: CREATION_DATE,
1555: CREATED_BY, LAST_UPDATE_DATE,LAST_UPDATED_BY,

Line 1558: values(qpr_scopes_s.nextval, 'DATAMART', g_new_pp_id,

1554: CREATION_DATE,
1555: CREATED_BY, LAST_UPDATE_DATE,LAST_UPDATED_BY,
1556: LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID,
1557: PROGRAM_ID, REQUEST_ID)
1558: values(qpr_scopes_s.nextval, 'DATAMART', g_new_pp_id,
1559: rec_scope.dim_code, rec_scope.hierarchy_id, rec_scope.level_id,
1560: rec_scope.operator, rec_scope.scope_value,
1561: rec_scope.scope_value_desc, g_sys_date,
1562: g_user_id, g_sys_date, g_user_id, g_login_id,