APPS.PSB_WS_ACCT2 dependencies on PSB_ENTITY

Line 3989: from PSB_ENTITY a

3985: /* Bug 3543845: Eliminate PSB_SET_RELATIONS_V */
3986:
3987: cursor c_Exists is
3988: select 'Exists'
3989: from PSB_ENTITY a
3990: where entity_id = p_parameter_id
3991: and exists
3992: (select 1
3993: from PSB_SET_RELATIONS b,

Line 4089: from PSB_ENTITY

4085: currency_code,
4086: effective_start_date,
4087: effective_end_date,
4088: parameter_compound_annually
4089: from PSB_ENTITY
4090: where entity_id = p_parameter_id
4091: and entity_subtype = 'ACCOUNT';
4092:
4093: -- Bug#1584464: Note_id column added.

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