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_EVENTS

Line 1883: pa_events evt,

1879: rt.retention_rule_id,
1880: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1881: -1,rt.retention_rule_id,-99) )
1882: FROM pa_proj_retn_rules rt,
1883: pa_events evt,
1884: pa_event_types evttyp
1885: WHERE rt.customer_id = ProjCustRec.customer_id
1886: AND rt.project_id = p_project_id
1887: AND rt.retention_level_code='EVENT_TYPE'

Line 1903: pa_events evt,

1899: AND erdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1900: AND erdl.retention_rule_id IS NULL
1901: AND EXISTS(SELECT NULL
1902: FROM pa_proj_retn_rules rt,
1903: pa_events evt,
1904: pa_event_types evttyp
1905: WHERE rt.customer_id = ProjCustRec.customer_id
1906: AND rt.project_id = p_project_id
1907: AND rt.retention_level_code='EVENT_TYPE'

Line 1930: pa_events evt,

1926: rt.retention_rule_id,
1927: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),
1928: -1,rt.retention_rule_id,-99))
1929: FROM pa_proj_retn_rules rt,
1930: pa_events evt,
1931: pa_event_types evttyp
1932: WHERE rt.customer_id = ProjCustRec.customer_id
1933: AND rt.project_id = p_project_id
1934: AND rt.retention_level_code='REVENUE_CATEGORY'

Line 1949: pa_events evt,

1945: AND erdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1946: AND erdl.retention_rule_id IS NULL
1947: AND EXISTS (SELECT NULL
1948: FROM pa_proj_retn_rules rt,
1949: pa_events evt,
1950: pa_event_types evttyp
1951: WHERE rt.customer_id = ProjCustRec.customer_id
1952: AND rt.project_id = p_project_id
1953: AND rt.retention_level_code='REVENUE_CATEGORY'

Line 1975: pa_events evt

1971: rt.retention_rule_id,
1972: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1973: -1,rt.retention_rule_id,-99))
1974: FROM pa_proj_retn_rules rt,
1975: pa_events evt
1976: WHERE rt.customer_id = ProjCustRec.customer_id
1977: AND rt.project_id = p_project_id
1978: AND rt.retention_level_code='PROJECT'
1979: AND erdl.event_num = evt.event_num

Line 1991: pa_events evt

1987: AND erdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1988: AND erdl.retention_rule_id IS NULL
1989: AND EXISTS(SELECT NULL
1990: FROM pa_proj_retn_rules rt,
1991: pa_events evt
1992: WHERE rt.customer_id = ProjCustRec.customer_id
1993: AND rt.project_id = p_project_id
1994: AND rt.retention_level_code='PROJECT'
1995: AND erdl.event_num = evt.event_num

Line 2015: pa_events evt,

2011: rt.retention_rule_id,
2012: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2013: -1,rt.retention_rule_id,-99))
2014: FROM pa_proj_retn_rules rt,
2015: pa_events evt,
2016: pa_event_types evttyp
2017: WHERE rt.customer_id = ProjCustRec.customer_id
2018: AND rt.project_id = p_project_id
2019: AND rt.retention_level_code='EVENT_TYPE'

Line 2039: pa_events evt,

2035: AND dii.event_num IS NOT NULL
2036: AND dii.retention_rule_id IS NULL
2037: AND EXISTS( SELECT NULL
2038: FROM pa_proj_retn_rules rt,
2039: pa_events evt,
2040: pa_event_types evttyp
2041: WHERE rt.customer_id = ProjCustRec.customer_id
2042: AND rt.project_id = p_project_id
2043: AND rt.retention_level_code='EVENT_TYPE'

Line 2070: pa_events evt,

2066: rt.retention_rule_id,
2067: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2068: -1,rt.retention_rule_id,-99))
2069: FROM pa_proj_retn_rules rt,
2070: pa_events evt,
2071: pa_event_types evttyp
2072: WHERE rt.customer_id = ProjCustRec.customer_id
2073: AND rt.project_id = p_project_id
2074: AND rt.retention_level_code='REVENUE_CATEGORY'

Line 2093: pa_events evt,

2089: AND dii.event_num IS NOT NULL
2090: AND dii.retention_rule_id IS NULL
2091: AND exists (SELECT NULL
2092: FROM pa_proj_retn_rules rt,
2093: pa_events evt,
2094: pa_event_types evttyp
2095: WHERE rt.customer_id = ProjCustRec.customer_id
2096: AND rt.project_id = p_project_id
2097: AND rt.retention_level_code='REVENUE_CATEGORY'

Line 2126: pa_events evt ,

2122: rt.retention_rule_id,
2123: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2124: -1,rt.retention_rule_id,-99))
2125: FROM pa_proj_retn_rules rt,
2126: pa_events evt ,
2127: pa_event_types evttyp /* Bug 3258414 */
2128: WHERE rt.customer_id = ProjCustRec.customer_id
2129: AND rt.project_id = p_project_id
2130: AND rt.retention_level_code='PROJECT'

Line 2148: pa_events evt,

2144: AND dii.event_num IS NOT NULL
2145: AND dii.retention_rule_id IS NULL
2146: AND EXISTS(SELECT NULL
2147: FROM pa_proj_retn_rules rt,
2148: pa_events evt,
2149: pa_event_types evttyp /* Bug 3258414 */
2150: WHERE rt.customer_id = ProjCustRec.customer_id
2151: AND rt.project_id = p_project_id
2152: AND rt.retention_level_code='PROJECT'

Line 2360: pa_events evt,

2356: rt.retention_rule_id,
2357: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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

Line 2384: pa_events evt,

2380: AND erdl.retention_rule_id IS NULL
2381: AND EXISTS
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

Line 2415: pa_events evt,

2411: rt.retention_rule_id,
2412: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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

Line 2437: pa_events evt,

2433: AND erdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2434: AND erdl.retention_rule_id IS NULL
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

Line 2468: pa_events evt,

2464: rt.retention_rule_id,
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

Line 2487: pa_events evt,

2483: AND erdl.draft_invoice_num = ProjInvRec.draft_invoice_num
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

Line 2515: pa_events evt,

2511: rt.retention_rule_id,
2512: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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

Line 2542: pa_events evt,

2538: AND dii.event_num IS NOT NULL
2539: AND dii.retention_rule_id IS NULL
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

Line 2576: pa_events evt,

2572: rt.retention_rule_id,
2573: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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

Line 2602: pa_events evt,

2598: AND dii.event_num IS NOT NULL
2599: AND dii.retention_rule_id IS NULL
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

Line 2636: pa_events evt,

2632: rt.retention_rule_id,
2633: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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

Line 2661: pa_events evt,

2657: AND dii.event_num IS NOT NULL
2658: AND dii.retention_rule_id IS NULL
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