eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BUDGET dependencies on PQH_ROUTING_HISTORY

Line 59: cursor c0 is select max(routing_history_id) from pqh_routing_history

55: l_person_name varchar2(200);
56: l_position_name varchar2(200);
57: l_max_routing_history_id number;
58: -- for pulling up the record # of routing history, if it is 0 then no routing history
59: cursor c0 is select max(routing_history_id) from pqh_routing_history
60: where transaction_category_id = p_transaction_category_id
61: and transaction_id = p_worksheet_detail_id ;
62: -- for pulling up the latest routing history details if any
63: cursor c1 is select person_name_to,role_name_to,position_name_to,user_name_to

Line 64: from pqh_routing_history_v

60: where transaction_category_id = p_transaction_category_id
61: and transaction_id = p_worksheet_detail_id ;
62: -- for pulling up the latest routing history details if any
63: cursor c1 is select person_name_to,role_name_to,position_name_to,user_name_to
64: from pqh_routing_history_v
65: where transaction_id = p_worksheet_detail_id
66: and transaction_category_id = p_transaction_category_id
67: and routing_history_id = l_max_routing_history_id ;
68: -- for pulling up the manager for the delegated worksheet