APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_MEASURE_SOURCES

Line 1784: from QPR_MEASURE_SOURCES

1780:
1781: cursor c_src_cols(m_type varchar2,m_ins_id number,m_src_tname varchar2, l_inst_type varchar2) is
1782: select distinct nvl(USER_SRC_COL_NAME,SRC_COL_NAME) SRC_COL_NAME,
1783: nvl(USER_TGT_COL_NAME, TGT_COL_NAME) TGT_COL_NAME
1784: from QPR_MEASURE_SOURCES
1785: where MEASURE_TYPE_CODE = m_type
1786: and INSTANCE_ID = m_ins_id
1787: and INSTANCE_TYPE = l_inst_type
1788: and nvl(user_src_tbl_name, src_tbl_name ) = m_src_tname

Line 1794: from QPR_MEASURE_SOURCES

1790:
1791: cursor c_srcs(m_type varchar2, m_ins_id number, l_inst_type varchar2)is
1792: select distinct nvl(USER_SRC_TBL_NAME, SRC_TBL_NAME) SRC_TBL_NAME,
1793: TGT_TBL_NAME
1794: from QPR_MEASURE_SOURCES
1795: where MEASURE_TYPE_CODE = m_type
1796: and INSTANCE_ID = m_ins_id
1797: and INSTANCE_TYPE = l_inst_type
1798: order by TGT_TBL_NAME;

Line 1829: from QPR_MEASURE_SOURCES

1825: from qpr_instances
1826: where instance_id = p_instance_id;
1827:
1828: select count(*) into l_src_count
1829: from QPR_MEASURE_SOURCES
1830: where INSTANCE_ID = p_instance_id
1831: and MEASURE_TYPE_CODE = p_meas_type;
1832:
1833: if l_src_count > 0 then

Line 1957: from qpr_measure_sources

1953: s_deal_type := p_src_choice;
1954: end if;
1955:
1956: select distinct src_tbl_name into src_tbl_name
1957: from qpr_measure_sources
1958: where measure_type_code = s_deal_type
1959: and tgt_tbl_name = DEAL_HEADER_TBL
1960: and INSTANCE_TYPE = (select instance_type
1961: from qpr_instances

Line 2039: from QPR_MEASURE_SOURCES src, qpr_instances inst

2035:
2036: cursor c_src_cols(m_src_tname varchar2) is
2037: select distinct nvl(USER_SRC_COL_NAME,SRC_COL_NAME) SRC_COL_NAME,
2038: nvl(USER_TGT_COL_NAME,TGT_COL_NAME) TGT_COL_NAME
2039: from QPR_MEASURE_SOURCES src, qpr_instances inst
2040: where src.instance_type = inst.instance_type
2041: and inst.instance_id = p_instance_id
2042: and src.measure_type_code = decode(p_source_id, 660, 'OM_DEALINT',
2043: 697, 'ASO_DEALINT')

Line 2049: from qpr_measure_sources src, qpr_instances inst

2045: order by TGT_COL_NAME;
2046:
2047: begin
2048: select distinct src_tbl_name into l_src_tbl
2049: from qpr_measure_sources src, qpr_instances inst
2050: where src.instance_type = inst.instance_type
2051: and inst.instance_id = p_instance_id
2052: and src.measure_type_code = decode(p_source_id, 660, 'OM_DEALINT',
2053: 697, 'ASO_DEALINT')