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_EXPENDITURE_ITEMS_ALL

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

Line 2056: from pa_expenditure_items_all ei1 where ei1.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0)

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
2056: from pa_expenditure_items_all ei1 where ei1.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0)
2057: or
2058: ( NVL(ei.bill_amount,0) + NVL((select ei2.bill_amount
2059: from pa_expenditure_items_all ei2 where ei2.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0))
2060: and ei.adjusted_expenditure_item_id IS NOT NULL

Line 2059: from pa_expenditure_items_all ei2 where ei2.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0))

2055: and (( NVL(ei.accrued_revenue,0) + NVL((select ei1.accrued_revenue
2056: from pa_expenditure_items_all ei1 where ei1.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0)
2057: or
2058: ( NVL(ei.bill_amount,0) + NVL((select ei2.bill_amount
2059: from pa_expenditure_items_all ei2 where ei2.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0))
2060: and ei.adjusted_expenditure_item_id IS NOT NULL
2061: and ei.net_zero_adjustment_flag = 'Y');
2062:
2063: Return l_Exist_Flag;