DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_WIZARD_API dependencies on PQH_TABLE_ROUTE

Line 216: from pqh_table_route

212: hr_utility.set_location('Entering: '||l_proc,10);
213: UPDATE ben_copy_entity_results cer
214: set (table_route_id, order_in_hierarchy) =
215: (select table_route_id,display_order
216: from pqh_table_route
217: where from_clause ='OAB'
218: and table_alias = cer.table_alias)
219: where cer.copy_entity_txn_id = p_copy_entity_txn_id
220: and( table_route_id is null

Line 244: from pqh_table_route

240: hr_utility.set_location('Entering: '||l_proc,10);
241: UPDATE ben_copy_entity_results cer
242: set (table_route_id, order_in_hierarchy) =
243: (select table_route_id,display_order
244: from pqh_table_route
245: where from_clause ='OAB'
246: and table_alias = cer.table_alias)
247: where cer.copy_entity_txn_id = p_copy_entity_txn_id
248: and (pd_parent_entity_result_id = p_parent_entity_result_id