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.

[Home] [Help]

APPS.PA_RETENTION_PKG dependencies on PA_TASKS

Line 664: FROM pa_proj_retn_rules rt, pa_tasks tsk

660: rt.effective_end_date effective_end_date ,
661: tsk.task_number task_number,
662: tsk.task_name task_name,
663: rt.task_id task_id
664: FROM pa_proj_retn_rules rt, pa_tasks tsk
665: WHERE rt.retention_rule_id = RetentionRuleID
666: AND rt.task_id = tsk.task_id(+);
667:
668: retn_rule_rec cur_retn_rule%ROWTYPE;

Line 2184: pa_tasks tsk

2180: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2181: -1,rt.retention_rule_id,-99))
2182: FROM pa_proj_retn_rules rt,
2183: pa_expenditure_items_all ei,
2184: pa_tasks tsk
2185: WHERE tsk.task_id = ei.task_id
2186: AND tsk.top_task_id = rt.task_id
2187: AND rt.customer_id = ProjCustRec.customer_id
2188: AND rt.project_id = p_project_id

Line 2202: pa_tasks tsk

2198: AND EXISTS(
2199: SELECT NULL
2200: FROM pa_proj_retn_rules rt,
2201: pa_expenditure_items_all ei,
2202: pa_tasks tsk
2203: WHERE tsk.task_id = ei.task_id
2204: AND tsk.top_task_id = rt.task_id
2205: AND rt.customer_id = ProjCustRec.customer_id
2206: AND rt.project_id = p_project_id

Line 2226: pa_tasks tsk

2222: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2223: -1,rt.retention_rule_id,-99))
2224: FROM pa_proj_retn_rules rt,
2225: pa_expenditure_items_all ei,
2226: pa_tasks tsk
2227: WHERE tsk.task_id = ei.task_id
2228: AND tsk.top_task_id = rt.task_id
2229: AND rt.customer_id = ProjCustRec.customer_id
2230: AND rt.project_id = p_project_id

Line 2245: pa_tasks tsk

2241: AND EXISTS(
2242: SELECT NULL
2243: FROM pa_proj_retn_rules rt,
2244: pa_expenditure_items_all ei,
2245: pa_tasks tsk
2246: WHERE tsk.task_id = ei.task_id
2247: AND tsk.top_task_id = rt.task_id
2248: AND rt.customer_id = ProjCustRec.customer_id
2249: AND rt.project_id = p_project_id

Line 2271: pa_tasks tsk

2267: -1,rt.retention_rule_id,-99))
2268: FROM pa_proj_retn_rules rt,
2269: pa_expenditure_items_all ei,
2270: pa_expenditure_types et,
2271: pa_tasks tsk
2272: WHERE tsk.task_id = ei.task_id
2273: AND tsk.top_task_id = rt.task_id
2274: AND rt.customer_id = ProjCustRec.customer_id
2275: AND rt.project_id = p_project_id

Line 2293: pa_tasks tsk

2289: SELECT NULL
2290: FROM pa_proj_retn_rules rt,
2291: pa_expenditure_items_all ei,
2292: pa_expenditure_types et,
2293: pa_tasks tsk
2294: WHERE tsk.task_id = ei.task_id
2295: AND tsk.top_task_id = rt.task_id
2296: AND rt.customer_id = ProjCustRec.customer_id
2297: AND rt.project_id = p_project_id

Line 2319: pa_tasks tsk

2315: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),
2316: -1,rt.retention_rule_id,-99))
2317: FROM pa_proj_retn_rules rt,
2318: pa_expenditure_items_all ei,
2319: pa_tasks tsk
2320: WHERE tsk.task_id = ei.task_id
2321: AND tsk.top_task_id = rt.task_id
2322: AND rt.customer_id = ProjCustRec.customer_id
2323: AND rt.project_id = p_project_id

Line 2336: pa_tasks tsk

2332: AND rdl.retention_rule_id IS NULL
2333: AND EXISTS(SELECT NULL
2334: FROM pa_proj_retn_rules rt,
2335: pa_expenditure_items_all ei,
2336: pa_tasks tsk
2337: WHERE tsk.task_id = ei.task_id
2338: AND tsk.top_task_id = rt.task_id
2339: AND rt.customer_id = ProjCustRec.customer_id
2340: AND rt.project_id = p_project_id

Line 2362: pa_tasks tsk

2358: -1,rt.retention_rule_id,-99))
2359: FROM pa_proj_retn_rules rt,
2360: pa_events evt,
2361: pa_event_types evttyp,
2362: pa_tasks tsk
2363: WHERE tsk.task_id = evt.task_id
2364: AND tsk.top_task_id = rt.task_id
2365: AND rt.customer_id = ProjCustRec.customer_id
2366: AND rt.project_id = p_project_id

Line 2386: pa_tasks tsk

