APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_INSTANCES

Line 1838: from qpr_instances

1834: return;
1835: end if;
1836:
1837: select instance_type into l_inst_type
1838: from qpr_instances
1839: where instance_id = p_instance_id;
1840:
1841: select count(*) into l_src_count
1842: from QPR_MEASURE_SOURCES

Line 1974: from qpr_instances

1970: from qpr_measure_sources
1971: where measure_type_code = s_deal_type
1972: and tgt_tbl_name = DEAL_HEADER_TBL
1973: and INSTANCE_TYPE = (select instance_type
1974: from qpr_instances
1975: where instance_id = p_instance_id);
1976: if p_quote_header_id is null then
1977: l_sql := 'select quote_header_id, quote_header_sd, source_id from '
1978: || src_tbl_name||qpr_sr_util.get_dblink(p_instance_id)

Line 2052: from QPR_MEASURE_SOURCES src, qpr_instances inst

2048:
2049: cursor c_src_cols(m_src_tname varchar2) is
2050: select distinct nvl(USER_SRC_COL_NAME,SRC_COL_NAME) SRC_COL_NAME,
2051: nvl(USER_TGT_COL_NAME,TGT_COL_NAME) TGT_COL_NAME
2052: from QPR_MEASURE_SOURCES src, qpr_instances inst
2053: where src.instance_type = inst.instance_type
2054: and inst.instance_id = p_instance_id
2055: and src.measure_type_code = decode(p_source_id, 660, 'OM_DEALINT',
2056: 697, 'ASO_DEALINT')

Line 2062: from qpr_measure_sources src, qpr_instances inst

2058: order by TGT_COL_NAME;
2059:
2060: begin
2061: select distinct src_tbl_name into l_src_tbl
2062: from qpr_measure_sources src, qpr_instances inst
2063: where src.instance_type = inst.instance_type
2064: and inst.instance_id = p_instance_id
2065: and src.measure_type_code = decode(p_source_id, 660, 'OM_DEALINT',
2066: 697, 'ASO_DEALINT')