APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_MEASURE_SOURCES

Line 1797: from QPR_MEASURE_SOURCES

1793:
1794: cursor c_src_cols(m_type varchar2,m_ins_id number,m_src_tname varchar2, l_inst_type varchar2) is
1795: select distinct nvl(USER_SRC_COL_NAME,SRC_COL_NAME) SRC_COL_NAME,
1796: nvl(USER_TGT_COL_NAME, TGT_COL_NAME) TGT_COL_NAME
1797: from QPR_MEASURE_SOURCES
1798: where MEASURE_TYPE_CODE = m_type
1799: and INSTANCE_ID = m_ins_id
1800: and INSTANCE_TYPE = l_inst_type
1801: and nvl(user_src_tbl_name, src_tbl_name ) = m_src_tname

Line 1807: from QPR_MEASURE_SOURCES

1803:
1804: cursor c_srcs(m_type varchar2, m_ins_id number, l_inst_type varchar2)is
1805: select distinct nvl(USER_SRC_TBL_NAME, SRC_TBL_NAME) SRC_TBL_NAME,
1806: TGT_TBL_NAME
1807: from QPR_MEASURE_SOURCES
1808: where MEASURE_TYPE_CODE = m_type
1809: and INSTANCE_ID = m_ins_id
1810: and INSTANCE_TYPE = l_inst_type
1811: order by TGT_TBL_NAME;

Line 1842: from QPR_MEASURE_SOURCES

1838: from qpr_instances
1839: where instance_id = p_instance_id;
1840:
1841: select count(*) into l_src_count
1842: from QPR_MEASURE_SOURCES
1843: where INSTANCE_ID = p_instance_id
1844: and MEASURE_TYPE_CODE = p_meas_type;
1845:
1846: if l_src_count > 0 then

Line 1970: from qpr_measure_sources

1966: s_deal_type := p_src_choice;
1967: end if;
1968:
1969: select distinct src_tbl_name into src_tbl_name
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

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')