APPS.PSB_ACCOUNT_POSITION_SET_PVT dependencies on PSB_SET_RELATIONS

Line 672: -- Checking the Psb_set_relations table for references.

668: --
669: p_return_status := FND_API.G_RET_STS_SUCCESS ;
670: --
671:
672: -- Checking the Psb_set_relations table for references.
673: OPEN c;
674: FETCH c INTO l_tmp;
675:
676: -- p_Return_Value specifies whether unique value exists or not.

Line 754: FROM psb_set_relations

750: l_freeze_hierarchy_flag VARCHAR2(1);
751: --
752: CURSOR l_check_set_relation_csr IS
753: SELECT '1'
754: FROM psb_set_relations
755: WHERE account_position_set_id = p_account_position_set_id;
756:
757: CURSOR l_check_budget_group_csr IS
758: SELECT '1'

Line 862: FROM psb_set_relations rel,

858: FOR l_budget_group_csr IN
859: (
860: SELECT DECODE( bg.root_budget_group, 'Y', bg.budget_group_id,
861: bg.root_budget_group_id ) as root_budget_group_id
862: FROM psb_set_relations rel,
863: psb_budget_groups bg
864: WHERE rel.account_position_set_id = p_account_position_set_id
865: AND bg.budget_group_type = 'R'
866: AND bg.budget_group_id = rel.budget_group_id

Line 1092: FROM psb_set_relations rels ,

1088:
1089: FOR l_local_sets_rec IN
1090: (
1091: SELECT sets.account_position_set_id
1092: FROM psb_set_relations rels ,
1093: psb_account_position_sets sets
1094: WHERE sets.account_position_set_id = rels.account_position_set_id
1095: AND sets.account_or_position_type = 'P'
1096: AND sets.global_or_local_type = 'L'