APPS.PSB_WS_ACCT2 dependencies on PSB_SET_RELATIONS_V

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