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 143: FROM dual

139: , NVL(
140: CASE
141: WHEN 1 =
142: (SELECT 1
143: FROM dual
144: WHERE EXISTS
145: (SELECT 1
146: FROM ar_payment_schedules_all arp
147: WHERE /*arp.status = 'OP' Bug 8284969 */

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

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

Line 306: select sysdate into l_date from dual;

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

Line 691: FROM dual

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

Line 853: FROM dual

849: v_tmp VARCHAR2(1) := 'N';
850:
851: BEGIN
852: SELECT 'Y' into v_tmp
853: FROM dual
854: WHERE EXISTS
855: ( select 1 from PA_PWP_RELEASE_REPORT
856: where request_id = G_REQUEST_ID and AP_INVOICE_ID = p_invoice_id );
857:

Line 889: FROM dual

885:
886: BEGIN
887:
888: SELECT 'N' into v_tmp
889: FROM dual
890: WHERE EXISTS
891: ( select 1 from
892: pa_projects proj,
893: pa_expenditure_items_all ei