APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_PRICE_ELEMENT_TYPES

Line 57: from pon_price_element_types_tl pet

53: update pon_auc_price_elements_int pape
54: set (pape.price_element_type_id, pape.description) = (
55: select pet.price_element_type_id,
56: pet.description
57: from pon_price_element_types_tl pet
58: where pet.name = pape.price_element_type_name
59: and pet.language = userenv('LANG')
60: )
61: where pape.batch_id = p_batch_id

Line 79: from pon_price_element_types pet

75: -- if null, default from price_element_type
76: update pon_auc_price_elements_int pape
77: set pape.pricing_basis = (
78: select pricing_basis
79: from pon_price_element_types pet
80: where pet.price_element_type_id = pape.price_element_type_id
81: )
82: where pape.batch_id = p_batch_id
83: and pape.pricing_basis_name is null;

Line 410: pon_price_element_types pet

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
414: and pape.price_element_type_id = pet.price_element_type_id

Line 1223: pon_price_element_types pet,

1219: pe.pf_type,
1220: pe.display_to_suppliers_flag
1221: from
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

Line 1224: pon_price_element_types_tl petl,

1220: pe.display_to_suppliers_flag
1221: from
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