APPS.PSB_WS_ACCT2 dependencies on GL_ACCOUNT_HIERARCHIES

Line 7700: -- following the mapping in GL_ACCOUNT_HIERARCHIES

7696:
7697: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Summary_Accounts';
7698:
7699: -- This cursor sums up the detailed account balances for each summary account
7700: -- following the mapping in GL_ACCOUNT_HIERARCHIES
7701:
7702:
7703: -- Bug 4474717.
7704: -- Replaced set_of_books_id with ledger_id

Line 7729: from GL_ACCOUNT_HIERARCHIES a,

7725: sum(nvl(b.period9_amount, 0)) p9_amt,
7726: sum(nvl(b.period10_amount, 0)) p10_amt,
7727: sum(nvl(b.period11_amount, 0)) p11_amt,
7728: sum(nvl(b.period12_amount, 0)) p12_amt
7729: from GL_ACCOUNT_HIERARCHIES a,
7730: PSB_WS_ACCOUNT_LINES b,
7731: PSB_SUMMARY_TEMPLATES c
7732: where a.detail_code_combination_id = b.code_combination_id
7733: and a.template_id = c.template_id

Line 7771: GL_ACCOUNT_HIERARCHIES b

7767: TemplateID NUMBER,
7768: YearID NUMBER) is
7769: select distinct a.budget_group_id
7770: from PSB_WS_ACCOUNT_LINES a,
7771: GL_ACCOUNT_HIERARCHIES b
7772: where p_current_stage_seq between a.start_stage_seq and a.current_stage_seq
7773: and a.code_combination_id = b.detail_code_combination_id
7774: and a.budget_year_id = YearID
7775: /*For Bug No : 2586618 Start*/