APPS.PSB_SUBMIT_WORKSHEET_PVT dependencies on PSB_WF_REVIEW_GROUPS

Line 1688: -- Find review groups for the worksheet and populate psb_wf_review_groups

1684: --
1685: END IF ;
1686:
1687: --
1688: -- Find review groups for the worksheet and populate psb_wf_review_groups
1689: -- table with this information. Consider whether the review_group is
1690: -- active in the current budget group hierarchy. If not, do not select
1691: -- such a budget workflow rule.
1692: --

Line 1693: INSERT INTO psb_wf_review_groups

1689: -- table with this information. Consider whether the review_group is
1690: -- active in the current budget group hierarchy. If not, do not select
1691: -- such a budget workflow rule.
1692: --
1693: INSERT INTO psb_wf_review_groups
1694: ( item_key, budget_workflow_rule_id, sequence )
1695: SELECT itemkey, rules.budget_workflow_rule_id, ROWNUM
1696: FROM psb_budget_group_categories cats ,
1697: psb_budget_workflow_rules rules ,

Line 1886: FROM psb_wf_review_groups wrg ,

1882: INTO
1883: l_budget_workflow_rule_id ,
1884: l_approval_option ,
1885: l_review_budget_group_id
1886: FROM psb_wf_review_groups wrg ,
1887: psb_budget_workflow_rules rules
1888: WHERE item_key = itemkey
1889: AND sequence = l_loop_visited_counter
1890: AND rules.budget_workflow_rule_id = wrg.budget_workflow_rule_id ;