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_PROJ_RETN_RULES

Line 129: -- Update the pa_project_retentions, pa_proj_retn_rules, pa_summary_project_retn

125:
126: END Get_Proj_Inv_Retn_Format;
127:
128: -- Procedure to Update the retention balances
129: -- Update the pa_project_retentions, pa_proj_retn_rules, pa_summary_project_retn
130:
131: /*PROCEDURE Update_Retention_Balances( p_retention_rule_id IN NUMBER DEFAULT NULL, bug 2681003,
132: removed the default values to ensure GSCC complaince */
133: PROCEDURE Update_Retention_Balances( p_retention_rule_id IN NUMBER ,

Line 387: UPDATE pa_proj_retn_rules

383: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
384: END IF;
385:
386:
387: UPDATE pa_proj_retn_rules
388: SET total_retained = NVL(total_retained,0) +
389: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
390: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
391: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0), p_projfunc_currency),

Line 640: PA_PROJ_RETN_RULES RT

636: AND dii.request_id = p_request_id
637: AND dii.draft_invoice_num = p_draft_invoice_num
638: AND dii.event_num IS NOT NULL
639: GROUP BY dii.retention_rule_id ) AMT,
640: PA_PROJ_RETN_RULES RT
641: where amt.retention_rule_id = RT.retention_rule_id
642: ORDER BY RT.task_id, RT.expenditure_category, RT.expenditure_type, RT.NON_LABOR_RESOURCE,
643: RT.REVENUE_CATEGORY_CODE, RT.EVENT_TYPE, RT.EFFECTIVE_START_DATE, RT.EFFECTIVE_END_DATE;
644:

Line 664: FROM pa_proj_retn_rules rt, pa_tasks tsk

660: rt.effective_end_date effective_end_date ,
661: tsk.task_number task_number,
662: tsk.task_name task_name,
663: rt.task_id task_id
664: FROM pa_proj_retn_rules rt, pa_tasks tsk
665: WHERE rt.retention_rule_id = RetentionRuleID
666: AND rt.task_id = tsk.task_id(+);
667:
668: retn_rule_rec cur_retn_rule%ROWTYPE;

Line 1578: pa_agreements_all agr, pa_proj_retn_rules rt

1574: hz_cust_site_uses hz_site,
1575: hz_cust_site_uses hz_site1
1576: WHERE EXISTS (SELECT NULL
1577: FROM pa_draft_invoices_all di,
1578: pa_agreements_all agr, pa_proj_retn_rules rt
1579: WHERE di.project_id = p_project_id
1580: AND di.request_id = p_request_id
1581: AND di.agreement_id = agr.agreement_id
1582: AND agr.customer_id = pc.customer_id

Line 1731: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei

1727: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1728: rt.retention_rule_id,
1729: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1730: -1,rt.retention_rule_id,-99))
1731: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei
1732: WHERE rt.customer_id = ProjCustRec.customer_id
1733: AND rt.project_id = p_project_id
1734: AND rt.retention_level_code='NON_LABOR'
1735: AND rdl.expenditure_item_id = ei.expenditure_item_id

Line 1743: AND exists (select null FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei

1739: rt.effective_start_date and NVL(rt.effective_end_date,ei.expenditure_item_date+1))
1740: WHERE rdl.project_id = p_project_id
1741: AND rdl.request_id = p_request_id
1742: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1743: AND exists (select null FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei
1744: WHERE rt.customer_id = ProjCustRec.customer_id
1745: AND rt.project_id = p_project_id
1746: AND rt.retention_level_code='NON_LABOR'
1747: AND rdl.expenditure_item_id = ei.expenditure_item_id

Line 1766: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei

1762: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1763: rt.retention_rule_id,
1764: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1765: -1,rt.retention_rule_id,-99))
1766: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei
1767: WHERE rt.customer_id = ProjCustRec.customer_id
1768: AND rt.project_id = p_project_id
1769: AND rt.expenditure_type = ei.expenditure_type
1770: AND rt.retention_level_code='EXPENDITURE_TYPE'

Line 1780: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei

1776: AND rdl.request_id = p_request_id
1777: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1778: AND rdl.retention_rule_id IS NULL
1779: AND EXISTS( select null
1780: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei
1781: WHERE rt.customer_id = ProjCustRec.customer_id
1782: AND rt.project_id = p_project_id
1783: AND rt.expenditure_type = ei.expenditure_type
1784: AND rt.retention_level_code='EXPENDITURE_TYPE'

Line 1801: FROM pa_proj_retn_rules rt,

1797: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1798: rt.retention_rule_id,
1799: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1800: -1,rt.retention_rule_id,-99) )
1801: FROM pa_proj_retn_rules rt,
1802: pa_expenditure_items_all ei,
1803: pa_expenditure_types et
1804: WHERE rt.customer_id = ProjCustRec.customer_id
1805: AND rt.project_id = p_project_id

Line 1819: FROM pa_proj_retn_rules rt,

