APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_ITEM_PRICES_INTERFACE

Line 409: pon_item_prices_interface ip,

405: pet.enabled_flag selected_enabled_flag
406:
407: FROM
408: pon_auc_price_elements_int pape,
409: pon_item_prices_interface ip,
410: pon_price_element_types pet
411:
412: WHERE
413: pape.batch_id = p_batch_id

Line 1226: pon_item_prices_interface ip

1222: pon_price_elements pe,
1223: pon_price_element_types pet,
1224: pon_price_element_types_tl petl,
1225: fnd_lookups fl,
1226: pon_item_prices_interface ip
1227: where
1228: ip.batch_id = p_batch_id
1229: and pe.auction_header_id = p_auction_template_id
1230: and pe.price_element_type_id = pet.price_element_type_id

Line 1319: pon_item_prices_interface ip

1315: att.attr_group_seq_number,
1316: att.attr_disp_seq_number
1317: from
1318: pon_auction_attributes att,
1319: pon_item_prices_interface ip
1320: where
1321: ip.batch_id = p_batch_id
1322: and att.line_number <> -1
1323: and ip.group_type <> 'GROUP'

Line 1546: FROM pon_item_prices_interface

1542: l_max_ip_seq_num NUMBER;
1543:
1544: CURSOR lines IS
1545: SELECT interface_line_id, auction_header_id, auction_line_number, ip_category_id
1546: FROM pon_item_prices_interface
1547: WHERE batch_id = p_batch_id and
1548: nvl(action, '+') = '+';
1549:
1550:

Line 1640: FROM pon_item_prices_interface

1636: -- updated lines where the ip category has changed and is not null;
1637:
1638: CURSOR lines IS
1639: SELECT interface_line_id, auction_header_id, auction_line_number, ip_category_id
1640: FROM pon_item_prices_interface
1641: WHERE batch_id = p_batch_id and
1642: nvl(action, '+') = '#' and
1643: auction_line_number in (select paip.line_number
1644: from pon_item_prices_interface p1,

Line 1644: from pon_item_prices_interface p1,

1640: FROM pon_item_prices_interface
1641: WHERE batch_id = p_batch_id and
1642: nvl(action, '+') = '#' and
1643: auction_line_number in (select paip.line_number
1644: from pon_item_prices_interface p1,
1645: pon_auction_item_prices_all paip
1646: where p1.batch_id = p_batch_id and
1647: nvl(p1.action, '+') = '#' and
1648: p1.auction_header_id = paip.auction_header_id and

Line 1660: from pon_item_prices_interface p1,

1656: delete from
1657: (select *
1658: from pon_auc_attributes_interface
1659: where auction_line_number in (select paip.line_number
1660: from pon_item_prices_interface p1,
1661: pon_auction_item_prices_all paip
1662: where p1.batch_id = p_batch_id and
1663: nvl(p1.action, '+') = '#' and
1664: p1.auction_header_id = paip.auction_header_id and