[Home] [Help]
1899: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1900: -1,rt.retention_rule_id,-99) )
1901: FROM pa_proj_retn_rules rt,
1902: pa_events evt,
1903: pa_event_types evttyp
1904: WHERE rt.customer_id = ProjCustRec.customer_id
1905: AND rt.project_id = p_project_id
1906: AND rt.retention_level_code='EVENT_TYPE'
1907: AND erdl.event_num = evt.event_num
1919: AND erdl.retention_rule_id IS NULL
1920: AND EXISTS(SELECT NULL
1921: FROM pa_proj_retn_rules rt,
1922: pa_events evt,
1923: pa_event_types evttyp
1924: WHERE rt.customer_id = ProjCustRec.customer_id
1925: AND rt.project_id = p_project_id
1926: AND rt.retention_level_code='EVENT_TYPE'
1927: AND erdl.event_num = evt.event_num
1946: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),
1947: -1,rt.retention_rule_id,-99))
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
1965: AND erdl.retention_rule_id IS NULL
1966: AND EXISTS (SELECT NULL
1967: FROM pa_proj_retn_rules rt,
1968: pa_events evt,
1969: pa_event_types evttyp
1970: WHERE rt.customer_id = ProjCustRec.customer_id
1971: AND rt.project_id = p_project_id
1972: AND rt.retention_level_code='REVENUE_CATEGORY'
1973: AND erdl.event_num = evt.event_num
2031: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2032: -1,rt.retention_rule_id,-99))
2033: FROM pa_proj_retn_rules rt,
2034: pa_events evt,
2035: pa_event_types evttyp
2036: WHERE rt.customer_id = ProjCustRec.customer_id
2037: AND rt.project_id = p_project_id
2038: AND rt.retention_level_code='EVENT_TYPE'
2039: AND dii.event_num = evt.event_num
2055: AND dii.retention_rule_id IS NULL
2056: AND EXISTS( SELECT NULL
2057: FROM pa_proj_retn_rules rt,
2058: pa_events evt,
2059: pa_event_types evttyp
2060: WHERE rt.customer_id = ProjCustRec.customer_id
2061: AND rt.project_id = p_project_id
2062: AND rt.retention_level_code='EVENT_TYPE'
2063: AND dii.event_num = evt.event_num
2086: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2087: -1,rt.retention_rule_id,-99))
2088: FROM pa_proj_retn_rules rt,
2089: pa_events evt,
2090: pa_event_types evttyp
2091: WHERE rt.customer_id = ProjCustRec.customer_id
2092: AND rt.project_id = p_project_id
2093: AND rt.retention_level_code='REVENUE_CATEGORY'
2094: AND dii.event_num = evt.event_num
2109: AND dii.retention_rule_id IS NULL
2110: AND exists (SELECT NULL
2111: FROM pa_proj_retn_rules rt,
2112: pa_events evt,
2113: pa_event_types evttyp
2114: WHERE rt.customer_id = ProjCustRec.customer_id
2115: AND rt.project_id = p_project_id
2116: AND rt.retention_level_code='REVENUE_CATEGORY'
2117: AND dii.event_num = evt.event_num
2142: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2143: -1,rt.retention_rule_id,-99))
2144: FROM pa_proj_retn_rules rt,
2145: pa_events evt ,
2146: pa_event_types evttyp /* Bug 3258414 */
2147: WHERE rt.customer_id = ProjCustRec.customer_id
2148: AND rt.project_id = p_project_id
2149: AND rt.retention_level_code='PROJECT'
2150: AND dii.event_num = evt.event_num
2164: AND dii.retention_rule_id IS NULL
2165: AND EXISTS(SELECT NULL
2166: FROM pa_proj_retn_rules rt,
2167: pa_events evt,
2168: pa_event_types evttyp /* Bug 3258414 */
2169: WHERE rt.customer_id = ProjCustRec.customer_id
2170: AND rt.project_id = p_project_id
2171: AND rt.retention_level_code='PROJECT'
2172: AND dii.event_num = evt.event_num
2376: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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
2400: AND EXISTS
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
2431: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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
2453: AND erdl.retention_rule_id IS NULL
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
2531: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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
2558: AND dii.retention_rule_id IS NULL
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
2592: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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
2618: AND dii.retention_rule_id IS NULL
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
2652: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
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
2677: AND dii.retention_rule_id IS NULL
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