APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_DRAFT_REVENUES

Line 1062: FROM pa_draft_revenues dr

1058: BETWEEN l_project_num_from AND l_project_num_to
1059: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1060: AND x_revenue_flag = 'Y'
1061: AND EXISTS (SELECT 'x'
1062: FROM pa_draft_revenues dr
1063: WHERE dr.project_id = proj.project_id
1064: AND NVL(dr.resource_accumulated_flag,'S') =
1065: DECODE(x_mode,'I', 'S', 'F',
1066: NVL(dr.resource_accumulated_flag,'S'),'S')