eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_ALTERNATE_TASK_PVT

Line 869: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(pfa.project_id) = 'N' --bug#16461684

865: WHERE pfa.request_id = x_request_id
866: AND pfa.segment1
867: BETWEEN l_project_num_from AND l_project_num_to
868: AND pfa.action_flag IN ('CS', 'RV', 'RL', 'CM', 'BD', 'PR', 'TX', 'TM')
869: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(pfa.project_id) = 'N' --bug#16461684
870: AND NOT EXISTS (SELECT pf.project_id
871: FROM pa_projects_for_accum pf
872: WHERE pf.request_id = pfa.request_id
873: AND pf.segment1 = pfa.segment1 -- Bug3653978. replaced pfa.project_id with pfa.segment1

Line 890: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(pfa.project_id) = 'N' --bug#16461684

886: WHERE pfa.request_id = x_request_id
887: AND pfa.segment1
888: BETWEEN l_project_num_from AND l_project_num_to
889: AND pfa.action_flag = 'CM'
890: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(pfa.project_id) = 'N' --bug#16461684
891: AND NOT EXISTS (SELECT pf.project_id
892: FROM pa_projects_for_accum pf
893: WHERE pf.request_id = pfa.request_id
894: AND pf.segment1 = pfa.segment1 -- Bug3783746. replaced pf.project_id with pfa.segment1

Line 1078: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1074: WHERE proj.segment1
1075: BETWEEN l_project_num_from AND l_project_num_to
1076: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1077: AND x_actual_cost_flag = 'Y'
1078: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1079: AND EXISTS (SELECT 'x'
1080: FROM pa_cost_distribution_lines_all cdl
1081: WHERE cdl.project_id = proj.project_id
1082: AND (cdl.line_type = 'R' OR

Line 1094: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1090: WHERE proj.segment1
1091: BETWEEN l_project_num_from AND l_project_num_to
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') =

Line 1109: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1105: FROM pa_projects_for_accum_v proj
1106: WHERE proj.segment1
1107: BETWEEN l_project_num_from AND l_project_num_to
1108: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1109: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1110: AND EXISTS (SELECT 'x'
1111: FROM pa_resource_list_assignments rla
1112: WHERE rla.project_id = proj.project_id
1113: AND NVL(rla.resource_list_accumulated_flag,

Line 1130: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1126: WHERE proj.segment1
1127: BETWEEN l_project_num_from AND l_project_num_to
1128: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1129: AND x_budgets_flag = 'Y'
1130: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1131: AND EXISTS (SELECT 'x'
1132: FROM pa_budget_versions bud
1133: WHERE bud.project_id = proj.project_id
1134: AND bud.current_flag = 'Y'

Line 1143: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1139: FROM pa_projects_for_accum_v proj
1140: WHERE proj.segment1
1141: BETWEEN l_project_num_from AND l_project_num_to
1142: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1143: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1144: AND EXISTS (SELECT 'x'
1145: FROM pa_project_accum_headers pah
1146: WHERE pah.project_id = proj.project_id
1147: AND NVL(pah.tasks_restructured_flag, 'N') = 'Y')

Line 1155: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1151: FROM pa_projects_for_accum_v proj
1152: WHERE proj.segment1
1153: BETWEEN l_project_num_from AND l_project_num_to
1154: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1155: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1156: AND Pa_Proj_Accum_Main.check_period_flags
1157: (proj.project_id, x_impl_option, l_current_end_date, 'PR',
1158: proj.closed_date, l_current_start_date) = 'Y'
1159: UNION ALL

Line 1166: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1162: FROM pa_projects_for_accum_v proj
1163: WHERE proj.segment1
1164: BETWEEN l_project_num_from AND l_project_num_to
1165: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1166: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1167: AND Pa_Proj_Accum_Main.check_period_flags
1168: (proj.project_id, x_impl_option, l_current_end_date, 'BK',
1169: proj.closed_date, l_current_start_date) = 'Y'
1170: UNION ALL

Line 1177: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1173: FROM pa_projects_for_accum_v proj
1174: WHERE proj.segment1
1175: BETWEEN l_project_num_from AND l_project_num_to
1176: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1177: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1178: AND Pa_Proj_Accum_Main.check_period_flags
1179: (proj.project_id, x_impl_option, l_current_end_date, 'CL',
1180: proj.closed_date, l_current_start_date) = 'Y'
1181: UNION ALL

Line 1188: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1184: FROM pa_projects_for_accum_v proj
1185: WHERE proj.segment1
1186: BETWEEN l_project_num_from AND l_project_num_to
1187: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1188: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1189: AND Pa_Proj_Accum_Main.check_period_flags
1190: (proj.project_id, x_impl_option, l_current_end_date, 'PT',
1191: proj.closed_date, l_current_start_date) = 'Y'
1192: UNION ALL

Line 1198: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1194: proj.segment1, 'N'
1195: FROM pa_projects_for_accum_v proj
1196: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1197: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1198: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1199: AND (x_actual_cost_flag = 'Y' OR x_revenue_flag = 'Y')
1200: AND EXISTS (SELECT 'x'
1201: FROM pa_txn_accum txn
1202: WHERE txn.actual_cost_rollup_flag = 'Y'

Line 1217: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

1213: proj.segment1, 'N'
1214: FROM pa_projects_for_accum_v proj
1215: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1216: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1217: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1218: AND x_commitments_flag = 'Y'
1219: AND EXISTS (SELECT 'x'
1220: FROM pa_txn_accum txn_m
1221: WHERE txn_m.cmt_rollup_flag = 'Y'