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.PA_PWP_INVOICE_REL dependencies on DUAL

Line 152: FROM dual

148: , NVL(
149: CASE
150: WHEN 1 =
151: (SELECT 1
152: FROM dual
153: WHERE EXISTS
154: (SELECT 1
155: FROM ar_payment_schedules_all arp
156: WHERE arp.status = 'OP'

Line 304: select fnd_global.user_id into l_user_id from dual;

300: SELECT org_id
301: INTO G_ORG_ID
302: FROM pa_implementations;
303:
304: select fnd_global.user_id into l_user_id from dual;
305: select sysdate into l_date from dual;
306:
307:
308: if (p_proj_num is null) then

Line 305: select sysdate into l_date from dual;

301: INTO G_ORG_ID
302: FROM pa_implementations;
303:
304: select fnd_global.user_id into l_user_id from dual;
305: select sysdate into l_date from dual;
306:
307:
308: if (p_proj_num is null) then
309: if ( P_from_proj_num is null ) then

Line 688: FROM dual

684: --cchek the condition of billed but not yet paid .
685: -- WE may need to check this based of Distribution rule
686: --write_log (LOG, 'is_billed start ');
687: SELECT 'N' into v_tmp
688: FROM dual
689: WHERE EXISTS
690: (
691: -- revnue generated but unbilled transactions exist for the AP Invoice
692: SELECT 1

Line 845: FROM dual

841: v_tmp VARCHAR2(1) := 'N';
842:
843: BEGIN
844: SELECT 'Y' into v_tmp
845: FROM dual
846: WHERE EXISTS
847: ( select 1 from PA_PWP_RELEASE_REPORT
848: where request_id = G_REQUEST_ID and AP_INVOICE_ID = p_invoice_id );
849:

Line 881: FROM dual

877:
878: BEGIN
879:
880: SELECT 'N' into v_tmp
881: FROM dual
882: WHERE EXISTS
883: ( select 1 from
884: pa_projects proj,
885: pa_expenditure_items_all ei