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_EXPENDITURE_ITEMS_ALL

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 1821: pa_expenditure_items_all ei,

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
1825: -- AND rt.expenditure_type = ei.expenditure_type

Line 1839: pa_expenditure_items_all ei,

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
1843: -- AND rt.expenditure_type = ei.expenditure_type

Line 1865: pa_expenditure_items_all ei

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'
1869: AND rdl.expenditure_item_id = ei.expenditure_item_id

Line 1879: pa_expenditure_items_all ei

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'
1883: AND rdl.expenditure_item_id = ei.expenditure_item_id

Line 2202: pa_expenditure_items_all ei,

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
2206: AND rt.customer_id = ProjCustRec.customer_id

Line 2220: pa_expenditure_items_all ei,

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
2224: AND rt.customer_id = ProjCustRec.customer_id

Line 2244: pa_expenditure_items_all ei,

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
2248: AND rt.customer_id = ProjCustRec.customer_id

Line 2263: pa_expenditure_items_all ei,

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
2267: AND rt.customer_id = ProjCustRec.customer_id

Line 2288: pa_expenditure_items_all ei,

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
2292: AND tsk.top_task_id = rt.task_id

Line 2310: pa_expenditure_items_all ei,

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
2314: AND tsk.top_task_id = rt.task_id

Line 2337: pa_expenditure_items_all ei,

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
2341: AND rt.customer_id = ProjCustRec.customer_id

Line 2354: pa_expenditure_items_all ei,

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
2358: AND rt.customer_id = ProjCustRec.customer_id