DBA Data[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_WORKSHEETS

Line 1568: from PSB_WORKSHEETS a, PSB_BUDGET_GROUPS b

1564: l_currency_code VARCHAR2(15);
1565:
1566: cursor c_bg is
1567: select nvl(b.root_budget_group_id, b.budget_group_id) budget_group_id
1568: from PSB_WORKSHEETS a, PSB_BUDGET_GROUPS b
1569: where a.worksheet_id = p_worksheet_id
1570: and b.budget_group_id = a.budget_group_id;
1571:
1572: -- Bug 3029168 added the join with currency code

Line 1590: and ael.source_table = 'PSB_WORKSHEETS'

1586: sum(nvl(ael.entered_dr, 0) - nvl(ael.entered_cr, 0)) budget_balance
1587: from PSB_AE_LINES_ALL ael,
1588: PSB_AE_HEADERS_ALL aeh
1589: where ael.source_id = p_worksheet_id
1590: and ael.source_table = 'PSB_WORKSHEETS'
1591: and ael.actual_flag = 'B'
1592: and aeh.ae_header_id = ael.ae_header_id
1593: group by aeh.ae_header_id, aeh.budget_version_id, aeh.period_name, ael.code_combination_id, ael.currency_code;*/
1594: