[Home] [Help]
1938: (
1939: SELECT account_position_set_id,
1940: account_or_position_type
1941: FROM psb_budget_workflow_rules rules ,
1942: psb_set_relations relations
1943: WHERE rules.budget_workflow_rule_id = l_budget_workflow_rule_id
1944: AND relations.budget_workflow_rule_id = rules.budget_workflow_rule_id
1945: )
1946: LOOP
2848: (SELECT 1
2849: FROM psb_budget_group_categories cats,
2850: psb_budget_workflow_rules rules,
2851: psb_budget_groups bg,
2852: psb_set_relations relations,
2853: psb_budget_accounts ba
2854: WHERE cats.budget_group_id = l_budget_group_id
2855: AND rules.budget_group_id = l_root_budget_group_id
2856: AND bg.budget_group_id = rules.review_budget_group_id
2897: (SELECT 1
2898: FROM psb_budget_group_categories cats,
2899: psb_budget_workflow_rules rules,
2900: psb_budget_groups bg,
2901: psb_set_relations relations,
2902: psb_budget_positions bp
2903: WHERE cats.budget_group_id = l_budget_group_id
2904: AND rules.budget_group_id = l_root_budget_group_id
2905: AND bg.budget_group_id = rules.review_budget_group_id