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_RETENTION_PKG dependencies on PA_TASKS

Line 682: FROM pa_proj_retn_rules rt, pa_tasks tsk

678: rt.effective_end_date effective_end_date ,
679: tsk.task_number task_number,
680: tsk.task_name task_name,
681: rt.task_id task_id
682: FROM pa_proj_retn_rules rt, pa_tasks tsk
683: WHERE rt.retention_rule_id = RetentionRuleID
684: AND rt.task_id = tsk.task_id(+);
685:
686: retn_rule_rec cur_retn_rule%ROWTYPE;

Line 2203: pa_tasks tsk

2199: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2200: -1,rt.retention_rule_id,-99))
2201: FROM pa_proj_retn_rules rt,
2202: pa_expenditure_items_all ei,
2203: pa_tasks tsk
2204: WHERE tsk.task_id = ei.task_id
2205: AND tsk.top_task_id = rt.task_id
2206: AND rt.customer_id = ProjCustRec.customer_id
2207: AND rt.project_id = p_project_id

Line 2221: pa_tasks tsk

2217: AND EXISTS(
2218: SELECT NULL
2219: FROM pa_proj_retn_rules rt,
2220: pa_expenditure_items_all ei,
2221: pa_tasks tsk
2222: WHERE tsk.task_id = ei.task_id
2223: AND tsk.top_task_id = rt.task_id
2224: AND rt.customer_id = ProjCustRec.customer_id
2225: AND rt.project_id = p_project_id

Line 2245: pa_tasks tsk

2241: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2242: -1,rt.retention_rule_id,-99))
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 2264: pa_tasks tsk

2260: AND EXISTS(
2261: SELECT NULL
2262: FROM pa_proj_retn_rules rt,
2263: pa_expenditure_items_all ei,
2264: pa_tasks tsk
2265: WHERE tsk.task_id = ei.task_id
2266: AND tsk.top_task_id = rt.task_id
2267: AND rt.customer_id = ProjCustRec.customer_id
2268: AND rt.project_id = p_project_id

Line 2290: pa_tasks tsk

2286: -1,rt.retention_rule_id,-99))
2287: FROM pa_proj_retn_rules rt,
2288: pa_expenditure_items_all ei,
2289: pa_expenditure_types et,
2290: pa_tasks tsk
2291: WHERE tsk.task_id = ei.task_id
2292: AND tsk.top_task_id = rt.task_id
2293: AND rt.customer_id = ProjCustRec.customer_id
2294: AND rt.project_id = p_project_id

Line 2312: pa_tasks tsk

2308: SELECT NULL
2309: FROM pa_proj_retn_rules rt,
2310: pa_expenditure_items_all ei,
2311: pa_expenditure_types et,
2312: pa_tasks tsk
2313: WHERE tsk.task_id = ei.task_id
2314: AND tsk.top_task_id = rt.task_id
2315: AND rt.customer_id = ProjCustRec.customer_id
2316: AND rt.project_id = p_project_id

Line 2338: pa_tasks tsk

2334: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),
2335: -1,rt.retention_rule_id,-99))
2336: FROM pa_proj_retn_rules rt,
2337: pa_expenditure_items_all ei,
2338: pa_tasks tsk
2339: WHERE tsk.task_id = ei.task_id
2340: AND tsk.top_task_id = rt.task_id
2341: AND rt.customer_id = ProjCustRec.customer_id
2342: AND rt.project_id = p_project_id

Line 2355: pa_tasks tsk

2351: AND rdl.retention_rule_id IS NULL
2352: AND EXISTS(SELECT NULL
2353: FROM pa_proj_retn_rules rt,
2354: pa_expenditure_items_all ei,
2355: pa_tasks tsk
2356: WHERE tsk.task_id = ei.task_id
2357: AND tsk.top_task_id = rt.task_id
2358: AND rt.customer_id = ProjCustRec.customer_id
2359: AND rt.project_id = p_project_id

Line 2381: pa_tasks tsk

2377: -1,rt.retention_rule_id,-99))
2378: FROM pa_proj_retn_rules rt,
2379: pa_events evt,
2380: pa_event_types evttyp,
2381: pa_tasks tsk
2382: WHERE tsk.task_id = evt.task_id
2383: AND tsk.top_task_id = rt.task_id
2384: AND rt.customer_id = ProjCustRec.customer_id
2385: AND rt.project_id = p_project_id

Line 2405: pa_tasks tsk