2382: (SELECT NULL
2383: FROM pa_proj_retn_rules rt,
2384: pa_events evt,
2385: pa_event_types evttyp,
2386: pa_tasks tsk
2387: WHERE tsk.task_id = evt.task_id
2388: AND tsk.top_task_id = rt.task_id
2389: AND rt.customer_id = ProjCustRec.customer_id
2390: AND rt.project_id = p_project_id

Line 2417: pa_tasks tsk

2413: -1,rt.retention_rule_id,-99))
2414: FROM pa_proj_retn_rules rt,
2415: pa_events evt,
2416: pa_event_types evttyp,
2417: pa_tasks tsk
2418: WHERE tsk.task_id = evt.task_id
2419: AND tsk.top_task_id = rt.task_id
2420: AND rt.customer_id = ProjCustRec.customer_id
2421: AND rt.project_id = p_project_id

Line 2439: pa_tasks tsk

2435: AND EXISTS (SELECT NULL
2436: FROM pa_proj_retn_rules rt,
2437: pa_events evt,
2438: pa_event_types evttyp,
2439: pa_tasks tsk
2440: WHERE tsk.task_id = evt.task_id
2441: AND tsk.top_task_id = rt.task_id
2442: AND rt.customer_id = ProjCustRec.customer_id
2443: AND rt.project_id = p_project_id

Line 2469: pa_tasks tsk

2465: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2466: -1,rt.retention_rule_id,-99))
2467: FROM pa_proj_retn_rules rt,
2468: pa_events evt,
2469: pa_tasks tsk
2470: WHERE tsk.task_id = evt.task_id
2471: AND tsk.top_task_id = rt.task_id
2472: AND rt.customer_id = ProjCustRec.customer_id
2473: AND rt.project_id = p_project_id

Line 2488: pa_tasks tsk

2484: AND erdl.retention_rule_id IS NULL
2485: AND EXISTS( SELECT NULL
2486: FROM pa_proj_retn_rules rt,
2487: pa_events evt,
2488: pa_tasks tsk
2489: WHERE tsk.task_id = evt.task_id
2490: AND tsk.top_task_id = rt.task_id
2491: AND rt.customer_id = ProjCustRec.customer_id
2492: AND rt.project_id = p_project_id

Line 2517: pa_tasks tsk

2513: -1,rt.retention_rule_id,-99))
2514: FROM pa_proj_retn_rules rt,
2515: pa_events evt,
2516: pa_event_types evttyp,
2517: pa_tasks tsk
2518: WHERE tsk.task_id = evt.task_id
2519: AND tsk.top_task_id = rt.task_id
2520: AND rt.customer_id = ProjCustRec.customer_id
2521: AND rt.project_id = p_project_id

Line 2544: pa_tasks tsk

2540: AND EXISTS( SELECT NULL
2541: FROM pa_proj_retn_rules rt,
2542: pa_events evt,
2543: pa_event_types evttyp,
2544: pa_tasks tsk
2545: WHERE tsk.task_id = evt.task_id
2546: AND tsk.top_task_id = rt.task_id
2547: AND rt.customer_id = ProjCustRec.customer_id
2548: AND rt.project_id = p_project_id

Line 2578: pa_tasks tsk

2574: -1,rt.retention_rule_id,-99))
2575: FROM pa_proj_retn_rules rt,
2576: pa_events evt,
2577: pa_event_types evttyp,
2578: pa_tasks tsk
2579: WHERE tsk.task_id = evt.task_id
2580: AND tsk.top_task_id = rt.task_id
2581: AND rt.customer_id = ProjCustRec.customer_id
2582: AND rt.project_id = p_project_id

Line 2604: pa_tasks tsk

2600: AND EXISTS( SELECT NULL
2601: FROM pa_proj_retn_rules rt,
2602: pa_events evt,
2603: pa_event_types evttyp,
2604: pa_tasks tsk
2605: WHERE tsk.task_id = evt.task_id
2606: AND tsk.top_task_id = rt.task_id
2607: AND rt.customer_id = ProjCustRec.customer_id
2608: AND rt.project_id = p_project_id

Line 2638: pa_tasks tsk

2634: -1,rt.retention_rule_id,-99))
2635: FROM pa_proj_retn_rules rt,
2636: pa_events evt,
2637: pa_event_types evttyp, /* Bug 3258414 */
2638: pa_tasks tsk
2639: WHERE tsk.task_id = evt.task_id
2640: AND tsk.top_task_id = rt.task_id
2641: AND rt.customer_id = ProjCustRec.customer_id
2642: AND rt.project_id = p_project_id

Line 2663: pa_tasks tsk

2659: AND EXISTS
2660: (SELECT NULL FROM pa_proj_retn_rules rt,
2661: pa_events evt,
2662: pa_event_types evttyp, /* Bug 3258414 */
2663: pa_tasks tsk
2664: WHERE tsk.task_id = evt.task_id
2665: AND tsk.top_task_id = rt.task_id
2666: AND rt.customer_id = ProjCustRec.customer_id
2667: AND rt.project_id = p_project_id