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

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

Line 1820: pa_expenditure_items_all ei,

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

Line 1846: pa_expenditure_items_all ei

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

Line 1860: pa_expenditure_items_all ei

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

Line 2183: pa_expenditure_items_all ei,

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

Line 2201: pa_expenditure_items_all ei,

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

Line 2225: pa_expenditure_items_all ei,

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

Line 2244: pa_expenditure_items_all ei,

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

Line 2269: pa_expenditure_items_all ei,

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

Line 2291: pa_expenditure_items_all ei,

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

Line 2318: pa_expenditure_items_all ei,

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

Line 2335: pa_expenditure_items_all ei,

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