DBA Data[Home] [Help]

APPS.PSB_WS_ACCT2 dependencies on PSB_ENTITY_ASSIGNMENT

Line 5717: -- Replace PSB_ALLOCRULE_ASSIGNMENTS_V by PSB_ENTITY_ASSIGNMENT, PSB_ENTITY

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,
5721: pe.budget_year_type_id,

Line 5723: from PSB_ENTITY_ASSIGNMENT pea, PSB_ENTITY pe

5719: */
5720: select pea.entity_id as allocrule_id,
5721: pe.budget_year_type_id,
5722: pe.balance_type
5723: from PSB_ENTITY_ASSIGNMENT pea, PSB_ENTITY pe
5724: where pe.entity_type = 'ALLOCRULE'
5725: and pe.entity_id = pea.entity_id
5726: and exists
5727: (select 1