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_PSF_BUS dependencies on PQH_POSITION_TRANSACTIONS

Line 70: from pqh_position_transactions

66: l_transaction_status varchar2(100);
67: --
68: cursor c_position_transaction(p_position_transaction_id number) is
69: select transaction_status
70: from pqh_position_transactions
71: where position_transaction_id = p_position_transaction_id;
72: --
73: begin
74: null;

Line 115: from pqh_position_transactions

111: l_asg_max_count number;
112: --
113: cursor c_position_transaction(p_position_transaction_id number) is
114: select transaction_status
115: from pqh_position_transactions
116: where position_transaction_id = p_position_transaction_id;
117: --
118: cursor c_asg_max_count(p_position_id number
119: , p_validation_start_date date

Line 1346: from pqh_position_transactions

1342: l_position_transaction_id number;
1343: --
1344: cursor c1 is
1345: select position_transaction_id
1346: from pqh_position_transactions
1347: where position_id = nvl(p_position_id, -1)
1348: and transaction_status in ('SUBMITTED','APPROVED');
1349: --
1350: begin