DBA Data[Home] [Help]

APPS.PA_RETENTION_PKG dependencies on PA_EVENTS

Line 1902: pa_events evt,

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

Line 1922: pa_events evt,

1918: AND erdl.draft_invoice_num = ProjInvRec.draft_invoice_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'

Line 1949: pa_events evt,

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

Line 1968: pa_events evt,

1964: AND erdl.draft_invoice_num = ProjInvRec.draft_invoice_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'

Line 1994: pa_events evt

1990: rt.retention_rule_id,
1991: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1992: -1,rt.retention_rule_id,-99))
1993: FROM pa_proj_retn_rules rt,
1994: pa_events evt
1995: WHERE rt.customer_id = ProjCustRec.customer_id
1996: AND rt.project_id = p_project_id
1997: AND rt.retention_level_code='PROJECT'
1998: AND erdl.event_num = evt.event_num

Line 2010: pa_events evt

2006: AND erdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2007: AND erdl.retention_rule_id IS NULL
2008: AND EXISTS(SELECT NULL
2009: FROM pa_proj_retn_rules rt,
2010: pa_events evt
2011: WHERE rt.customer_id = ProjCustRec.customer_id
2012: AND rt.project_id = p_project_id
2013: AND rt.retention_level_code='PROJECT'
2014: AND erdl.event_num = evt.event_num

Line 2034: pa_events evt,

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

Line 2058: pa_events evt,

2054: AND dii.event_num IS NOT NULL
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'

Line 2089: pa_events evt,

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

Line 2112: pa_events evt,

2108: AND dii.event_num IS NOT NULL
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'

Line 2145: pa_events evt ,

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

Line 2167: pa_events evt,

2163: AND dii.event_num IS NOT NULL
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'

Line 2379: pa_events evt,

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

Line 2403: pa_events evt,

2399: AND erdl.retention_rule_id IS NULL
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

Line 2434: pa_events evt,

2430: rt.retention_rule_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

Line 2456: pa_events evt,

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

Line 2487: pa_events evt,

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

Line 2506: pa_events evt,

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

Line 2534: pa_events evt,

2530: rt.retention_rule_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

Line 2561: pa_events evt,

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

Line 2595: pa_events evt,

2591: rt.retention_rule_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

Line 2621: pa_events evt,

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

Line 2655: pa_events evt,

2651: rt.retention_rule_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

Line 2680: pa_events evt,

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