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.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_BUDGET_GROUPS

Line 2601: from PSB_BUDGET_GROUPS_V a,

2597: b.budget_calendar_id,
2598: b.budget_by_position,
2599: b.budget_group_id,
2600: nvl(a.set_of_books_id, a.root_set_of_books_id) set_of_books_id
2601: from PSB_BUDGET_GROUPS_V a,
2602: PSB_WORKSHEETS b
2603: where a.budget_group_id = b.budget_group_id
2604: and b.worksheet_id = p_global_worksheet_id;
2605:

Line 2615: from PSB_BUDGET_GROUPS_V a,

2611: b.budget_calendar_id,
2612: b.budget_by_position,
2613: b.budget_group_id,
2614: nvl(a.set_of_books_id, a.root_set_of_books_id) set_of_books_id
2615: from PSB_BUDGET_GROUPS_V a,
2616: PSB_WORKSHEETS b,
2617: PSB_WS_CONSOLIDATION_DETAILS c
2618: where a.budget_group_id = b.budget_group_id
2619: and b.worksheet_id = c.local_worksheet_id

Line 2624: from PSB_BUDGET_GROUPS

2620: and c.global_worksheet_id = p_global_worksheet_id;
2621:
2622: cursor c_BudGrp (budgetgroup_id NUMBER) is
2623: select budget_group_id
2624: from PSB_BUDGET_GROUPS
2625: where budget_group_type = 'R'
2626: and budget_group_id = budgetgroup_id
2627: and effective_start_date <= PSB_WS_ACCT1.g_startdate_pp
2628: and (effective_end_date is null or effective_end_date >= PSB_WS_ACCT1.g_enddate_cy)