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 147: -- Update the pa_project_retentions, pa_proj_retn_rules, pa_summary_project_retn

143:
144: END Get_Proj_Inv_Retn_Format;
145:
146: -- Procedure to Update the retention balances
147: -- Update the pa_project_retentions, pa_proj_retn_rules, pa_summary_project_retn
148:
149: /*PROCEDURE Update_Retention_Balances( p_retention_rule_id IN NUMBER DEFAULT NULL, bug 2681003,
150: removed the default values to ensure GSCC complaince */
151: PROCEDURE Update_Retention_Balances( p_retention_rule_id IN NUMBER ,

Line 405: UPDATE pa_proj_retn_rules

401: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
402: END IF;
403:
404:
405: UPDATE pa_proj_retn_rules
406: SET total_retained = NVL(total_retained,0) +
407: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
408: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
409: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0), p_projfunc_currency),

Line 658: PA_PROJ_RETN_RULES RT

654: AND dii.request_id = p_request_id
655: AND dii.draft_invoice_num = p_draft_invoice_num
656: AND dii.event_num IS NOT NULL
657: GROUP BY dii.retention_rule_id ) AMT,
658: PA_PROJ_RETN_RULES RT
659: where amt.retention_rule_id = RT.retention_rule_id
660: ORDER BY RT.task_id, RT.expenditure_category, RT.expenditure_type, RT.NON_LABOR_RESOURCE,
661: RT.REVENUE_CATEGORY_CODE, RT.EVENT_TYPE, RT.EFFECTIVE_START_DATE, RT.EFFECTIVE_END_DATE;
662:

Line 682: FROM pa_proj_retn_rules rt, pa_tasks tsk

678: rt.effective_end_date effective_end_date ,
679: tsk.task_number task_number,
680: tsk.task_name task_name,
681: rt.task_id task_id
682: FROM pa_proj_retn_rules rt, pa_tasks tsk
683: WHERE rt.retention_rule_id = RetentionRuleID
684: AND rt.task_id = tsk.task_id(+);
685:
686: retn_rule_rec cur_retn_rule%ROWTYPE;

Line 1596: pa_agreements_all agr, pa_proj_retn_rules rt

1592: hz_cust_site_uses hz_site,
1593: hz_cust_site_uses hz_site1
1594: WHERE EXISTS (SELECT NULL
1595: FROM pa_draft_invoices_all di,
1596: pa_agreements_all agr, pa_proj_retn_rules rt
1597: WHERE di.project_id = p_project_id
1598: AND di.request_id = p_request_id
1599: AND di.agreement_id = agr.agreement_id
1600: AND agr.customer_id = pc.customer_id

Line 1750: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei

1746: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1747: rt.retention_rule_id,
1748: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1749: -1,rt.retention_rule_id,-99))
1750: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei
1751: WHERE rt.customer_id = ProjCustRec.customer_id
1752: AND rt.project_id = p_project_id
1753: AND rt.retention_level_code='NON_LABOR'
1754: AND rdl.expenditure_item_id = ei.expenditure_item_id

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

1758: rt.effective_start_date and NVL(rt.effective_end_date,ei.expenditure_item_date+1))
1759: WHERE rdl.project_id = p_project_id
1760: AND rdl.request_id = p_request_id
1761: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1762: AND exists (select null FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei
1763: WHERE rt.customer_id = ProjCustRec.customer_id
1764: AND rt.project_id = p_project_id
1765: AND rt.retention_level_code='NON_LABOR'
1766: AND rdl.expenditure_item_id = ei.expenditure_item_id

Line 1785: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei

1781: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1782: rt.retention_rule_id,
1783: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1784: -1,rt.retention_rule_id,-99))
1785: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei
1786: WHERE rt.customer_id = ProjCustRec.customer_id
1787: AND rt.project_id = p_project_id
1788: AND rt.expenditure_type = ei.expenditure_type
1789: AND rt.retention_level_code='EXPENDITURE_TYPE'

Line 1799: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei

1795: AND rdl.request_id = p_request_id
1796: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1797: AND rdl.retention_rule_id IS NULL
1798: AND EXISTS( select null
1799: FROM pa_proj_retn_rules rt, pa_expenditure_items_all ei
1800: WHERE rt.customer_id = ProjCustRec.customer_id
1801: AND rt.project_id = p_project_id
1802: AND rt.expenditure_type = ei.expenditure_type
1803: AND rt.retention_level_code='EXPENDITURE_TYPE'

Line 1820: FROM pa_proj_retn_rules rt,

1816: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1817: rt.retention_rule_id,
1818: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1819: -1,rt.retention_rule_id,-99) )
1820: FROM pa_proj_retn_rules rt,
1821: pa_expenditure_items_all ei,
1822: pa_expenditure_types et
1823: WHERE rt.customer_id = ProjCustRec.customer_id
1824: AND rt.project_id = p_project_id

