APPS.GMS_SWEEPER dependencies on GMS_BUDGET_VERSIONS

Line 69: Select 1 into l_dummy from gms_budget_versions

65: -------------------------------------------------------------------------------------------------- */
66: Procedure Lock_budget_versions(p_budget_version_id number) is
67: l_dummy number;
68: Begin
69: Select 1 into l_dummy from gms_budget_versions
70: where budget_version_id = p_budget_version_id
71: for update;
72: End Lock_budget_versions;
73:

Line 350: from gms_budget_versions

346: l_stage := 'intialize_revenue_records: Get Bvid';
347:
348: Select budget_version_id
349: into l_bvid
350: from gms_budget_versions
351: where project_id = p_project_id
352: and award_id = p_award_id
353: and budget_type_code ='AC'
354: and budget_status_code = 'B'

Line 565: from gms_budget_versions gbv

561: , gbc.parent_bc_packet_id
562: , gbc.expenditure_type
563: , nvl(gbc.burden_adjustment_flag,'N') burden_adjustment_flag
564: , gbc.rowid
565: from gms_budget_versions gbv
566: , gms_bc_packets gbc
567: , pa_budget_entry_methods pbm
568: , gms_awards_all ga
569: where gbc.status_code = x_status_code --Bug 2138376 : Replaced 'A' with x_status_code

Line 937: x_budget_version_id gms_budget_versions.budget_version_id%type;

933: St_Err_Buff varchar2(2000) := null;
934: x_e_code number;
935: x_stage varchar2(100);
936: St_Err_Code varchar2(1);
937: x_budget_version_id gms_budget_versions.budget_version_id%type;
938:
939: x_budget_entry_method pa_budget_entry_methods.budget_entry_method%type;
940: x_categorization_code pa_budget_entry_methods.categorization_code%type;
941: x_resource_list_id gms_budget_versions.resource_list_id%type;

Line 941: x_resource_list_id gms_budget_versions.resource_list_id%type;

937: x_budget_version_id gms_budget_versions.budget_version_id%type;
938:
939: x_budget_entry_method pa_budget_entry_methods.budget_entry_method%type;
940: x_categorization_code pa_budget_entry_methods.categorization_code%type;
941: x_resource_list_id gms_budget_versions.resource_list_id%type;
942: x_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
943: x_uncategorized_rlmi pa_resource_list_members.resource_list_member_id%type;
944: x_prev_list_processed number(30);
945: x_group_resource_type_id number(15);

Line 1048: from gms_budget_versions

1044: Begin
1045:
1046: select budget_version_id
1047: into x_budget_version_id
1048: from gms_budget_versions
1049: where project_id = l_project_id_tbl(i) -- p_project_id as part of the bug 5481465
1050: and award_id = l_award_id_tbl(i) -- p_award_id as part of the bug 5481465
1051: and budget_type_code ='AC'
1052: and budget_status_code = 'B'

Line 1122: from gms_budget_versions a,

1118: into x_resource_list_id,
1119: x_categorization_code,
1120: x_time_phased_type_code ,
1121: x_entry_level_code --2673200
1122: from gms_budget_versions a,
1123: pa_budget_entry_methods b
1124: where a.budget_version_id = x_budget_version_id
1125: and b.budget_entry_method_code = a.budget_entry_method_code;
1126: