[Home] [Help]
146: l_award_same := 'N' ;
147:
148: select 'Y'
149: into l_award_same
150: from gms_award_distributions adl,
151: gms_awards ga
152: where adl.expenditure_item_id = p_expenditure_item_id
153: and adl.document_type = 'EXP'
154: and adl.adl_status = 'A'
720: l_receipt_currency_amount,
721: l_receipt_exchange_rate,
722: l_burdenable_raw_cost
723: FROM PA_PROJ_REQ_DISTRIBUTIONS PPRD,
724: gms_award_distributions adl
725: WHERE PPRD.project_id = p_start_project_id
726: --
727: -- Bug : 4908630
728: -- R12.PJ:XB2:DEV:GMS: APPSPERF:GMS: PACKAGE: GMSPAX3B.PLS ( SHARE MEM:11MB) 5 SQL
1297: l_receipt_currency_amount,
1298: l_receipt_exchange_rate,
1299: l_burdenable_raw_cost
1300: FROM PA_PROJ_PO_DISTRIBUTIONS PPPD,
1301: GMS_AWARD_DISTRIBUTIONS ADL
1302: WHERE PPPD.project_id = p_start_project_id
1303: and pppd.po_distribution_id = adl.po_distribution_id
1304: and pppd.award_set_id = adl.award_set_id
1305: and adl.adl_line_num = 1
1881: l_receipt_exchange_rate,
1882: l_burdenable_raw_cost
1883: /* Commented for Bug 5645290
1884: FROM PA_PROJ_AP_INV_DISTRIBUTIONS PPAID,
1885: GMS_AWARD_DISTRIBUTIONS ADL
1886: WHERE PPAID.project_id = p_start_project_id */
1887: /* Added for Bug 5645290 */
1888: FROM PA_PROJ_AP_INV_DISTRIBUTIONS PPAID,
1889: GMS_AWARD_DISTRIBUTIONS ADL,
1885: GMS_AWARD_DISTRIBUTIONS ADL
1886: WHERE PPAID.project_id = p_start_project_id */
1887: /* Added for Bug 5645290 */
1888: FROM PA_PROJ_AP_INV_DISTRIBUTIONS PPAID,
1889: GMS_AWARD_DISTRIBUTIONS ADL,
1890: gms_allowable_expenditures gae,
1891: gms_awards_all ga
1892: WHERE PPAID.project_id = p_start_project_id
1893: and ga.award_id = adl.award_id
2675: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2676: AND l_project_closed <>'Y' --bug 7225876
2677: --bug 6967150 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2678: AND EXISTS ( select null
2679: from gms_award_distributions adl
2680: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2681: and adl.document_type = 'ENC' -- Added these three checks for bug 7225876
2682: and adl.adl_status = 'A'
2683: and adl.adl_line_num = 1
2717: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y' -- bug 7225876
2718: -- bug 7225876 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2719: AND EXISTS
2720: ( select null
2721: from gms_award_distributions adl
2722: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2723: and adl.award_id = p_award_id
2724: and adl.document_type = 'ENC' -- Added these three conditions for bug 7225876
2725: and adl.adl_status = 'A'
2784: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2785: AND l_project_closed <>'Y' --bug 7225876
2786: --bug6967150 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2787: AND EXISTS ( select null
2788: from gms_award_distributions adl
2789: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2790: and adl.document_type = 'ENC' -- Added the three conditions for bug 7225876
2791: and adl.adl_status = 'A'
2792: and adl.adl_line_num = 1
2823: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
2824: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y' --BUG 7225876
2825: --BUG 6967150 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2826: AND EXISTS ( select null
2827: from gms_award_distributions adl
2828: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2829: and adl.document_type = 'ENC' -- Added following three condition for bug 7225876
2830: and adl.adl_status = 'A'
2831: and adl.adl_line_num = 1