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_ACCOUNTS

Line 2845: --Also moved the psb_budget_accounts from subquery to main query

2841: BEGIN
2842:
2843: /*For Bug No 2115869 Start */
2844: --Fine tuned the following sql by adding the rownum < 2 restriction in sub query
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,

Line 2853: psb_budget_accounts ba

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