Line 1838: FROM pa_proj_retn_rules rt,

1834: AND rdl.request_id = p_request_id
1835: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1836: AND rdl.retention_rule_id IS NULL
1837: AND EXISTS (SELECT NULL
1838: FROM pa_proj_retn_rules rt,
1839: pa_expenditure_items_all ei,
1840: pa_expenditure_types et
1841: WHERE rt.customer_id = ProjCustRec.customer_id
1842: AND rt.project_id = p_project_id

Line 1864: FROM pa_proj_retn_rules rt,

1860: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1861: rt.retention_rule_id,
1862: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
1863: -1,rt.retention_rule_id,-99))
1864: FROM pa_proj_retn_rules rt,
1865: pa_expenditure_items_all ei
1866: WHERE rt.customer_id = ProjCustRec.customer_id
1867: AND rt.project_id = p_project_id
1868: AND rt.retention_level_code='PROJECT'

Line 1878: FROM pa_proj_retn_rules rt,

1874: AND rdl.request_id = p_request_id
1875: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
1876: AND rdl.retention_rule_id IS NULL
1877: AND EXISTS( SELECT NULL
1878: FROM pa_proj_retn_rules rt,
1879: pa_expenditure_items_all ei
1880: WHERE rt.customer_id = ProjCustRec.customer_id
1881: AND rt.project_id = p_project_id
1882: AND rt.retention_level_code='PROJECT'

Line 1901: FROM pa_proj_retn_rules rt,

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

Line 1921: FROM pa_proj_retn_rules rt,

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

Line 1948: FROM pa_proj_retn_rules rt,

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

Line 1967: FROM pa_proj_retn_rules rt,

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

Line 1993: FROM pa_proj_retn_rules rt,

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

Line 2009: FROM pa_proj_retn_rules rt,

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

Line 2033: FROM pa_proj_retn_rules rt,

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

Line 2057: FROM pa_proj_retn_rules rt,

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

Line 2088: FROM pa_proj_retn_rules rt,

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

Line 2111: FROM pa_proj_retn_rules rt,

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

Line 2144: FROM pa_proj_retn_rules rt,

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

Line 2166: FROM pa_proj_retn_rules rt,

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

Line 2201: FROM pa_proj_retn_rules rt,

2197: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2198: rt.retention_rule_id,
2199: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2200: -1,rt.retention_rule_id,-99))
2201: FROM pa_proj_retn_rules rt,
2202: pa_expenditure_items_all ei,
2203: pa_tasks tsk
2204: WHERE tsk.task_id = ei.task_id
2205: AND tsk.top_task_id = rt.task_id

Line 2219: FROM pa_proj_retn_rules rt,

2215: AND rdl.request_id = p_request_id
2216: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2217: AND EXISTS(
2218: SELECT NULL
2219: FROM pa_proj_retn_rules rt,
2220: pa_expenditure_items_all ei,
2221: pa_tasks tsk
2222: WHERE tsk.task_id = ei.task_id
2223: AND tsk.top_task_id = rt.task_id

Line 2243: FROM pa_proj_retn_rules rt,

2239: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2240: rt.retention_rule_id,
2241: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2242: -1,rt.retention_rule_id,-99))
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 2262: FROM pa_proj_retn_rules rt,

2258: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2259: AND rdl.retention_rule_id IS NULL
2260: AND EXISTS(
2261: SELECT NULL
2262: FROM pa_proj_retn_rules rt,
2263: pa_expenditure_items_all ei,
2264: pa_tasks tsk
2265: WHERE tsk.task_id = ei.task_id
2266: AND tsk.top_task_id = rt.task_id

Line 2287: FROM pa_proj_retn_rules rt,

2283: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2284: rt.retention_rule_id,
2285: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),
2286: -1,rt.retention_rule_id,-99))
2287: FROM pa_proj_retn_rules rt,
2288: pa_expenditure_items_all ei,
2289: pa_expenditure_types et,
2290: pa_tasks tsk
2291: WHERE tsk.task_id = ei.task_id

Line 2309: FROM pa_proj_retn_rules rt,

2305: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2306: AND rdl.retention_rule_id IS NULL
2307: AND EXISTS(
2308: SELECT NULL
2309: FROM pa_proj_retn_rules rt,
2310: pa_expenditure_items_all ei,
2311: pa_expenditure_types et,
2312: pa_tasks tsk
2313: WHERE tsk.task_id = ei.task_id

Line 2336: FROM pa_proj_retn_rules rt,

2332: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2333: rt.retention_rule_id,
2334: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),
2335: -1,rt.retention_rule_id,-99))
2336: FROM pa_proj_retn_rules rt,
2337: pa_expenditure_items_all ei,
2338: pa_tasks tsk
2339: WHERE tsk.task_id = ei.task_id
2340: AND tsk.top_task_id = rt.task_id

