APPS.PSB_BUDGET_REVISIONS_PVT dependencies on GL_SETS_OF_BOOKS

Line 712: from GL_SETS_OF_BOOKS

708: select currency_code,
709: chart_of_accounts_id,
710: name,
711: enable_budgetary_control_flag
712: from GL_SETS_OF_BOOKS
713: where set_of_books_id = g_set_of_books_id;
714:
715: cursor c_gl_dates is
716: select period_name, start_date,end_date

Line 10830: AND EXISTS (SELECT 1 FROM PSB_ENTITY_ASSIGNMENT ea, gl_sets_of_books sob, gl_periods_v gp

10826: AND rtt.enable_flag = 'Y'
10827: )
10828: /* Bug No 2133484 End */
10829: /* Bug No 2135165 Start */
10830: AND EXISTS (SELECT 1 FROM PSB_ENTITY_ASSIGNMENT ea, gl_sets_of_books sob, gl_periods_v gp
10831: WHERE ea.entity_set_id = g_brr_rule_set_id
10832: AND ea.entity_id = l_rule_id
10833: AND sob.set_of_books_id = g_brr_sob_id
10834: AND gp.period_set_name = sob.period_set_name

Line 10879: FROM gl_sets_of_books

10875: INTO l_chart_of_accounts_id,
10876: /* Bug No 2135165 Start */
10877: g_brr_sob_id
10878: /* Bug No 2135165 End */
10879: FROM gl_sets_of_books
10880: WHERE set_of_books_id = (SELECT b.set_of_books_id FROM PSB_BUDGET_GROUPS a,
10881: PSB_BUDGET_GROUPS b
10882: WHERE a.budget_group_id = l_budget_group_id
10883: and nvl(a.root_budget_group_id, a.budget_group_id) = b.budget_group_id);

Line 11170: AND EXISTS (SELECT 1 FROM PSB_ENTITY_ASSIGNMENT ea, gl_sets_of_books sob, gl_periods_v gp

11166: AND ba.code_combination_id in (SELECT bra.code_combination_id
11167: FROM PSB_BUDGET_REVISION_LINES brl, PSB_BUDGET_REVISION_ACCOUNTS bra
11168: WHERE brl.budget_revision_id = p_budget_revision_id
11169: AND bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id
11170: AND EXISTS (SELECT 1 FROM PSB_ENTITY_ASSIGNMENT ea, gl_sets_of_books sob, gl_periods_v gp
11171: WHERE ea.entity_set_id = g_brr_rule_set_id
11172: AND ea.entity_id = p_rule_id
11173: AND sob.set_of_books_id = g_brr_sob_id
11174: AND gp.period_set_name = sob.period_set_name

Line 11277: ' FROM PSB_ENTITY_ASSIGNMENT ea, gl_sets_of_books sob, gl_periods_v gp'||

11273: ' PSB_BUDGET_REVISION_ACCOUNTS bra'||
11274: ' WHERE brl.budget_revision_id = :b_budget_revision_id'||
11275: ' AND bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id'||
11276: ' AND EXISTS (SELECT 1 '||
11277: ' FROM PSB_ENTITY_ASSIGNMENT ea, gl_sets_of_books sob, gl_periods_v gp'||
11278: ' WHERE ea.entity_set_id = :b_brr_rule_set_id'||
11279: ' AND ea.entity_id = :b_rule_id'||
11280: ' AND sob.set_of_books_id = :b_brr_sob_id'||
11281: ' AND gp.period_set_name = sob.period_set_name'||