APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_SR_QUOTE_LINE_NUM_V

Line 979: l_sql := 'select QUOTE_LINE_NUMBER from qpr_sr_quote_line_num_v';

975: g_r_ins_deal.SOURCE_REF_LINE_ID(p_qtn_ictr) :=
976: g_t_src_lines(p_src_ctr).SOURCE_REF_LINE_ID;
977: if g_meas_type = ASO_MEAS_TYPE_DEALINT then
978: begin
979: l_sql := 'select QUOTE_LINE_NUMBER from qpr_sr_quote_line_num_v';
980: l_sql := l_sql || qpr_sr_util.get_dblink(g_instance_id);
981: l_sql := l_sql || ' where quote_header_id = :1 ';
982: l_sql := l_sql || ' and quote_line_id = :2 and source_id = :3';
983: execute immediate l_sql into l_line_no using

Line 1112: from qpr_sr_quote_line_num_v

1108: g_t_src_lines(p_src_ctr).SOURCE_REF_LINE_ID;
1109: if g_meas_type = ASO_MEAS_TYPE_DEALINT then
1110: begin
1111: select QUOTE_LINE_NUMBER into l_line_no
1112: from qpr_sr_quote_line_num_v
1113: where quote_header_id = g_t_src_lines(p_src_ctr).SOURCE_REF_HDR_ID
1114: and quote_line_id = g_t_src_lines(p_src_ctr).SOURCE_REF_LINE_ID
1115: and source_id = g_source_id;
1116: exception