Line 2353: FROM pa_proj_retn_rules rt,

2349: AND rdl.request_id = p_request_id
2350: AND rdl.draft_invoice_num = ProjInvRec.draft_invoice_num
2351: AND rdl.retention_rule_id IS NULL
2352: AND EXISTS(SELECT NULL
2353: FROM pa_proj_retn_rules rt,
2354: pa_expenditure_items_all ei,
2355: pa_tasks tsk
2356: WHERE tsk.task_id = ei.task_id
2357: AND tsk.top_task_id = rt.task_id

Line 2378: FROM pa_proj_retn_rules rt,

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

Line 2402: FROM pa_proj_retn_rules rt,

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

Line 2433: FROM pa_proj_retn_rules rt,

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

Line 2455: FROM pa_proj_retn_rules rt,

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

Line 2486: FROM pa_proj_retn_rules rt,

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

Line 2505: FROM pa_proj_retn_rules rt,

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

Line 2533: FROM pa_proj_retn_rules rt,

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

Line 2560: FROM pa_proj_retn_rules rt,

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

Line 2594: FROM pa_proj_retn_rules rt,

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

Line 2620: FROM pa_proj_retn_rules rt,

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

Line 2654: FROM pa_proj_retn_rules rt,

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

Line 2679: (SELECT NULL FROM pa_proj_retn_rules rt,

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

Line 2964: pa_proj_retn_rules rtn

2960: rtn.task_id rtn_task_id,
2961: dii.line_num line_num_credited
2962: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2963: pa_agreements_all agr,
2964: pa_proj_retn_rules rtn
2965: WHERE dii.project_id = p_project_id
2966: AND dii.draft_invoice_num = l_org_invoice_num
2967: AND dii.project_id = di.project_id
2968: AND dii.draft_invoice_num = di.draft_invoice_num

Line 3373: pa_proj_retn_rules rtn

3369: nvl(rtn.task_id, dii.task_id) rtn_task_id,
3370: dii.inv_amount inv_amount
3371: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3372: pa_agreements_all agr,
3373: pa_proj_retn_rules rtn
3374: WHERE di.project_id = p_project_id
3375: AND di.draft_invoice_num = p_draft_invoice_num
3376: AND di.agreement_id = agr.agreement_id
3377: AND di.project_id = dii.project_id

Line 3497: pa_proj_retn_rules rtn

3493: rtn.task_id rtn_task_id
3494: FROM pa_draft_invoice_items dii,
3495: pa_draft_invoices_all di,
3496: pa_agreements_all agr,
3497: pa_proj_retn_rules rtn
3498: WHERE di.project_id = p_project_id
3499: AND di.draft_invoice_num = p_draft_invoice_num
3500: AND di.agreement_id = agr.agreement_id
3501: AND di.project_id = dii.project_id

Line 3580: pa_proj_retn_rules rtn

3576: NVL(rtn.task_id,dii.task_id) rtn_task_id
3577: FROM pa_draft_invoice_items dii,
3578: pa_draft_invoices_all di,
3579: pa_agreements_all agr,
3580: pa_proj_retn_rules rtn
3581: WHERE di.project_id = p_project_id
3582: AND di.draft_invoice_num = p_draft_invoice_num
3583: AND di.agreement_id = agr.agreement_id
3584: AND di.project_id = dii.project_id

Line 3687: pa_proj_retn_rules rtn

3683: rtn.task_id rtn_task_id
3684: FROM pa_draft_invoice_items dii,
3685: pa_draft_invoices_all di,
3686: pa_agreements_all agr,
3687: pa_proj_retn_rules rtn
3688: WHERE di.project_id = p_project_id
3689: AND di.draft_invoice_num = p_draft_invoice_num
3690: AND di.agreement_id = agr.agreement_id
3691: AND di.project_id = dii.project_id

Line 3785: Delete From PA_Proj_Retn_Rules -- PA_Project_Retentions

3781: -- Dbms_Output.Put_Line('Flag value 1 : '|| l_Cust_Top_Task_Flag);
3782: -- Dbms_Output.Put_Line('Flag value 2 : '|| l_Inv_Method_Top_Task_Flag);
3783:
3784: If l_Cust_Top_Task_Flag = 'Y' OR l_Inv_Method_Top_Task_Flag = 'Y' Then
3785: Delete From PA_Proj_Retn_Rules -- PA_Project_Retentions
3786: Where Project_ID = P_Project_ID
3787: And Task_ID = P_Task_ID;
3788: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3789: End If;