DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_PRICE_DIFFERENTIALS

Line 1487: FROM po_price_differentials

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

Line 1729: FROM po_price_differentials

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