2401: (SELECT NULL
2402: FROM pa_proj_retn_rules rt,
2403: pa_events evt,
2404: pa_event_types evttyp,
2405: pa_tasks tsk
2406: WHERE tsk.task_id = evt.task_id
2407: AND tsk.top_task_id = rt.task_id
2408: AND rt.customer_id = ProjCustRec.customer_id
2409: AND rt.project_id = p_project_id

Line 2436: pa_tasks tsk

2432: -1,rt.retention_rule_id,-99))
2433: FROM pa_proj_retn_rules rt,
2434: pa_events evt,
2435: pa_event_types evttyp,
2436: pa_tasks tsk
2437: WHERE tsk.task_id = evt.task_id
2438: AND tsk.top_task_id = rt.task_id
2439: AND rt.customer_id = ProjCustRec.customer_id
2440: AND rt.project_id = p_project_id

Line 2458: pa_tasks tsk

2454: AND EXISTS (SELECT NULL
2455: FROM pa_proj_retn_rules rt,
2456: pa_events evt,
2457: pa_event_types evttyp,
2458: pa_tasks tsk
2459: WHERE tsk.task_id = evt.task_id
2460: AND tsk.top_task_id = rt.task_id
2461: AND rt.customer_id = ProjCustRec.customer_id
2462: AND rt.project_id = p_project_id

Line 2488: pa_tasks tsk

2484: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2485: -1,rt.retention_rule_id,-99))
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 2507: pa_tasks tsk

2503: AND erdl.retention_rule_id IS NULL
2504: AND EXISTS( SELECT NULL
2505: FROM pa_proj_retn_rules rt,
2506: pa_events evt,
2507: pa_tasks tsk
2508: WHERE tsk.task_id = evt.task_id
2509: AND tsk.top_task_id = rt.task_id
2510: AND rt.customer_id = ProjCustRec.customer_id
2511: AND rt.project_id = p_project_id

Line 2536: pa_tasks tsk

2532: -1,rt.retention_rule_id,-99))
2533: FROM pa_proj_retn_rules rt,
2534: pa_events evt,
2535: pa_event_types evttyp,
2536: pa_tasks tsk
2537: WHERE tsk.task_id = evt.task_id
2538: AND tsk.top_task_id = rt.task_id
2539: AND rt.customer_id = ProjCustRec.customer_id
2540: AND rt.project_id = p_project_id

Line 2563: pa_tasks tsk

2559: AND EXISTS( SELECT NULL
2560: FROM pa_proj_retn_rules rt,
2561: pa_events evt,
2562: pa_event_types evttyp,
2563: pa_tasks tsk
2564: WHERE tsk.task_id = evt.task_id
2565: AND tsk.top_task_id = rt.task_id
2566: AND rt.customer_id = ProjCustRec.customer_id
2567: AND rt.project_id = p_project_id

Line 2597: pa_tasks tsk

2593: -1,rt.retention_rule_id,-99))
2594: FROM pa_proj_retn_rules rt,
2595: pa_events evt,
2596: pa_event_types evttyp,
2597: pa_tasks tsk
2598: WHERE tsk.task_id = evt.task_id
2599: AND tsk.top_task_id = rt.task_id
2600: AND rt.customer_id = ProjCustRec.customer_id
2601: AND rt.project_id = p_project_id

Line 2623: pa_tasks tsk

2619: AND EXISTS( SELECT NULL
2620: FROM pa_proj_retn_rules rt,
2621: pa_events evt,
2622: pa_event_types evttyp,
2623: pa_tasks tsk
2624: WHERE tsk.task_id = evt.task_id
2625: AND tsk.top_task_id = rt.task_id
2626: AND rt.customer_id = ProjCustRec.customer_id
2627: AND rt.project_id = p_project_id

Line 2657: pa_tasks tsk

2653: -1,rt.retention_rule_id,-99))
2654: FROM pa_proj_retn_rules rt,
2655: pa_events evt,
2656: pa_event_types evttyp, /* Bug 3258414 */
2657: pa_tasks tsk
2658: WHERE tsk.task_id = evt.task_id
2659: AND tsk.top_task_id = rt.task_id
2660: AND rt.customer_id = ProjCustRec.customer_id
2661: AND rt.project_id = p_project_id

Line 2682: pa_tasks tsk

2678: AND EXISTS
2679: (SELECT NULL FROM pa_proj_retn_rules rt,
2680: pa_events evt,
2681: pa_event_types evttyp, /* Bug 3258414 */
2682: pa_tasks tsk
2683: WHERE tsk.task_id = evt.task_id
2684: AND tsk.top_task_id = rt.task_id
2685: AND rt.customer_id = ProjCustRec.customer_id
2686: AND rt.project_id = p_project_id