DBA Data[Home] [Help]

APPS.GMS_BILLING_ADJUSTMENTS dependencies on GMS_AWARDS

Line 902: from gms_awards

898: where expenditure_item_id = X_Expenditure_Item_Id
899: and adl_line_num = X_Adl_Line_No
900: and award_id=
901: (select award_id
902: from gms_awards
903: where award_project_id=X_Award_Project_Id
904: )
905: and document_type='EXP'
906: and adl_status = 'A';

Line 963: from gms_awards

959: where expenditure_item_id = X_Expenditure_Item_Id
960: and adl_line_num = X_Adl_Line_No
961: and award_id=
962: (select award_id
963: from gms_awards
964: where award_project_id=X_Award_Project_Id
965: )
966: and document_type='EXP'
967: and adl_status = 'A';

Line 2172: X_Award_Number from gms_awards

2168:
2169: If X_Award_Project_Id is NOT NULL THEN
2170: Begin
2171: select award_number into
2172: X_Award_Number from gms_awards
2173: where award_project_id = X_Award_Project_Id;
2174: End;
2175: End If;
2176: