eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_BALANCES

Line 4167: FROM gms_balances

4163: WHERE bv.budget_version_id = bc.budget_version_id
4164: AND bv.budget_entry_method_code = bem.budget_entry_method_code
4165: AND bem.entry_level_code = 'M'
4166: AND t.task_id = (SELECT task_id
4167: FROM gms_balances
4168: WHERE budget_version_id = bc.budget_version_id
4169: AND project_id = bc.project_id
4170: AND award_id = bc.award_id
4171: AND task_id = bc.task_id

Line 4191: FROM gms_balances

4187: WHERE bv.budget_version_id = bc.budget_version_id
4188: AND bv.budget_entry_method_code = bem.budget_entry_method_code
4189: AND bem.entry_level_code = 'M'
4190: AND t.task_id = (SELECT task_id
4191: FROM gms_balances
4192: WHERE task_id = (SELECT top_task_id
4193: FROM pa_tasks
4194: WHERE task_id = bc.task_id)
4195: AND budget_version_id = bc.budget_version_id

Line 4509: FROM gms_balances gb

4505: if x_time_phased_type_code = 'R' then
4506:
4507: SELECT MIN (gb.start_date)
4508: INTO l_gb_start_date
4509: FROM gms_balances gb
4510: WHERE gb.budget_version_id = x_budget_version_id ;
4511:
4512: SELECT MAX (gb.END_date)
4513: INTO l_gb_end_date

Line 4514: FROM gms_balances gb

4510: WHERE gb.budget_version_id = x_budget_version_id ;
4511:
4512: SELECT MAX (gb.END_date)
4513: INTO l_gb_end_date
4514: FROM gms_balances gb
4515: WHERE gb.budget_version_id = x_budget_version_id ;
4516:
4517: --
4518: -- BUG 5529930 11I.GMS:QA:PJMRP3B4: FC FAILURE WHEN PROJECT START PRIOR TO BUDGET STAR

Line 4539: FROM gms_balances

4535: IF nvl(g_budget_version_id,0) <> x_budget_version_id THEN -- Bug 2092791
4536:
4537: SELECT MAX (end_date) --Bug Fix 1828613 From
4538: INTO gb_end_date
4539: FROM gms_balances
4540: WHERE budget_version_id = x_budget_version_id;
4541: SELECT MAX (expenditure_item_date)
4542: INTO exp_date
4543: FROM gms_bc_packets

Line 4591: FROM gms_balances

4587: EXCEPTION
4588: WHEN NO_DATA_FOUND THEN
4589: SELECT TRUNC (MAX (end_date))
4590: INTO gs_end_date
4591: FROM gms_balances
4592: WHERE budget_version_id = x_budget_version_id;
4593: END;
4594: IF gs_end_date > project_end_date THEN
4595: project_end_date := gs_end_date;

Line 4611: FROM gms_balances

4607: EXCEPTION
4608: WHEN NO_DATA_FOUND THEN
4609: SELECT TRUNC (MAX (end_date))
4610: INTO gs_end_date
4611: FROM gms_balances
4612: WHERE budget_version_id = x_budget_version_id;
4613: END;
4614: IF gs_end_date > project_end_date THEN
4615: project_end_date := gs_end_date;

Line 4670: FROM gms_balances

4666: SELECT TRUNC (MAX (start_date)),
4667: TRUNC (MIN (end_date))
4668: INTO dr_period_start_date,
4669: dr_period_end_date
4670: FROM gms_balances
4671: WHERE project_id = x_project_id
4672: AND budget_version_id = x_budget_version_id
4673: AND award_id = x_award_id
4674: AND balance_type <> 'BGT'

Line 4681: FROM gms_balances

4677: SELECT TRUNC (MAX (start_date)),
4678: TRUNC (MIN (end_date))
4679: INTO dr_period_start_date,
4680: dr_period_end_date
4681: FROM gms_balances
4682: WHERE project_id = x_project_id
4683: AND budget_version_id = x_budget_version_id
4684: AND award_id = x_award_id
4685: AND balance_type = 'BGT'

Line 4746: FROM gms_balances

4742: EXCEPTION
4743: WHEN NO_DATA_FOUND THEN
4744: SELECT TRUNC (MIN (start_date))
4745: INTO gs_start_date
4746: FROM gms_balances
4747: WHERE project_id = x_project_id
4748: AND award_id = x_award_id
4749: AND budget_version_id = x_budget_version_id
4750: AND balance_type = 'BGT';

Line 4766: FROM gms_balances

4762: EXCEPTION
4763: WHEN NO_DATA_FOUND THEN
4764: SELECT TRUNC (MIN (start_date))
4765: INTO gs_start_date
4766: FROM gms_balances
4767: WHERE project_id = x_project_id
4768: AND award_id = x_award_id
4769: AND budget_version_id = x_budget_version_id
4770: AND balance_type = 'BGT';

Line 4776: FROM gms_balances

4772: ELSIF x_time_phased_type_code = 'R' THEN
4773: g_error_stage := 'PJTD3';
4774: SELECT TRUNC (MIN (start_date))
4775: INTO gs_start_date
4776: FROM gms_balances
4777: WHERE project_id = x_project_id
4778: AND award_id = x_award_id
4779: AND budget_version_id = x_budget_version_id
4780: AND balance_type = 'BGT';

Line 5827: This procedure compares balances from gms_balances table and Records in gms_bc_packets

5823: END gms_setup;
5824:
5825: /* ------------------------------------------------------------------------------------------------------
5826: This Procedure is called in case of Budget Submit and Re-Baseline prcoess of Award Budget.
5827: This procedure compares balances from gms_balances table and Records in gms_bc_packets
5828: for that budget_version_id. If any Record fails, control comes out of the loop and goes
5829: to the exception part where all the values of variable are dumped into the o/p file
5830:
5831: Bug 3681963 : Modified the code of procedure budget_fundscheck consider the previous consumed

Line 5984: FROM gms_balances

5980: IF NVL(x_r_bc_tot,0) <> 0 THEN
5981:
5982: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
5983: INTO l_balance_available
5984: FROM gms_balances
5985: WHERE budget_version_id = x_budget_version_id
5986: AND start_date >= x_budget_period_start_date
5987: AND end_date <= x_budget_period_end_date
5988: AND resource_list_member_id = x_res_list_member_id

Line 6038: FROM gms_balances

6034: IF NVL(x_rg_bc_tot,0) <> 0 THEN
6035:
6036: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
6037: INTO l_balance_available
6038: FROM gms_balances
6039: WHERE budget_version_id = x_budget_version_id
6040: AND start_date >= x_budget_period_start_date
6041: AND end_date <= x_budget_period_end_date
6042: AND DECODE (

Line 6092: FROM gms_balances

6088: IF NVL(x_t_bc_tot,0) <> 0 THEN
6089:
6090: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
6091: INTO l_balance_available
6092: FROM gms_balances
6093: WHERE budget_version_id = x_budget_version_id
6094: AND start_date >= x_budget_period_start_date
6095: AND end_date <= x_budget_period_end_date
6096: AND task_id = x_bud_task_id;

Line 6141: FROM gms_balances

6137: IF NVL(x_tt_bc_tot,0) <> 0 THEN
6138:
6139: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
6140: INTO l_balance_available
6141: FROM gms_balances
6142: WHERE budget_version_id = x_budget_version_id
6143: AND start_date >= x_budget_period_start_date
6144: AND end_date <= x_budget_period_end_date
6145: AND DECODE (top_task_id, NULL, task_id, top_task_id) = x_top_task_id;

Line 6190: FROM gms_balances

6186: IF NVL(x_a_bc_tot,0) <> 0 THEN
6187:
6188: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
6189: INTO l_balance_available
6190: FROM gms_balances
6191: WHERE budget_version_id = x_budget_version_id
6192: AND start_date >= x_budget_period_start_date
6193: AND end_date <= x_budget_period_end_date;
6194:

Line 6499: FROM gms_balances gb

6495: SET (bp.res_budget_posted, bp.res_actual_posted, bp.res_enc_posted) =
6496: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
6497: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
6498: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
6499: FROM gms_balances gb
6500: WHERE gb.budget_version_id = bp.budget_version_id
6501: AND gb.project_id = bp.project_id
6502: AND gb.award_id = bp.award_id
6503: AND (

Line 6792: FROM gms_balances gb

6788: SET (bp.res_grp_budget_posted, bp.res_grp_actual_posted, bp.res_grp_enc_posted) =
6789: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
6790: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
6791: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
6792: FROM gms_balances gb
6793: WHERE gb.budget_version_id = bp.budget_version_id
6794: AND gb.project_id = bp.project_id
6795: AND gb.award_id = bp.award_id
6796: AND (

Line 7084: FROM gms_balances gb

7080: SET (bp.task_budget_posted, bp.task_actual_posted, bp.task_enc_posted) =
7081: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
7082: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
7083: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
7084: FROM gms_balances gb
7085: WHERE gb.budget_version_id = bp.budget_version_id
7086: AND gb.project_id = bp.project_id
7087: AND gb.award_id = bp.award_id
7088: AND gb.task_id = bp.task_id

Line 7351: FROM gms_balances gb

7347: SET (bp.top_task_budget_posted, bp.top_task_actual_posted, bp.top_task_enc_posted) =
7348: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
7349: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
7350: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
7351: FROM gms_balances gb
7352: WHERE gb.budget_version_id = bp.budget_version_id
7353: AND gb.project_id = bp.project_id
7354: AND gb.award_id = bp.award_id
7355: AND gb.balance_type <> 'REV'

Line 7618: FROM gms_balances gb

7614: SET (bp.award_budget_posted, bp.award_actual_posted, bp.award_enc_posted) =
7615: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
7616: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
7617: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
7618: FROM gms_balances gb
7619: WHERE gb.budget_version_id = bp.budget_version_id
7620: AND gb.project_id = bp.project_id
7621: AND gb.award_id = bp.award_id
7622: AND gb.start_date BETWEEN DECODE (