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_BILLING_CORE dependencies on PA_TASKS

Line 113: pa_tasks t,

109: cursor budget_task is
110: SELECT t.top_task_id , sum(l.revenue) revenue
111: FROM pa_budget_lines l,
112: pa_resource_assignments a,
113: pa_tasks t,
114: pa_budget_versions v
115: WHERE v.project_id = x_project_id
116: AND (v.budget_type_code = 'AR'
117: OR v.approved_rev_plan_type_flag ='Y')

Line 1356: FROM pa_tasks t2, pa_tasks t, pa_project_fundings f

1352: f.attribute9 attribute9,
1353: f.attribute10 attribute10,
1354: l_funding_currency_code funding_currency_code,
1355: f.funding_category /* For Bug 2244796 */
1356: FROM pa_tasks t2, pa_tasks t, pa_project_fundings f
1357: WHERE f.project_id = x_orig_project_id
1358: AND t.project_id = f.project_id
1359: AND t.task_id = f.task_id
1360: AND t2.task_number = t.task_number

Line 2033: from pa_expenditure_items_all ei, pa_tasks pt

2029: select 'N'
2030: into l_Exist_Flag
2031: from dual
2032: where exists (select 1
2033: from pa_expenditure_items_all ei, pa_tasks pt
2034: where ei.task_id = pt.task_id
2035: and pt.top_task_id = P_Task_ID
2036: and pt.project_id = P_Project_ID
2037: and (NVL(accrued_revenue,0) <> 0 or NVL(bill_amount,0) <> 0)

Line 2051: from pa_expenditure_items_all ei, pa_tasks pt

2047:
2048: select 'N'
2049: into l_Exist_Flag
2050: from dual where exists (select 1
2051: from pa_expenditure_items_all ei, pa_tasks pt
2052: where ei.task_id = pt.task_id
2053: and pt.top_task_id = P_Task_ID
2054: and pt.project_id = P_Project_ID
2055: and (( NVL(ei.accrued_revenue,0) + NVL((select ei1.accrued_revenue