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

Line 44: from dual

40:
41:
42: cursor IsCostDistributed is
43: select 'NOT COST DISTRIBUTED'
44: from dual
45: where exists (
46: select ei.expenditure_item_id
47: from pa_expenditure_items_all ei
48: where ei.project_id = p_project_id

Line 56: from dual

52: and nvl(ei.cost_distributed_flag, 'N') <> 'Y') ;
53:
54: cursor IsTransImported is
55: select 'NOT IMPORTED'
56: from dual
57: where exists (
58: select 'X'
59: from pa_transaction_interface_all it,
60: pa_projects t

Line 70: from dual

66: and it.transaction_status_code <> 'A') ;
67:
68: cursor IsInterfaced (P_User_Source_Name IN VARCHAR2) is
69: select 'NOT Transferred and Accepted in other system'
70: from dual
71: where exists (
72: select ei.expenditure_item_id
73: from pa_expenditure_items_all ei,
74: pa_cost_distribution_lines_all cdl

Line 106: from dual

102:
103: /* Commented below code for R12 changes.
104: cursor IsMRCInterfaced (P_User_Source_Name IN VARCHAR2) is
105: select 'MRC NOT Transferred and Accepted in other system'
106: from dual
107: where exists (
108: select ei.expenditure_item_id
109: from pa_expenditure_items_all ei,
110: pa_mc_cost_dist_lines_all mrccdl

Line 131: from dual

127: */
128:
129: cursor IsResAccumulated is
130: select 'Cost not accumulated'
131: from dual
132: where exists (
133: select ei.expenditure_item_id
134: from pa_expenditure_items_all ei,
135: pa_cost_distribution_lines_all cdl

Line 146: from dual

142: and nvl(cdl.resource_accumulated_flag, 'N') <> 'Y') ;
143:
144: cursor IsBurdenDistributed is
145: select 'Not Burden Distributed'
146: from dual
147: where exists (
148: select ei.expenditure_item_id
149: from pa_expenditure_items_all ei,
150: pa_project_types_all pt,

Line 169: from dual

165: existence of records in pa_draft_invoice_details for the project. ***/
166: /* Bug#2416385 Commented for Phase-3 Archive and Purge
167: cursor IsIntercompany is
168: select 'INTERCOMPANY EIs INV EXISTS'
169: from dual
170: where exists (
171: select ei.expenditure_item_id
172: from pa_expenditure_items_all ei,
173: pa_tasks t

Line 185: from dual

181: */
182:
183: cursor IsBorrLentDistributed is
184: select 'NOT BL DISTRIBUTED'
185: from dual
186: where exists (
187: select ei.expenditure_item_id
188: from pa_expenditure_items_all ei
189: where ei.project_id = p_project_id

Line 197: from dual

193: and ei.cc_bl_distributed_code <> 'Y') ;
194:
195: cursor IsCCDLInterfaced (P_User_Source_Name IN VARCHAR2) is
196: select 'NOT Transferred and Accepted in other system'
197: from dual
198: where exists (
199: select ei.expenditure_item_id
200: from pa_expenditure_items_all ei,
201: pa_cc_dist_lines_all ccdl

Line 230: from dual

226: */
227:
228: cursor IsDestProjectType is
229: select 'This project is defined as a destination project in project type'
230: from dual
231: where exists (
232: select project_type
233: from pa_project_types
234: where burden_sum_dest_project_id = p_project_id

Line 247: FROM dual

243: find the parent record during transfer to PA.
244: *******************************************************************************/
245: CURSOR IsVIPaymentPendg IS
246: SELECT 'VENDOR INVOICE NOT FULLY PAID'
247: FROM dual
248: WHERE EXISTS ( SELECT aid.invoice_id
249: FROM ap_invoices_all ai,
250: ap_invoice_distributions_all aid
251: -- bug 2404115 WHERE ai.project_id = p_project_id

Line 275: from dual

271: /* bug 2396427. Inter project receiver project check. */
272: /* Bug#2416385 Commented for Phase-3 Archive and Purg
273: cursor ISInterPrjRecvPrj IS
274: select 'This is an Inter-Project Receiver Project'
275: from dual
276: where exists ( select NULL
277: from pa_tasks pt
278: where pt.project_id = p_project_id
279: and pt.receive_project_invoice_flag = 'Y'

Line 289: from dual

285: /* Bug# 2405565. Check whether discount lines are interfaced to projects. */
286:
287: cursor ISDistLinesIntfed IS
288: select 'Discount Not Interfaced'
289: from dual
290: where exists (
291: select null from ap_invoices ai,
292: ap_invoice_distributions aid,
293: -- ap_invoice_payments pay --R12 change

Line 319: from dual

315: /* Bug 2503876. Organization forecast Dummy projects should not be purged */
316:
317: cursor ISOrgForecastProject IS
318: select 'Organization Forecast Project'
319: from dual
320: where exists (
321: select null from pa_projects pj,
322: pa_project_types pt
323: where pj.project_id = p_project_id

Line 333: from dual

329: new concurrent process PRC:Archive/Purge Unassinged forecast items */
330:
331: cursor IsUnassignedTimeType IS
332: select 'Unassigned Time Project Type'
333: from dual
334: where exists ( select pt.project_type
335: from pa_project_types pt,
336: pa_projects p
337: where p.project_id = p_project_id

Line 346: from dual

342: /* This portion has been done dynamically since pa_interfaced_flag is not
343: added to ap_expense_report_lines table in release 11.5.3 bug 2695986
344: cursor IsIexpenseTxnsPending IS
345: select 'Iexpense Transactions Pending'
346: from dual
347: where exists (select h.report_header_id
348: from ap_expense_report_headers h,
349: ap_expense_report_lines l
350: where h.report_header_id = l.report_header_id

Line 362: from dual

358: for transfer to PA. Instead of using pa_interfaced_flag of ap_exp_lines
359: the check is done thru ap_invoice tables. */
360: cursor IsIexpenseTxnsPending IS
361: select 'Iexpense Transactions Pending'
362: from dual
363: where exists (
364: select null
365: from ap_expense_report_headers h,
366: ap_expense_report_lines l

Line 383: FROM dual

379:
380: /* Bug 2610276. Added Expense report payment check */
381: cursor IsERPaymentPendg IS
382: SELECT 'EXPENSE REPORTS NOT FULLY PAID'
383: FROM dual
384: WHERE EXISTS ( SELECT aid.invoice_id
385: FROM ap_invoices_all ai,
386: ap_invoice_distributions_all aid
387: WHERE aid.project_id = p_project_id

Line 815: ' from dual '||

811: from fnd_product_groups;
812:
813: IF l_dummy_num > 1154 THEN
814: V_Stmt := 'select ' || '''Iexpense Transactions Pending''' ||
815: ' from dual '||
816: ' where exists (select h.report_header_id '||
817: ' from ap_expense_report_headers h, '||
818: ' ap_expense_report_lines l '||
819: ' where h.report_header_id = l.report_header_id '||

Line 904: from dual

900: /* Modified these 2 cursors and added the modified code below for the bug#2272487 */
901:
902: cursor c_source is
903: select 1
904: from dual
905: where exists ( select null
906: from pa_alloc_run_sources pars,
907: pa_alloc_runs par
908: where par.rule_id = pars.rule_id

Line 917: from dual

913: );
914:
915: cursor c_target is
916: select 1
917: from dual
918: where exists ( select null
919: from pa_alloc_run_targets part,
920: pa_alloc_runs par
921: where par.rule_id = part.rule_id

Line 932: from dual

928: /* added the check for offsets for bug#2272487 */
929:
930: cursor c_offset is
931: select 1
932: from dual
933: where exists ( select null
934: from pa_alloc_rules_all para,
935: pa_alloc_runs par
936: where par.rule_id = para.rule_id