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_BUDGET_CORE dependencies on GMS_BALANCES

Line 1882: FROM gms_balances

1878: AND gra.budget_version_id = draft_bvid;
1879:
1880: CURSOR c_period_dates_baselined IS
1881: SELECT MIN (start_date), MAX (end_date)
1882: FROM gms_balances
1883: WHERE budget_version_id = bal_bvid;
1884:
1885:
1886: x_task_id NUMBER;

Line 2045: FROM gms_balances gb, gms_budget_versions gbv

2041: BEGIN
2042:
2043: SELECT MIN (start_date), MAX (end_date)
2044: INTO x_gbal_start_date, x_gbal_end_date
2045: FROM gms_balances gb, gms_budget_versions gbv
2046: WHERE gb.budget_version_id = gbv.budget_version_id
2047: AND gb.project_id = x_project_id
2048: AND gb.award_id = x_award_id
2049: AND gbv.award_id = gb.award_id

Line 2142: --Modified the code to make the copy actual pick data from Gms_balances

2138: END IF;
2139:
2140: END;
2141: ------------------------------------------------------------------------------------
2142: --Modified the code to make the copy actual pick data from Gms_balances
2143:
2144:
2145: procedure copy_actual (x_project_id in number,
2146: x_award_id in number,

Line 2511: from gms_balances gb

2507: where m1.parent_member_id =
2508: m.resource_list_member_id
2509: AND NVL(m1.migration_code,'M') ='M') -- Bug 3626671
2510: and exists (select 1 -- Bug 1831151
2511: from gms_balances gb
2512: where budget_version_id = x_current_budget_version_id
2513: and gb.resource_list_member_id=m.resource_list_member_id)
2514: AND NVL(m.migration_code,'M') ='M') -- Bug 3626671
2515: loop

Line 2594: FROM gms_balances gb

2590: from pa_tasks t
2591: where t.project_id = x_project_id
2592: and t.task_id = t.top_task_id
2593: and EXISTS ( SELECT 1 -- added for bug 1831151
2594: FROM gms_balances gb
2595: WHERE gb.budget_version_id =
2596: x_current_budget_version_id
2597: AND gb.top_task_id = t.task_id )) loop
2598: x_burdened_cost:= 0;

Line 2686: FROM gms_balances gb

2682: where m1.parent_member_id =
2683: m.resource_list_member_id
2684: AND NVL(m1.migration_code,'M') ='M') -- Bug 3626671
2685: AND EXISTS ( SELECT 1-- added for bug 1831151
2686: FROM gms_balances gb
2687: WHERE budget_version_id =
2688: x_current_budget_version_id
2689: AND gb.resource_list_member_id =
2690: m.resource_list_member_id)

Line 2772: FROM gms_balances

2768: (select 1
2769: from pa_tasks t1
2770: where t1.parent_task_id = t.task_id)
2771: AND EXISTS ( SELECT 1 --bug 1831151
2772: FROM gms_balances
2773: WHERE budget_version_id =
2774: x_current_budget_version_id
2775: AND task_id = t.task_id)
2776:

Line 2851: FROM gms_balances gb

2847: where m1.parent_member_id =
2848: m.resource_list_member_id
2849: AND NVL(m1.migration_code,'M') ='M') -- Bug 3626671
2850: AND EXISTS ( SELECT 1 -- Bug 1831151
2851: FROM gms_balances gb
2852: WHERE budget_version_id =
2853: x_current_budget_version_id
2854: AND gb.resource_list_member_id =
2855: m.resource_list_member_id )

Line 2946: -- Following procedure are used to fetch actual amounts from gms_balances

2942: ------------------------------------------------------------------------------------
2943: -- added for bug 1831151
2944: -- Actuals accumulation API
2945:
2946: -- Following procedure are used to fetch actual amounts from gms_balances
2947: -- based on the parameters passed.
2948:
2949: PROCEDURE get_proj_txn_accum (
2950: x_project_id IN NUMBER,

Line 2966: FROM gms_balances gmsb, pa_periods pp

2962: ) IS
2963: CURSOR seltxnaccums_p (x_prd_start_date IN DATE, x_prd_end_date IN DATE) IS
2964: SELECT gmsb.actual_period_to_date tot_burdened_cost,
2965: gmsb.actual_period_to_date tot_billable_burdened_cost
2966: FROM gms_balances gmsb, pa_periods pp
2967: WHERE gmsb.project_id = x_project_id
2968: AND gmsb.budget_version_id = x_current_budget_version_id
2969: AND gmsb.task_id = DECODE (
2970: x_task_id,

Line 2988: gms_balances gmsb

2984: SELECT gmsb.actual_period_to_date tot_burdened_cost,
2985: gmsb.actual_period_to_date tot_billable_burdened_cost
2986: FROM pa_implementations imp,
2987: gl_period_statuses glp,
2988: gms_balances gmsb
2989: WHERE gmsb.project_id = x_project_id
2990: AND gmsb.budget_version_id = x_current_budget_version_id
2991: AND gmsb.task_id = DECODE (
2992: x_task_id,

Line 3056: -- Following procedure are used to fetch actual amounts from gms_balances

3052: -----------------------------------------------------------------------------------------
3053: -- Added for bug 1831151
3054: -- Actuals accumulation API
3055:
3056: -- Following procedure are used to fetch actual amounts from gms_balances
3057: -- based on the parameters passed.
3058:
3059:
3060: PROCEDURE get_proj_res_accum (

Line 3078: FROM gms_balances gmsb, pa_periods pp

3074: ) IS
3075: CURSOR selresaccums_p (x_prd_start_date IN DATE, x_prd_end_date IN DATE) IS
3076: SELECT gmsb.actual_period_to_date tot_burdened_cost,
3077: gmsb.actual_period_to_date tot_billable_burdened_cost
3078: FROM gms_balances gmsb, pa_periods pp
3079: WHERE gmsb.project_id = x_project_id
3080: AND gmsb.budget_version_id = x_current_budget_version_id
3081: AND gmsb.task_id = DECODE (
3082: x_task_id,

Line 3102: gms_balances gmsb

3098: SELECT gmsb.actual_period_to_date tot_burdened_cost,
3099: gmsb.actual_period_to_date tot_billable_burdened_cost
3100: FROM pa_implementations imp,
3101: gl_period_statuses glp,
3102: gms_balances gmsb
3103: WHERE gmsb.project_id = x_project_id
3104: AND gmsb.budget_version_id = x_current_budget_version_id
3105: AND gmsb.task_id = DECODE (
3106: x_task_id,