APPS.OE_FREIGHT_CHOICES_PVT dependencies on QP_LDETS_V

Line 1164: Select sum(nvl(l.ADJUSTMENT_AMOUNT,0)) into q_Adjusted_amount from QP_ldets_v l,QP_preq_lines_tmp q

1160: K := 1;
1161: K := l_line_tbl.FIRST;
1162: WHILE K IS NOT NULL LOOP
1163:
1164: Select sum(nvl(l.ADJUSTMENT_AMOUNT,0)) into q_Adjusted_amount from QP_ldets_v l,QP_preq_lines_tmp q
1165: where l.line_index = q.line_index
1166: and q.line_id = l_line_tbl(K).line_id
1167: and q.line_type_code = 'LINE'
1168: AND nvl(l.automatic_flag,'N') = 'Y'