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 2048: from pa_expenditure_items_all ei, pa_tasks pt

2044: select 'N'
2045: into l_Exist_Flag
2046: from dual
2047: where exists (select 1
2048: from pa_expenditure_items_all ei, pa_tasks pt
2049: where ei.task_id = pt.task_id
2050: and pt.top_task_id = P_Task_ID
2051: and pt.project_id = P_Project_ID
2052: and (NVL(accrued_revenue,0) <> 0 or NVL(bill_amount,0) <> 0)

Line 2066: from pa_expenditure_items_all ei, pa_tasks pt

2062:
2063: select 'N'
2064: into l_Exist_Flag
2065: from dual where exists (select 1
2066: from pa_expenditure_items_all ei, pa_tasks pt
2067: where ei.task_id = pt.task_id
2068: and pt.top_task_id = P_Task_ID
2069: and pt.project_id = P_Project_ID
2070: and (( NVL(ei.accrued_revenue,0) + NVL((select ei1.accrued_revenue