DBA Data[Home] [Help]

APPS.PSB_VALIDATE_ACCT_PVT dependencies on PSB_SET_RELATIONS

Line 350: from psb_set_relations_v sr,

346: p_budget_group_id := 0;
347: FOR ba_rec IN
348: (
349: select sr.budget_group_id
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

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 603: psb_set_relations sr

599: pe.allocation_type
600: FROM psb_worksheets w,
601: psb_entity_assignment pea,
602: psb_entity pe,
603: psb_set_relations sr
604: WHERE pe.entity_type = 'ALLOCRULE'
605: AND pea.entity_set_id = w.allocrule_set_id
606: AND pea.entity_id = pe.entity_id
607: AND sr.allocation_rule_id = pea.entity_id