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_TCT_BUS dependencies on DUAL

Line 1379: from dual

1375: --
1376: if p_short_name ='BUDGET_WORKSHEET' then
1377: select 'Y'
1378: into l_dummy
1379: from dual
1380: where exists ( select null
1381: from pqh_worksheets
1382: where wf_transaction_category_id = p_transaction_category_id
1383: and transaction_status not in ('REJECT','TERMINATE','APPLIED'));

Line 1387: from dual

1383: and transaction_status not in ('REJECT','TERMINATE','APPLIED'));
1384: elsif p_short_name ='PQH_BPR' then
1385: select 'Y'
1386: into l_dummy
1387: from dual
1388: where exists ( select null from pqh_budget_pools
1389: where wf_transaction_category_id = p_transaction_category_id
1390: and approval_status in ('P'));
1391: elsif p_short_name ='POSITION_TRANSACTION' then

Line 1394: from dual

1390: and approval_status in ('P'));
1391: elsif p_short_name ='POSITION_TRANSACTION' then
1392: select 'Y'
1393: into l_dummy
1394: from dual
1395: where exists ( select null from pqh_position_transactions
1396: where wf_transaction_category_id = p_transaction_category_id
1397: and transaction_status not in ('REJECT','TERMINATE','APPLIED'));
1398: end if;