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 1822: pa_expenditure_types et

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

Line 1840: pa_expenditure_types et

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

Line 2289: pa_expenditure_types et,

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

Line 2311: pa_expenditure_types et,

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