APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_ENTITY

Line 1260: from PSB_ENTITY a

1256: or ((effective_start_date < p_period_start_date)
1257: and (effective_end_date > p_period_end_date))))
1258: UNION
1259: select 'Exists'
1260: from PSB_ENTITY a
1261: where p_local_parameter = 'Y'
1262: and entity_id = p_parameter_id
1263: and exists
1264: (select 1

Line 3178: from PSB_ENTITY

3174: effective_end_date,
3175: 0 priority,
3176: parameter_compound_annually,
3177: currency_code
3178: from PSB_ENTITY
3179: where entity_id = l_parameter_id
3180: and entity_subtype = 'ACCOUNT'
3181: and NVL(currency_code, g_currency_code) = g_currency_code
3182: order by effective_start_date, priority;

Line 6510: FROM psb_entity

6506: -- Bug#4675858
6507: CURSOR c_ParamName
6508: IS
6509: SELECT name
6510: FROM psb_entity
6511: WHERE entity_id = p_parameter_id ;
6512: --
6513: BEGIN
6514:

Line 10808: FROM PSB_ENTITY ent

10804: AND sr.account_or_position_type = 'A'
10805: AND sr.apply_balance_flag = 'A'
10806: )
10807: AND EXISTS (SELECT 1
10808: FROM PSB_ENTITY ent
10809: WHERE ent.entity_id = l_rule_id
10810: AND ( (ent.apply_account_set_flag = 'B')
10811: /* Bug No 2144364 Start */
10812: ---- OR (ent.apply_account_set_flag = bra.revision_type)

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