1815: AND rdl.request_id = p_request_id
1816: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1817: AND rdl.retention_rule_id IS NULL
1818: AND EXISTS (SELECT NULL
1819: FROM pa_proj_retn_rules rt,
1820: pa_expenditure_items_all ei,
1821: pa_expenditure_types et
1822: WHERE rt.customer_id = ProjCustRec.customer_id
1823: AND rt.project_id = p_project_id

Line 1845: FROM pa_proj_retn_rules rt,

1841: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1842: rt.retention_rule_id,
1843: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1844: -1,rt.retention_rule_id,-99))
1845: FROM pa_proj_retn_rules rt,
1846: pa_expenditure_items_all ei
1847: WHERE rt.customer_id = ProjCustRec.customer_id
1848: AND rt.project_id = p_project_id
1849: AND rt.retention_level_code='PROJECT'

Line 1859: FROM pa_proj_retn_rules rt,

1855: AND rdl.request_id = p_request_id
1856: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1857: AND rdl.retention_rule_id IS NULL
1858: AND EXISTS( SELECT NULL
1859: FROM pa_proj_retn_rules rt,
1860: pa_expenditure_items_all ei
1861: WHERE rt.customer_id = ProjCustRec.customer_id
1862: AND rt.project_id = p_project_id
1863: AND rt.retention_level_code='PROJECT'

Line 1882: FROM pa_proj_retn_rules rt,

1878: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 1902: FROM pa_proj_retn_rules rt,

1898: AND erdl.request_id = p_request_id
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

Line 1929: FROM pa_proj_retn_rules rt,

1925: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 1948: FROM pa_proj_retn_rules rt,

1944: AND erdl.request_id = p_request_id
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

Line 1974: FROM pa_proj_retn_rules rt,

1970: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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'

Line 1990: FROM pa_proj_retn_rules rt,

1986: AND erdl.request_id = p_request_id
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'

Line 2014: FROM pa_proj_retn_rules rt,

2010: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 2038: FROM pa_proj_retn_rules rt,

2034: AND dii.draft_invoice_num = ProjInvRec.draft_invoice_num
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

Line 2069: FROM pa_proj_retn_rules rt,

2065: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 2092: FROM pa_proj_retn_rules rt,

2088: AND dii.draft_invoice_num = ProjInvRec.draft_invoice_num
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

Line 2125: FROM pa_proj_retn_rules rt,

2121: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 2147: FROM pa_proj_retn_rules rt,

2143: AND dii.draft_invoice_num = ProjInvRec.draft_invoice_num
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

Line 2182: FROM pa_proj_retn_rules rt,

2178: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2179: rt.retention_rule_id,
2180: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2181: -1,rt.retention_rule_id,-99))
2182: FROM pa_proj_retn_rules rt,
2183: pa_expenditure_items_all ei,
2184: pa_tasks tsk
2185: WHERE tsk.task_id = ei.task_id
2186: AND tsk.top_task_id = rt.task_id

Line 2200: FROM pa_proj_retn_rules rt,

2196: AND rdl.request_id = p_request_id
2197: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2198: AND EXISTS(
2199: SELECT NULL
2200: FROM pa_proj_retn_rules rt,
2201: pa_expenditure_items_all ei,
2202: pa_tasks tsk
2203: WHERE tsk.task_id = ei.task_id
2204: AND tsk.top_task_id = rt.task_id

Line 2224: FROM pa_proj_retn_rules rt,

2220: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2221: rt.retention_rule_id,
2222: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2223: -1,rt.retention_rule_id,-99))
2224: FROM pa_proj_retn_rules rt,
2225: pa_expenditure_items_all ei,
2226: pa_tasks tsk
2227: WHERE tsk.task_id = ei.task_id
2228: AND tsk.top_task_id = rt.task_id

Line 2243: FROM pa_proj_retn_rules rt,

2239: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2240: AND rdl.retention_rule_id IS NULL
2241: AND EXISTS(
2242: SELECT NULL
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

Line 2268: FROM pa_proj_retn_rules rt,

2264: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2265: rt.retention_rule_id,
2266: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2267: -1,rt.retention_rule_id,-99))
2268: FROM pa_proj_retn_rules rt,
2269: pa_expenditure_items_all ei,
2270: pa_expenditure_types et,
2271: pa_tasks tsk
2272: WHERE tsk.task_id = ei.task_id

Line 2290: FROM pa_proj_retn_rules rt,

2286: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2287: AND rdl.retention_rule_id IS NULL
2288: AND EXISTS(
2289: SELECT NULL
2290: FROM pa_proj_retn_rules rt,
2291: pa_expenditure_items_all ei,
2292: pa_expenditure_types et,
2293: pa_tasks tsk
2294: WHERE tsk.task_id = ei.task_id

Line 2317: FROM pa_proj_retn_rules rt,

2313: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2314: rt.retention_rule_id,
2315: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),
2316: -1,rt.retention_rule_id,-99))
2317: FROM pa_proj_retn_rules rt,
2318: pa_expenditure_items_all ei,
2319: pa_tasks tsk
2320: WHERE tsk.task_id = ei.task_id
2321: AND tsk.top_task_id = rt.task_id

