APPS.PSB_BUDGET_REVISIONS_PVT dependencies on GL_PERIODS_V

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 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'||