DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_DRAFT_REVENUES

Line 1096: FROM pa_draft_revenues dr

1092: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1093: AND x_revenue_flag = 'Y'
1094: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1095: AND EXISTS (SELECT 'x'
1096: FROM pa_draft_revenues dr
1097: WHERE dr.project_id = proj.project_id
1098: AND NVL(dr.resource_accumulated_flag,'S') =
1099: DECODE(x_mode,'I', 'S', 'F',
1100: NVL(dr.resource_accumulated_flag,'S'),'S')