DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_PRICE_DIFF_DRAFT

Line 1474: FROM po_price_diff_draft

1470: p_entity_type_tbl(i),
1471: p_entity_id_tbl(i),
1472: v.max_price_diff_num
1473: FROM (SELECT max(price_differential_num) AS max_price_diff_num
1474: FROM po_price_diff_draft
1475: WHERE draft_id = p_draft_id_tbl(i)
1476: AND entity_type = p_entity_type_tbl(i)
1477: AND entity_id = p_entity_id_tbl(i)) v
1478: WHERE v.max_price_diff_num IS NOT NULL;

Line 1719: FROM po_price_diff_draft

1715: FORALL i IN 1..l_index_tbl.COUNT
1716: INSERT INTO po_session_gt(key, num1)
1717: SELECT l_key,
1718: l_index_tbl(i)
1719: FROM po_price_diff_draft
1720: WHERE entity_type = p_entity_type_tbl(i)
1721: AND entity_id = p_entity_id_tbl(i)
1722: AND draft_id = p_draft_id_tbl(i)
1723: AND price_differential_num = p_price_diff_num_tbl(i);