APPS.PQH_GENERIC dependencies on PQH_TABLE_ROUTE

Line 45: l_master_table_route_id pqh_table_route.table_route_id%TYPE;

41: l_status pqh_copy_entity_txns.status%TYPE;
42: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
43: l_transaction_short_name pqh_transaction_categories.short_name%TYPE;
44: l_name pqh_copy_entity_txns.display_name%TYPE;
45: l_master_table_route_id pqh_table_route.table_route_id%TYPE;
46: l_effective_date varchar2(30); -- would hold date in char format
47: l_function_context pqh_copy_entity_contexts.context%TYPE;
48: l_context pqh_copy_entity_txns.context%TYPE;
49: l_function_type_cd pqh_copy_entity_functions.function_type_cd%TYPE;

Line 84: from pqh_table_route trt

80: cursor c_tab_details(v_table_route_id number ) is
81: select trt.from_clause
82: , trt.where_clause
83: , trt.table_alias
84: from pqh_table_route trt
85: where trt.table_route_id = v_table_route_id;
86: --
87: -- Cursor for dependent table details
88: --

Line 94: from pqh_table_route trt

90: select trt.from_clause
91: , trt.table_route_id
92: , trt.where_clause
93: , trt.table_alias
94: from pqh_table_route trt
95: , pqh_copy_entity_prefs cep
96: where cep.copy_entity_txn_id = v_copy_entity_txn_id
97: and cep.table_route_id = trt.table_route_id
98: and cep.select_flag = 'Y' ;

Line 178: from pqh_table_route

174: and rownum < 2 ;
175: --
176: cursor c_table_route (v_alias in varchar2) is
177: select table_route_id
178: from pqh_table_route
179: where table_alias like v_alias ;
180: --
181: cursor c_dt is
182: select ddf_column_name