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

894: IF p_task_level_funding = 1 THEN
895: select 'X'
896: into dummy_x
897: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei,
898: pa_tasks t
899: where ei.request_id+0 = p_request_id
900: AND ei.raw_revenue is not NULL
901: AND ei.accrued_revenue is not NULL
902: AND ei.revenue_distributed_flag||'' = 'A'