DBA Data[Home] [Help]

APPS.PSB_SET_RELATION_PVT dependencies on PSB_SET_RELATIONS_V

Line 708: FROM psb_set_relations_v

704: SELECT account_position_set_id ,
705: account_or_position_type ,
706: global_or_local_type ,
707: set_relation_id
708: FROM psb_set_relations_v
709: WHERE DECODE( p_entity_type,
710: 'AR', allocation_rule_id,
711: 'BG', budget_group_id,
712: 'BWR', budget_workflow_rule_id,

Line 856: FROM psb_set_relations_v

852: l_tmp VARCHAR2(1);
853:
854: CURSOR c IS
855: SELECT '1'
856: FROM psb_set_relations_v
857: WHERE account_or_position_type = p_account_or_position_type
858: AND DECODE( p_entity_type,
859: 'AR', allocation_rule_id,
860: 'BG', budget_group_id,

Line 879: FROM psb_set_relations_v

875:
876: /* Bug No 2131841 Start */
877: CURSOR c1 IS
878: SELECT '1'
879: FROM psb_set_relations_v
880: WHERE account_or_position_type = p_account_or_position_type
881: AND DECODE( p_entity_type,
882: 'AR', allocation_rule_id,
883: 'BG', budget_group_id,