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_TYPES

Line 1803: pa_expenditure_types et

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
1807: AND ei.expenditure_type = et.expenditure_type

Line 1821: pa_expenditure_types et

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

Line 2270: pa_expenditure_types et,

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

Line 2292: pa_expenditure_types et,

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