DBA Data[Home] [Help]

APPS.PSB_VALIDATE_ACCT_PVT dependencies on PSB_ACCOUNT_POSITION_SETS

Line 481: FROM psb_account_position_sets aps, psb_set_relations sr

477: -- Get account position sets for the budget group using set relations
478: FOR l_set_rec IN
479: (
480: SELECT aps.account_position_set_id, sr.budget_group_id
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

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