APPS.PA_REVENUE_AMT dependencies on PA_TASKS

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 822: pa_tasks t

818: rdl.draft_revenue_num,
819: ei.accrued_revenue ,
820: ei.raw_revenue
821: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei,
822: pa_tasks t
823: where p_top_task_id is not NULL
824: AND ei.request_id+0 = p_request_id
825: AND ei.raw_revenue is not NULL
826: AND ei.accrued_revenue is not NULL

Line 898: from pa_tasks t ,

894: IF p_task_level_funding = 1 THEN
895: /*Modified the query for 9767275*/
896: select /*+ LEADING ( T ) ORDERED USE_NL ( T EI RDL ) INDEX ( RDL PA_CUST_REV_DIST_LINES_N1 ) */ 'X'
897: into dummy_x
898: from pa_tasks t ,
899: pa_expenditure_items_all ei ,
900: pa_cust_rev_dist_lines_all rdl
901: where ei.request_id+0 = p_request_id
902: AND ei.raw_revenue is not NULL