DBA Data[Home] [Help]

APPS.PQH_GSP_HR_TO_STAGE dependencies on PQH_TABLE_ROUTE

Line 2350: from pqh_table_route_vl

2346: p_table_name out nocopy varchar2 ) is
2347: begin
2348: select table_route_id, substr(display_name,1,30)
2349: into p_table_route_id, p_table_name
2350: from pqh_table_route_vl
2351: where table_alias = p_table_alias;
2352: hr_utility.set_location('table_route name is '||p_table_name,10);
2353: exception
2354: when no_data_found then

Line 4295: from pqh_table_route

4291: raise;
4292: end get_current_max_cer;
4293: procedure update_txn_table_route(p_copy_entity_txn_id in number) is
4294: cursor tr is select table_route_id,display_name,table_alias
4295: from pqh_table_route
4296: where from_clause ='OAB';
4297: begin
4298: for i in tr loop
4299: update ben_copy_entity_results