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_REVENUE_AMT dependencies on PA_DRAFT_REVENUES_ALL

Line 752: FROM pa_tasks t,pa_draft_revenues_all dr

748: p_task_level_funding IN NUMBER ) IS
749: SELECT
750: t.top_task_id TOP_TASK_ID,
751: max(dr.draft_revenue_num) DRAFT_REVENUE_NUM
752: FROM pa_tasks t,pa_draft_revenues_all dr
753: WHERE p_task_level_funding = 1 /* for task level funding projects only */
754: AND dr.project_id = p_project_id
755: AND t.project_id = dr.project_id
756: AND dr.request_id = p_request_id

Line 778: FROM pa_draft_revenues_all dr2

774: GROUP BY t.top_task_id
775: UNION ALL
776: SELECT max(to_number(NULL)) TOP_TASK_ID,
777: max(dr2.draft_revenue_num) DRAFT_REVENUE_NUM
778: FROM pa_draft_revenues_all dr2
779: WHERE p_task_level_funding = 0 /* for project level funding only */
780: AND dr2.project_id = p_project_id
781: AND dr2.request_id+0 = p_request_id
782: AND EXISTS