APPS.PSB_VALIDATE_ACCT_PVT dependencies on PSB_BUDGET_GROUPS

Line 354: from PSB_BUDGET_GROUPS

350: from psb_set_relations_v sr,
351: psb_budget_accounts ba
352: where sr.budget_group_id in
353: (select budget_group_id
354: from PSB_BUDGET_GROUPS
355: where budget_group_type = 'R'
356: and (p_startdate_pp is null or effective_start_date <= p_startdate_pp)
357: and (effective_end_date is null or effective_end_date >= p_enddate_cy)
358: start with budget_group_id = p_parent_budget_group_id

Line 485: from PSB_BUDGET_GROUPS

481: FROM psb_account_position_sets aps, psb_set_relations sr
482: WHERE sr.account_position_set_id = aps.account_position_set_id
483: and aps.account_or_position_type = 'A'
484: and sr.budget_group_id in (select budget_group_id
485: from PSB_BUDGET_GROUPS
486: where budget_group_type = 'R'
487: and effective_start_date <= p_startdate_pp
488: and (effective_end_date is null or effective_end_date >= p_enddate_cy)
489: start with budget_group_id = p_parent_budget_group_id

Line 541: FROM psb_budget_groups_v

537: -- Get the Root Budget Group for the Budget Group
538: FOR l_bg_rec IN
539: (
540: SELECT nvl(root_budget_group_id, budget_group_id) root_budget_group_id
541: FROM psb_budget_groups_v
542: WHERE budget_group_id = p_parent_budget_group_id
543: )
544: LOOP
545: l_root_budget_group_id := l_bg_rec.root_budget_group_id;

Line 551: FROM psb_account_position_sets aps, psb_budget_groups bg

547:
548: FOR l_set_rec IN
549: (
550: SELECT aps.account_position_set_id, bg.budget_group_id
551: FROM psb_account_position_sets aps, psb_budget_groups bg
552: WHERE bg.budget_group_id = l_root_budget_group_id
553: AND aps.account_position_set_id IN
554: ( bg.ps_account_position_set_id, bg.nps_account_position_set_id)
555: )