Line 2334: FROM pa_proj_retn_rules rt,

2330: AND rdl.request_id = p_request_id
2331: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2332: AND rdl.retention_rule_id IS NULL
2333: AND EXISTS(SELECT NULL
2334: FROM pa_proj_retn_rules rt,
2335: pa_expenditure_items_all ei,
2336: pa_tasks tsk
2337: WHERE tsk.task_id = ei.task_id
2338: AND tsk.top_task_id = rt.task_id

Line 2359: FROM pa_proj_retn_rules rt,

2355: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 2383: FROM pa_proj_retn_rules rt,

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

Line 2414: FROM pa_proj_retn_rules rt,

2410: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 2436: FROM pa_proj_retn_rules rt,

2432: AND erdl.request_id = p_request_id
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

Line 2467: FROM pa_proj_retn_rules rt,

2463: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 2486: FROM pa_proj_retn_rules rt,

2482: AND erdl.request_id = p_request_id
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

Line 2514: FROM pa_proj_retn_rules rt,

2510: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 2541: FROM pa_proj_retn_rules rt,

2537: AND dii.draft_invoice_num = ProjInvRec.draft_invoice_num
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

Line 2575: FROM pa_proj_retn_rules rt,

2571: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 2601: FROM pa_proj_retn_rules rt,

2597: AND dii.draft_invoice_num = ProjInvRec.draft_invoice_num
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

Line 2635: FROM pa_proj_retn_rules rt,

2631: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
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

Line 2660: (SELECT NULL FROM pa_proj_retn_rules rt,

2656: AND dii.draft_invoice_num = ProjInvRec.draft_invoice_num
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

Line 2927: pa_proj_retn_rules rtn

2923: rtn.task_id rtn_task_id,
2924: dii.line_num line_num_credited
2925: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2926: pa_agreements_all agr,
2927: pa_proj_retn_rules rtn
2928: WHERE dii.project_id = p_project_id
2929: AND dii.draft_invoice_num = l_org_invoice_num
2930: AND dii.project_id = di.project_id
2931: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3336: pa_proj_retn_rules rtn

3332: nvl(rtn.task_id, dii.task_id) rtn_task_id,
3333: dii.inv_amount inv_amount
3334: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3335: pa_agreements_all agr,
3336: pa_proj_retn_rules rtn
3337: WHERE di.project_id = p_project_id
3338: AND di.draft_invoice_num = p_draft_invoice_num
3339: AND di.agreement_id = agr.agreement_id
3340: AND di.project_id = dii.project_id

Line 3460: pa_proj_retn_rules rtn

3456: rtn.task_id rtn_task_id
3457: FROM pa_draft_invoice_items dii,
3458: pa_draft_invoices_all di,
3459: pa_agreements_all agr,
3460: pa_proj_retn_rules rtn
3461: WHERE di.project_id = p_project_id
3462: AND di.draft_invoice_num = p_draft_invoice_num
3463: AND di.agreement_id = agr.agreement_id
3464: AND di.project_id = dii.project_id

Line 3543: pa_proj_retn_rules rtn

3539: NVL(rtn.task_id,dii.task_id) rtn_task_id
3540: FROM pa_draft_invoice_items dii,
3541: pa_draft_invoices_all di,
3542: pa_agreements_all agr,
3543: pa_proj_retn_rules rtn
3544: WHERE di.project_id = p_project_id
3545: AND di.draft_invoice_num = p_draft_invoice_num
3546: AND di.agreement_id = agr.agreement_id
3547: AND di.project_id = dii.project_id

Line 3650: pa_proj_retn_rules rtn

3646: rtn.task_id rtn_task_id
3647: FROM pa_draft_invoice_items dii,
3648: pa_draft_invoices_all di,
3649: pa_agreements_all agr,
3650: pa_proj_retn_rules rtn
3651: WHERE di.project_id = p_project_id
3652: AND di.draft_invoice_num = p_draft_invoice_num
3653: AND di.agreement_id = agr.agreement_id
3654: AND di.project_id = dii.project_id

Line 3748: Delete From PA_Proj_Retn_Rules -- PA_Project_Retentions

3744: -- Dbms_Output.Put_Line('Flag value 1 : '|| l_Cust_Top_Task_Flag);
3745: -- Dbms_Output.Put_Line('Flag value 2 : '|| l_Inv_Method_Top_Task_Flag);
3746:
3747: If l_Cust_Top_Task_Flag = 'Y' OR l_Inv_Method_Top_Task_Flag = 'Y' Then
3748: Delete From PA_Proj_Retn_Rules -- PA_Project_Retentions
3749: Where Project_ID = P_Project_ID
3750: And Task_ID = P_Task_ID;
3751: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3752: End If;