[Home] [Help]
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'
1888: AND erdl.event_num = evt.event_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'
1908: AND erdl.event_num = evt.event_num
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'
1935: AND erdl.event_num = evt.event_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'
1954: AND erdl.event_num = evt.event_num
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'
2020: AND dii.event_num = evt.event_num
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'
2044: AND dii.event_num = evt.event_num
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'
2075: AND dii.event_num = evt.event_num
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'
2098: AND dii.event_num = evt.event_num
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'
2131: AND dii.event_num = evt.event_num
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'
2153: AND dii.event_num = evt.event_num
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
2365: AND rt.customer_id = ProjCustRec.customer_id
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
2389: AND rt.customer_id = ProjCustRec.customer_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
2420: AND rt.customer_id = ProjCustRec.customer_id
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
2442: AND rt.customer_id = ProjCustRec.customer_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
2520: AND rt.customer_id = ProjCustRec.customer_id
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
2547: AND rt.customer_id = ProjCustRec.customer_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
2581: AND rt.customer_id = ProjCustRec.customer_id
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
2607: AND rt.customer_id = ProjCustRec.customer_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
2641: AND rt.customer_id = ProjCustRec.customer_id
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
2666: AND rt.customer_id = ProjCustRec.customer_id