APPS.PA_COST_PLUS dependencies on PA_PROJECT_STUS_UTILS

Line 4343: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'

4339: NULL, ITEM.tp_rule_percentage)
4340: WHERE ((ITEM.cost_ind_compiled_set_id = cs1_row.ind_compiled_set_id AND ITEM.cost_distributed_flag = 'Y')
4341: OR ITEM.tp_ind_compiled_set_id = cs1_row.ind_compiled_set_id)
4342: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4343: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4344: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4345: AND exists (select /*+ PUSH_SUBQ NO_UNNEST */ null
4346: from pa_cost_base_exp_types cbet
4347: --where cbet.cost_base = cost_base_rec.cost_base

Line 4556: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'

4552: ITEM.burden_cost)
4553: ***************************/
4554: WHERE (ITEM.tp_ind_compiled_set_id = cs1_row.ind_compiled_set_id OR
4555: ITEM.cost_ind_compiled_set_id = cs1_row.ind_compiled_set_id )
4556: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4557: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4558: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4559: AND exists (select /*+ NO_UNNEST */ null
4560: from pa_cost_base_exp_types cbet

Line 4646: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'

4642: ITEM.program_id = x_program_id,
4643: ITEM.program_update_date = SYSDATE
4644: WHERE (ITEM.rev_ind_compiled_set_id = cs1_row.ind_compiled_set_id
4645: OR ITEM.inv_ind_compiled_set_id = cs1_row.ind_compiled_set_id)
4646: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4647: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4648: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y' /* missing condition added for bug 4574721 */
4649: AND EXISTS (select /*+ NO_UNNEST */ 1
4650: from pa_cost_base_exp_types cbet

Line 4869: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4865: (select t.task_id
4866: FROM pa_projects_all p, pa_tasks t
4867: WHERE t.project_id=p.project_id AND
4868: ei.task_id = t.task_id AND
4869: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4870: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4871: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N'; /*3059344*/
4872:
4873: CURSOR ei2_cursor

Line 4870: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4866: FROM pa_projects_all p, pa_tasks t
4867: WHERE t.project_id=p.project_id AND
4868: ei.task_id = t.task_id AND
4869: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4870: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4871: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N'; /*3059344*/
4872:
4873: CURSOR ei2_cursor
4874: IS

Line 4891: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4887: (select t.task_id
4888: FROM pa_projects_all p, pa_tasks t
4889: WHERE t.project_id=p.project_id AND
4890: ei.task_id = t.task_id AND
4891: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4892: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4893: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4894:
4895: CURSOR ei3_cursor

Line 4892: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4888: FROM pa_projects_all p, pa_tasks t
4889: WHERE t.project_id=p.project_id AND
4890: ei.task_id = t.task_id AND
4891: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4892: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4893: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4894:
4895: CURSOR ei3_cursor
4896: IS

Line 4913: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4909: (select t.task_id
4910: FROM pa_projects_all p, pa_tasks t
4911: WHERE t.project_id=p.project_id AND
4912: ei.task_id = t.task_id AND
4913: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4914: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4915: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4916:
4917:

Line 4914: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4910: FROM pa_projects_all p, pa_tasks t
4911: WHERE t.project_id=p.project_id AND
4912: ei.task_id = t.task_id AND
4913: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4914: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4915: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4916:
4917:
4918: CURSOR ei4_cursor

Line 4937: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4933: (select t.task_id
4934: FROM pa_projects_all p, pa_tasks t
4935: WHERE t.project_id=p.project_id AND
4936: ei.task_id = t.task_id AND
4937: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4938: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4939: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4940:
4941:

Line 4938: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4934: FROM pa_projects_all p, pa_tasks t
4935: WHERE t.project_id=p.project_id AND
4936: ei.task_id = t.task_id AND
4937: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4938: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4939: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4940:
4941:
4942: CURSOR ei5_cursor

Line 4961: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4957: (select t.task_id
4958: FROM pa_projects_all p, pa_tasks t
4959: WHERE t.project_id=p.project_id AND
4960: ei.task_id = t.task_id AND
4961: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4962: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4963: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4964:
4965:

Line 4962: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4958: FROM pa_projects_all p, pa_tasks t
4959: WHERE t.project_id=p.project_id AND
4960: ei.task_id = t.task_id AND
4961: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4962: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4963: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4964:
4965:
4966: CURSOR ei6_cursor

Line 4985: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/

4981: (select t.task_id
4982: FROM pa_projects_all p, pa_tasks t
4983: WHERE t.project_id=p.project_id AND
4984: ei.task_id = t.task_id AND
4985: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
4986: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4987: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4988:
4989:

Line 4986: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4982: FROM pa_projects_all p, pa_tasks t
4983: WHERE t.project_id=p.project_id AND
4984: ei.task_id = t.task_id AND
4985: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
4986: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4987: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4988:
4989:
4990: CURSOR ei7_cursor

Line 5003: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

4999: (select t.task_id
5000: FROM pa_projects_all p, pa_tasks t
5001: WHERE t.project_id=p.project_id AND
5002: ei.task_id = t.task_id AND
5003: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5004: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5005: AND (decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5006:
5007: CURSOR ei8_cursor

Line 5004: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5000: FROM pa_projects_all p, pa_tasks t
5001: WHERE t.project_id=p.project_id AND
5002: ei.task_id = t.task_id AND
5003: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5004: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5005: AND (decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5006:
5007: CURSOR ei8_cursor
5008: IS

Line 5021: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/

5017: (select t.task_id
5018: FROM pa_projects_all p, pa_tasks t
5019: WHERE t.project_id=p.project_id AND
5020: ei.task_id = t.task_id AND
5021: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5022: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5023: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5024:
5025: CURSOR ei9_cursor

Line 5022: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5018: FROM pa_projects_all p, pa_tasks t
5019: WHERE t.project_id=p.project_id AND
5020: ei.task_id = t.task_id AND
5021: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5022: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5023: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5024:
5025: CURSOR ei9_cursor
5026: IS

Line 5039: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915 */

5035: (select t.task_id
5036: FROM pa_projects_all p, pa_tasks t
5037: WHERE t.project_id=p.project_id AND
5038: ei.task_id = t.task_id AND
5039: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915 */
5040: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5041: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5042:
5043: CURSOR ei10_cursor

Line 5040: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5036: FROM pa_projects_all p, pa_tasks t
5037: WHERE t.project_id=p.project_id AND
5038: ei.task_id = t.task_id AND
5039: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915 */
5040: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5041: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5042:
5043: CURSOR ei10_cursor
5044: IS

Line 5069: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/

5065: (select t.task_id
5066: FROM pa_projects_all p, pa_tasks t
5067: WHERE t.project_id=p.project_id AND
5068: ei.task_id = t.task_id AND
5069: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5070: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5071: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5072:
5073: CURSOR ei11_cursor

Line 5070: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5066: FROM pa_projects_all p, pa_tasks t
5067: WHERE t.project_id=p.project_id AND
5068: ei.task_id = t.task_id AND
5069: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5070: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5071: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5072:
5073: CURSOR ei11_cursor
5074: IS

Line 5100: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/

5096: (select t.task_id
5097: FROM pa_projects_all p, pa_tasks t
5098: WHERE t.project_id=p.project_id AND
5099: ei.task_id = t.task_id AND
5100: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5101: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5102: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5103:
5104: CURSOR ei12_cursor

Line 5101: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5097: FROM pa_projects_all p, pa_tasks t
5098: WHERE t.project_id=p.project_id AND
5099: ei.task_id = t.task_id AND
5100: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5101: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5102: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5103:
5104: CURSOR ei12_cursor
5105: IS

Line 5130: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

5126: (select t.task_id
5127: FROM pa_projects_all p, pa_tasks t
5128: WHERE t.project_id=p.project_id AND
5129: ei.task_id = t.task_id AND
5130: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5131: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5132: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5133:
5134:

Line 5131: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5127: FROM pa_projects_all p, pa_tasks t
5128: WHERE t.project_id=p.project_id AND
5129: ei.task_id = t.task_id AND
5130: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5131: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5132: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5133:
5134:
5135: /*

Line 5169: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y';*/

5165: syslink.labor_non_labor_flag = 'N')
5166: )
5167: AND nvl(ei.net_zero_adjustment_flag, 'N') <> 'Y'
5168: AND proj.project_id = task.project_id
5169: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y';*/
5170:
5171: /*Bug# 2164590:Changed ei13_cursor for performance*/
5172: CURSOR ei13_cursor
5173: IS

Line 5184: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

5180: WHERE task.task_id = ei.task_id
5181: AND ei.system_linkage_function = syslink.function
5182: /*AND task.project_id = proj.project_id 2933915*/
5183: AND task.project_id = ei.project_id /*2933915*/
5184: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
5185: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ) /*3059344*/
5186: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5187: AND ((NVL(task.labor_tp_fixed_date, ei.expenditure_item_date) BETWEEN --Bug 5917245 Removed TRUNC
5188: l_start_date

Line 5210: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y' ****2933915*/

5206: NVL(l_end_date, ei.expenditure_item_date)
5207: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5208: /**** AND ei.task_id = task.task_id
5209: AND proj.project_id = task.project_id
5210: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y' ****2933915*/
5211: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
5212: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5213:
5214:

Line 5211: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

5207: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5208: /**** AND ei.task_id = task.task_id
5209: AND proj.project_id = task.project_id
5210: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y' ****2933915*/
5211: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
5212: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5213:
5214:
5215:

Line 5319: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/

5315: (select t.task_id
5316: FROM pa_projects_all p, pa_tasks t
5317: WHERE t.project_id=p.project_id AND
5318: ei.task_id = t.task_id AND
5319: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5320: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/
5321: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5322: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
5323: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );

Line 5320: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/

5316: FROM pa_projects_all p, pa_tasks t
5317: WHERE t.project_id=p.project_id AND
5318: ei.task_id = t.task_id AND
5319: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5320: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/
5321: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5322: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
5323: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5324:

Line 5406: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commenteed for bug# 2933915*/

5402: (select t.task_id
5403: FROM pa_projects_all p, pa_tasks t
5404: WHERE t.project_id=p.project_id AND
5405: ei.task_id = t.task_id AND
5406: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commenteed for bug# 2933915*/
5407: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5408: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5409:
5410:

Line 5407: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5403: FROM pa_projects_all p, pa_tasks t
5404: WHERE t.project_id=p.project_id AND
5405: ei.task_id = t.task_id AND
5406: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commenteed for bug# 2933915*/
5407: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5408: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5409:
5410:
5411: -- consider volume of expenditure items having the same compiled set id

Line 5474: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

5470: (select t.task_id
5471: FROM pa_projects_all p, pa_tasks t
5472: WHERE t.project_id=p.project_id AND
5473: ei.task_id = t.task_id AND
5474: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5475: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5476: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5477:
5478:

Line 5475: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5471: FROM pa_projects_all p, pa_tasks t
5472: WHERE t.project_id=p.project_id AND
5473: ei.task_id = t.task_id AND
5474: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5475: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5476: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5477:
5478:
5479: -- consider volume of expenditure items having the same compiled set id

Line 5547: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

5543: (select t.task_id
5544: FROM pa_projects_all p, pa_tasks t
5545: WHERE t.project_id=p.project_id AND
5546: ei.task_id = t.task_id AND
5547: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
5548: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5549: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5550:
5551: -- consider volume of expenditure items having the same compiled set id

Line 5548: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5544: FROM pa_projects_all p, pa_tasks t
5545: WHERE t.project_id=p.project_id AND
5546: ei.task_id = t.task_id AND
5547: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
5548: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5549: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5550:
5551: -- consider volume of expenditure items having the same compiled set id
5552: COMMIT;

Line 5632: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/

5628: (select t.task_id
5629: FROM pa_projects_all p, pa_tasks t
5630: WHERE t.project_id=p.project_id AND
5631: ei.task_id = t.task_id AND
5632: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5633: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5634: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5635: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5636: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;

Line 5633: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5629: FROM pa_projects_all p, pa_tasks t
5630: WHERE t.project_id=p.project_id AND
5631: ei.task_id = t.task_id AND
5632: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5633: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5634: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5635: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5636: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;
5637:

Line 5718: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/

5714: (select t.task_id
5715: FROM pa_projects_all p, pa_tasks t
5716: WHERE t.project_id=p.project_id AND
5717: ei.task_id = t.task_id AND
5718: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
5719: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5720: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5721:
5722:

Line 5719: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5715: FROM pa_projects_all p, pa_tasks t
5716: WHERE t.project_id=p.project_id AND
5717: ei.task_id = t.task_id AND
5718: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
5719: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5720: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5721:
5722:
5723: -- consider volume of expenditure items having the same compiled set id

Line 5786: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

5782: (select t.task_id
5783: FROM pa_projects_all p, pa_tasks t
5784: WHERE t.project_id=p.project_id AND
5785: ei.task_id = t.task_id AND
5786: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5787: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5788: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5789:
5790:

Line 5787: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5783: FROM pa_projects_all p, pa_tasks t
5784: WHERE t.project_id=p.project_id AND
5785: ei.task_id = t.task_id AND
5786: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5787: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5788: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5789:
5790:
5791: -- consider volume of expenditure items having the same compiled set id

Line 5865: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

5861: (select t.task_id
5862: FROM pa_projects_all p, pa_tasks t
5863: WHERE t.project_id=p.project_id AND
5864: ei.task_id = t.task_id AND
5865: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5866: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5867: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5868:
5869: ELSE

Line 5866: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5862: FROM pa_projects_all p, pa_tasks t
5863: WHERE t.project_id=p.project_id AND
5864: ei.task_id = t.task_id AND
5865: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5866: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5867: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5868:
5869: ELSE
5870: UPDATE pa_expenditure_items_all ei

Line 5901: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

5897: (select t.task_id
5898: FROM pa_projects_all p, pa_tasks t
5899: WHERE t.project_id=p.project_id AND
5900: ei.task_id = t.task_id AND
5901: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5902: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5903: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5904:
5905: END IF;

Line 5902: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5898: FROM pa_projects_all p, pa_tasks t
5899: WHERE t.project_id=p.project_id AND
5900: ei.task_id = t.task_id AND
5901: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5902: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5903: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5904:
5905: END IF;
5906:

Line 5984: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'

5980: program_application_id = x_program_application_id,
5981: program_id = x_program_id,
5982: program_update_date = SYSDATE
5983: WHERE tp_ind_compiled_set_id = compiled_set_id
5984: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'
5985: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5986: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5987: AND EXISTS
5988: (SELECT task_id

Line 6143: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6139: (select t.task_id
6140: FROM pa_projects_all p, pa_tasks t
6141: WHERE t.project_id=p.project_id AND
6142: ei.task_id = t.task_id AND
6143: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6144: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6145: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6146: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6147: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;

Line 6144: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

6140: FROM pa_projects_all p, pa_tasks t
6141: WHERE t.project_id=p.project_id AND
6142: ei.task_id = t.task_id AND
6143: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6144: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6145: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6146: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6147: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6148:

Line 6174: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6170: (select t.task_id
6171: FROM pa_projects_all p, pa_tasks t
6172: WHERE t.project_id=p.project_id AND
6173: ei.task_id = t.task_id AND
6174: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6175: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6176: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6177: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6178: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;

Line 6175: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

6171: FROM pa_projects_all p, pa_tasks t
6172: WHERE t.project_id=p.project_id AND
6173: ei.task_id = t.task_id AND
6174: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6175: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6176: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6177: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6178: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6179:

Line 6257: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6253: (select t.task_id
6254: FROM pa_projects_all p, pa_tasks t
6255: WHERE t.project_id=p.project_id AND
6256: ei.task_id = t.task_id AND
6257: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6258: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6259: AND (l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6260:
6261:

Line 6258: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

6254: FROM pa_projects_all p, pa_tasks t
6255: WHERE t.project_id=p.project_id AND
6256: ei.task_id = t.task_id AND
6257: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6258: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6259: AND (l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6260:
6261:
6262: UPDATE pa_expenditure_items_all ei

Line 6281: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6277: (select t.task_id
6278: FROM pa_projects_all p, pa_tasks t
6279: WHERE t.project_id=p.project_id AND
6280: ei.task_id = t.task_id AND
6281: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6282: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6283: AND (l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6284:
6285: /* 9266246 - End */

Line 6282: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

6278: FROM pa_projects_all p, pa_tasks t
6279: WHERE t.project_id=p.project_id AND
6280: ei.task_id = t.task_id AND
6281: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6282: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6283: AND (l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6284:
6285: /* 9266246 - End */
6286:

Line 6379: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6375: (select t.task_id
6376: FROM pa_projects_all p, pa_tasks t
6377: WHERE t.project_id=p.project_id AND
6378: ei.task_id = t.task_id AND
6379: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6380: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6381: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6382:
6383: -- consider volume of expenditure items having the same compiled set id

Line 6380: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

6376: FROM pa_projects_all p, pa_tasks t
6377: WHERE t.project_id=p.project_id AND
6378: ei.task_id = t.task_id AND
6379: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6380: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6381: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6382:
6383: -- consider volume of expenditure items having the same compiled set id
6384: COMMIT;

Line 6415: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6411: (select t.task_id
6412: FROM pa_projects_all p, pa_tasks t
6413: WHERE t.project_id=p.project_id AND
6414: ei.task_id = t.task_id AND
6415: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6416: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6417: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6418:
6419: END IF;

Line 6416: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

6412: FROM pa_projects_all p, pa_tasks t
6413: WHERE t.project_id=p.project_id AND
6414: ei.task_id = t.task_id AND
6415: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6416: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6417: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6418:
6419: END IF;
6420:

Line 6499: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6495: (select t.task_id
6496: FROM pa_projects_all p, pa_tasks t
6497: WHERE t.project_id=p.project_id AND
6498: ei.task_id = t.task_id AND
6499: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6500: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6501: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6502:
6503:

Line 6500: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

6496: FROM pa_projects_all p, pa_tasks t
6497: WHERE t.project_id=p.project_id AND
6498: ei.task_id = t.task_id AND
6499: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6500: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6501: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6502:
6503:
6504: /***2933915:UPDATE eis for 'BURDEN_RESUMMARIZE' ONLY if cost_distributed_flag ='Y' and profile option is enabled and burdening is