APPS.GMS_PA_API3 dependencies on GMS_AWARD_DISTRIBUTIONS

Line 150: from gms_award_distributions adl,

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'

Line 722: gms_award_distributions adl

718: l_receipt_currency_amount,
719: l_receipt_exchange_rate,
720: l_burdenable_raw_cost
721: FROM PA_PROJ_REQ_DISTRIBUTIONS PPRD,
722: gms_award_distributions adl
723: WHERE PPRD.project_id = p_start_project_id
724: --
725: -- Bug : 4908630
726: -- R12.PJ:XB2:DEV:GMS: APPSPERF:GMS: PACKAGE: GMSPAX3B.PLS ( SHARE MEM:11MB) 5 SQL

Line 1299: GMS_AWARD_DISTRIBUTIONS ADL

1295: l_receipt_currency_amount,
1296: l_receipt_exchange_rate,
1297: l_burdenable_raw_cost
1298: FROM PA_PROJ_PO_DISTRIBUTIONS PPPD,
1299: GMS_AWARD_DISTRIBUTIONS ADL
1300: WHERE PPPD.project_id = p_start_project_id
1301: and pppd.po_distribution_id = adl.po_distribution_id
1302: and pppd.award_set_id = adl.award_set_id
1303: and adl.adl_line_num = 1

Line 1883: GMS_AWARD_DISTRIBUTIONS ADL

1879: l_receipt_exchange_rate,
1880: l_burdenable_raw_cost
1881: /* Commented for Bug 5645290
1882: FROM PA_PROJ_AP_INV_DISTRIBUTIONS PPAID,
1883: GMS_AWARD_DISTRIBUTIONS ADL
1884: WHERE PPAID.project_id = p_start_project_id */
1885: /* Added for Bug 5645290 */
1886: FROM PA_PROJ_AP_INV_DISTRIBUTIONS PPAID,
1887: GMS_AWARD_DISTRIBUTIONS ADL,

Line 1887: GMS_AWARD_DISTRIBUTIONS ADL,

1883: GMS_AWARD_DISTRIBUTIONS ADL
1884: WHERE PPAID.project_id = p_start_project_id */
1885: /* Added for Bug 5645290 */
1886: FROM PA_PROJ_AP_INV_DISTRIBUTIONS PPAID,
1887: GMS_AWARD_DISTRIBUTIONS ADL,
1888: gms_allowable_expenditures gae,
1889: gms_awards_all ga
1890: WHERE PPAID.project_id = p_start_project_id
1891: and ga.award_id = adl.award_id

Line 2652: from gms_award_distributions adl

2648: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2649: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
2650: AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2651: AND EXISTS ( select null
2652: from gms_award_distributions adl
2653: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2654: and adl.award_id = p_award_id )
2655: AND ITEM.encumbrance_item_date between l_start_date_min
2656: and nvl(l_end_date_max,ITEM.encumbrance_item_date) -- dates corresponding to schedule revisions

Line 2688: from gms_award_distributions adl

2684: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
2685: AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2686: AND EXISTS
2687: ( select null
2688: from gms_award_distributions adl
2689: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2690: and adl.award_id = p_award_id )
2691: AND ITEM.encumbrance_item_date between l_start_date_min and nvl(l_end_date_max,ITEM.encumbrance_item_date)
2692: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')

Line 2748: from gms_award_distributions adl

2744: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2745: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
2746: AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2747: AND EXISTS ( select null
2748: from gms_award_distributions adl
2749: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2750: and adl.award_id = p_award_id )
2751: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2752: AND ITEM.ind_compiled_set_id is not null

Line 2781: from gms_award_distributions adl

2777: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
2778: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
2779: AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2780: AND EXISTS ( select null
2781: from gms_award_distributions adl
2782: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2783: and adl.award_id = p_award_id )
2784: AND ITEM.ind_compiled_set_id is not null
2785: AND NOT EXISTS