[Home] [Help]
1467: p_entity_type_tbl(i),
1468: p_entity_id_tbl(i),
1469: v.max_price_diff_num
1470: FROM (SELECT max(price_differential_num) AS max_price_diff_num
1471: FROM po_price_diff_draft
1472: WHERE draft_id = p_draft_id_tbl(i)
1473: AND entity_type = p_entity_type_tbl(i)
1474: AND entity_id = p_entity_id_tbl(i)) v
1475: WHERE v.max_price_diff_num IS NOT NULL;
1712: FORALL i IN 1..l_index_tbl.COUNT
1713: INSERT INTO po_session_gt(key, num1)
1714: SELECT l_key,
1715: l_index_tbl(i)
1716: FROM po_price_diff_draft
1717: WHERE entity_type = p_entity_type_tbl(i)
1718: AND entity_id = p_entity_id_tbl(i)
1719: AND draft_id = p_draft_id_tbl(i)
1720: AND price_differential_num = p_price_diff_num_tbl(i);