eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_SUBMIT_WORKSHEET_PVT dependencies on PSB_BUDGET_POSITIONS

Line 2893: --Also moved the psb_budget_positions from subquery to main query

2889: BEGIN
2890:
2891: /*For Bug No 2115869 Start */
2892: --Fine tuned the following sql by adding the rownum < 2 restriction in sub query
2893: --Also moved the psb_budget_positions from subquery to main query
2894:
2895: SELECT 'Exists' INTO l_exists FROM dual
2896: WHERE EXISTS
2897: (SELECT 1

Line 2902: psb_budget_positions bp

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
2906: AND bg.effective_start_date <= PSB_WS_Acct1.g_startdate_pp