DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_PRICE_DIFFERENTIALS

Line 1490: FROM po_price_differentials

1486: p_entity_type_tbl(i),
1487: p_entity_id_tbl(i),
1488: v.max_price_diff_num
1489: FROM (SELECT max(price_differential_num) AS max_price_diff_num
1490: FROM po_price_differentials
1491: WHERE entity_type = p_entity_type_tbl(i)
1492: AND entity_id = p_entity_id_tbl(i)) v
1493: WHERE v.max_price_diff_num IS NOT NULL;
1494:

Line 1732: FROM po_price_differentials

1728: FORALL i IN 1..l_index_tbl.COUNT
1729: INSERT INTO po_session_gt(key, num1)
1730: SELECT l_key,
1731: l_index_tbl(i)
1732: FROM po_price_differentials
1733: WHERE entity_type = p_entity_type_tbl(i)
1734: AND entity_id = p_entity_id_tbl(i)
1735: AND price_differential_num = p_price_diff_num_tbl(i);
1736: