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 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

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

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
2071: from pa_expenditure_items_all ei1 where ei1.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0)
2072: or
2073: ( NVL(ei.bill_amount,0) + NVL((select ei2.bill_amount
2074: from pa_expenditure_items_all ei2 where ei2.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0))
2075: and ei.adjusted_expenditure_item_id IS NOT NULL

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

2070: and (( NVL(ei.accrued_revenue,0) + NVL((select ei1.accrued_revenue
2071: from pa_expenditure_items_all ei1 where ei1.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0)
2072: or
2073: ( NVL(ei.bill_amount,0) + NVL((select ei2.bill_amount
2074: from pa_expenditure_items_all ei2 where ei2.expenditure_item_id = ei.adjusted_expenditure_item_id),0) <> 0))
2075: and ei.adjusted_expenditure_item_id IS NOT NULL
2076: and ei.net_zero_adjustment_flag = 'Y');
2077:
2078: Return l_Exist_Flag;