APPS.PSB_WS_ACCT2 dependencies on PSB_SET_RELATIONS

Line 12: FROM psb_set_relations_v

8: IS
9: SELECT account_position_set_id,
10: effective_start_date,
11: effective_end_date
12: FROM psb_set_relations_v
13: WHERE account_or_position_type = 'A'
14: AND budget_group_id = budgetgroup_id ;
15:
16: -- Select Budget Groups in Hierarchy; 'connect by' does a depth-first search

Line 3985: /* Bug 3543845: Eliminate PSB_SET_RELATIONS_V */

3981: ) RETURN BOOLEAN IS
3982:
3983: l_parameter_exists BOOLEAN := FALSE;
3984:
3985: /* Bug 3543845: Eliminate PSB_SET_RELATIONS_V */
3986:
3987: cursor c_Exists is
3988: select 'Exists'
3989: from PSB_ENTITY a

Line 3993: from PSB_SET_RELATIONS b,

3989: from PSB_ENTITY a
3990: where entity_id = p_parameter_id
3991: and exists
3992: (select 1
3993: from PSB_SET_RELATIONS b,
3994: PSB_BUDGET_ACCOUNTS c
3995: where b.account_position_set_id = c.account_position_set_id
3996: and b.parameter_id = p_parameter_id
3997: and c.code_combination_id = p_ccid)

Line 4438: -- Bug 3543845: Avoid using PSB_SET_RELATIONS_V

4434: -- identified by Year_Start_Date, Year_End_Date. The CCID should be valid for
4435: -- the duration of the parameter. Parameters are sorted by the Parameter Start
4436: -- Date and Priority within a Budget Year
4437:
4438: -- Bug 3543845: Avoid using PSB_SET_RELATIONS_V
4439: cursor c_Parameter (Year_Start_Date DATE,
4440: Year_End_Date DATE) is
4441: select parameter_id,
4442: name,

Line 4450: from PSB_SET_RELATIONS b,

4446: parameter_compound_annually
4447: from PSB_PARAMETER_ASSIGNMENTS_V a
4448: where exists
4449: (select 1
4450: from PSB_SET_RELATIONS b,
4451: PSB_BUDGET_ACCOUNTS c
4452: where b.account_position_set_id = c.account_position_set_id
4453: and b.parameter_id = a.parameter_id
4454: and c.code_combination_id = p_ccid

Line 5716: -- Remove the usage of PSB_ALLOCRULE_ASSIGNMENTS_V and PSB_SET_RELATIONS_V

5712: ) IS
5713:
5714: cursor c_AllocRule is
5715: /* Bug 3458191
5716: -- Remove the usage of PSB_ALLOCRULE_ASSIGNMENTS_V and PSB_SET_RELATIONS_V
5717: -- Replace PSB_ALLOCRULE_ASSIGNMENTS_V by PSB_ENTITY_ASSIGNMENT, PSB_ENTITY
5718: -- Replace PSB_SET_RELATIONS_V by PSB_SET_RELATIONS
5719: */
5720: select pea.entity_id as allocrule_id,

Line 5718: -- Replace PSB_SET_RELATIONS_V by PSB_SET_RELATIONS

5714: cursor c_AllocRule is
5715: /* Bug 3458191
5716: -- Remove the usage of PSB_ALLOCRULE_ASSIGNMENTS_V and PSB_SET_RELATIONS_V
5717: -- Replace PSB_ALLOCRULE_ASSIGNMENTS_V by PSB_ENTITY_ASSIGNMENT, PSB_ENTITY
5718: -- Replace PSB_SET_RELATIONS_V by PSB_SET_RELATIONS
5719: */
5720: select pea.entity_id as allocrule_id,
5721: pe.budget_year_type_id,
5722: pe.balance_type

Line 5728: from PSB_SET_RELATIONS b,

5724: where pe.entity_type = 'ALLOCRULE'
5725: and pe.entity_id = pea.entity_id
5726: and exists
5727: (select 1
5728: from PSB_SET_RELATIONS b,
5729: PSB_BUDGET_ACCOUNTS c
5730: where b.account_position_set_id = c.account_position_set_id
5731: and b.allocation_rule_id = pea.entity_id
5732: and c.code_combination_id = p_ccid)

Line 8214: psb_set_relations r,

8210: CURSOR l_ccid_csr
8211: IS
8212: SELECT code_combination_id
8213: FROM psb_budget_accounts a,
8214: psb_set_relations r,
8215: psb_gl_budgets b,
8216: psb_gl_budget_sets c
8217: WHERE c.gl_budget_set_id = p_gl_budget_set_id
8218: AND c.gl_budget_set_id = b.gl_budget_set_id