APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_PROJECTS_FOR_ACCUM_V

Line 898: FROM pa_projects_for_accum_v proj

894: /* Added for bug 1751445 Cause Performance */
895: /*Commented for perf bug #3672175 and redefined below */
896: /* CURSOR all_valid_proj IS
897: SELECT DISTINCT proj.project_id, proj.segment1
898: FROM pa_projects_for_accum_v proj
899: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
900: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
901: AND NOT EXISTS (SELECT 1
902: FROM pa_projects_for_accum proj_invalid

Line 1041: FROM pa_projects_for_accum_v proj

1037: INSERT INTO pa_projects_for_accum
1038: (project_id, request_id, action_flag, segment1, exception_flag)
1039: SELECT proj.project_id, x_request_id request_id,
1040: 'CS' action_flag, proj.segment1, 'N'
1041: FROM pa_projects_for_accum_v proj
1042: WHERE proj.segment1
1043: BETWEEN l_project_num_from AND l_project_num_to
1044: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1045: AND x_actual_cost_flag = 'Y'

Line 1056: FROM pa_projects_for_accum_v proj

1052: AND cdl.resource_accumulated_flag='N')
1053: UNION ALL
1054: SELECT proj.project_id, x_request_id request_id,
1055: 'RV' action_flag, proj.segment1, 'N'
1056: FROM pa_projects_for_accum_v proj
1057: WHERE proj.segment1
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'

Line 1071: FROM pa_projects_for_accum_v proj

1067: AND dr.released_date IS NOT NULL)
1068: UNION ALL
1069: SELECT proj.project_id, x_request_id request_id,
1070: 'RL' action_flag, proj.segment1, 'N'
1071: FROM pa_projects_for_accum_v proj
1072: WHERE proj.segment1
1073: BETWEEN l_project_num_from AND l_project_num_to
1074: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1075: AND EXISTS (SELECT 'x'

Line 1083: FROM pa_projects_for_accum_v proj

1079: 'N') = 'N')
1080: /* UNION ALL
1081: SELECT proj.project_id, x_request_id request_id,
1082: 'CM' action_flag, proj.segment1, 'N'
1083: FROM pa_projects_for_accum_v proj
1084: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1085: AND x_commitments_flag = 'Y'
1086: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1087: UNION ALL

Line 1090: FROM pa_projects_for_accum_v proj

1086: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1087: UNION ALL
1088: SELECT proj.project_id, x_request_id request_id,
1089: 'BD' action_flag, proj.segment1, 'N'
1090: FROM pa_projects_for_accum_v proj
1091: WHERE proj.segment1
1092: BETWEEN l_project_num_from AND l_project_num_to
1093: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1094: AND x_budgets_flag = 'Y'

Line 1103: FROM pa_projects_for_accum_v proj

1099: AND bud.resource_accumulated_flag = 'N')
1100: UNION ALL
1101: SELECT proj.project_id, x_request_id request_id,
1102: 'TR' action_flag, proj.segment1, 'Y'
1103: FROM pa_projects_for_accum_v proj
1104: WHERE proj.segment1
1105: BETWEEN l_project_num_from AND l_project_num_to
1106: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1107: AND EXISTS (SELECT 'x'

Line 1114: FROM pa_projects_for_accum_v proj

1110: AND NVL(pah.tasks_restructured_flag, 'N') = 'Y')
1111: UNION ALL
1112: SELECT proj.project_id, x_request_id request_id,
1113: 'PR' action_flag, proj.segment1, 'N'
1114: FROM pa_projects_for_accum_v proj
1115: WHERE proj.segment1
1116: BETWEEN l_project_num_from AND l_project_num_to
1117: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1118: AND Pa_Proj_Accum_Main.check_period_flags

Line 1124: FROM pa_projects_for_accum_v proj

1120: proj.closed_date, l_current_start_date) = 'Y'
1121: UNION ALL
1122: SELECT proj.project_id, x_request_id request_id,
1123: 'BK' action_flag, proj.segment1, 'Y'
1124: FROM pa_projects_for_accum_v proj
1125: WHERE proj.segment1
1126: BETWEEN l_project_num_from AND l_project_num_to
1127: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1128: AND Pa_Proj_Accum_Main.check_period_flags

Line 1134: FROM pa_projects_for_accum_v proj

1130: proj.closed_date, l_current_start_date) = 'Y'
1131: UNION ALL
1132: SELECT proj.project_id, x_request_id request_id,
1133: 'CL' action_flag, proj.segment1, 'N'
1134: FROM pa_projects_for_accum_v proj
1135: WHERE proj.segment1
1136: BETWEEN l_project_num_from AND l_project_num_to
1137: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1138: AND Pa_Proj_Accum_Main.check_period_flags

Line 1144: FROM pa_projects_for_accum_v proj

1140: proj.closed_date, l_current_start_date) = 'Y'
1141: UNION ALL
1142: SELECT proj.project_id, x_request_id request_id,
1143: 'PT' action_flag, proj.segment1, 'Y'
1144: FROM pa_projects_for_accum_v proj
1145: WHERE proj.segment1
1146: BETWEEN l_project_num_from AND l_project_num_to
1147: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1148: AND Pa_Proj_Accum_Main.check_period_flags

Line 1154: FROM pa_projects_for_accum_v proj

1150: proj.closed_date, l_current_start_date) = 'Y'
1151: UNION ALL
1152: SELECT proj.project_id, x_request_id request_id, 'TX' action_flag,
1153: proj.segment1, 'N'
1154: FROM pa_projects_for_accum_v proj
1155: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1156: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1157: AND (x_actual_cost_flag = 'Y' OR x_revenue_flag = 'Y')
1158: AND EXISTS (SELECT 'x'

Line 1172: FROM pa_projects_for_accum_v proj

1168: AND x_revenue_flag = 'Y')
1169: UNION ALL
1170: SELECT proj.project_id, x_request_id request_id, 'TM' action_flag,
1171: proj.segment1, 'N'
1172: FROM pa_projects_for_accum_v proj
1173: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1174: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1175: AND x_commitments_flag = 'Y'
1176: AND EXISTS (SELECT 'x'