APPS.PSB_SUBMIT_WORKSHEET_PVT dependencies on PSB_BUDGET_GROUP_CATEGORIES

Line 1696: FROM psb_budget_group_categories cats ,

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 ,
1698: psb_budget_groups bg
1699: WHERE cats.budget_group_id = l_budget_group_id
1700: AND rules.budget_group_id = l_root_budget_group_id

Line 2849: FROM psb_budget_group_categories cats,

2845: --Also moved the psb_budget_accounts from subquery to main query
2846: SELECT 'Exists' INTO l_exists FROM dual
2847: WHERE EXISTS
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

Line 2898: FROM psb_budget_group_categories cats,

2894:
2895: SELECT 'Exists' INTO l_exists FROM dual
2896: WHERE EXISTS
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

Line 2940: FROM PSB_BUDGET_GROUP_CATEGORIES cats,

2936: SELECT 'Exists' INTO l_exists
2937: FROM DUAL
2938: WHERE EXISTS
2939: (SELECT 1
2940: FROM PSB_BUDGET_GROUP_CATEGORIES cats,
2941: PSB_BUDGET_WORKFLOW_RULES rules,
2942: PSB_BUDGET_GROUPS bgrp
2943: WHERE cats.budget_group_id = l_budget_group_id
2944: AND rules.stage_id = cats.stage_id