APPS.PSB_ACCOUNT_POSITION_SET_PVT dependencies on PSB_BUDGET_GROUPS

Line 759: FROM psb_budget_groups

755: WHERE account_position_set_id = p_account_position_set_id;
756:
757: CURSOR l_check_budget_group_csr IS
758: SELECT '1'
759: FROM psb_budget_groups
760: WHERE root_budget_group = 'Y'
761: AND budget_group_type = 'R'
762: AND ( ps_account_position_set_id = p_account_position_set_id
763: OR

Line 769: FROM psb_budget_groups

765: ) ;
766:
767: CURSOR l_check_frozen_bg_csr IS
768: SELECT '1'
769: FROM psb_budget_groups
770: WHERE root_budget_group = 'Y'
771: AND budget_group_type = 'R'
772: AND NVL(freeze_hierarchy_flag, 'N') = 'Y'
773: AND ( ps_account_position_set_id = p_account_position_set_id

Line 863: psb_budget_groups bg

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
867: )

Line 871: FROM psb_budget_groups

867: )
868: LOOP
869:
870: SELECT NVL(freeze_hierarchy_flag, 'N') into l_freeze_hierarchy_flag
871: FROM psb_budget_groups
872: WHERE budget_group_id = l_budget_group_csr.root_budget_group_id;
873:
874: -- Check if any referenced budget group is frozen.
875: IF l_freeze_hierarchy_flag = 'Y' THEN