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_WS_ACCT1

Line 1672: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id

1668: --
1669: -- Get budget calendar related info to find whether the review groups is
1670: -- active in the current budget group hierarchy or not.
1671: --
1672: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
1673: THEN
1674: --
1675: PSB_WS_Acct1.Cache_Budget_Calendar
1676: (

Line 1675: PSB_WS_Acct1.Cache_Budget_Calendar

1671: --
1672: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
1673: THEN
1674: --
1675: PSB_WS_Acct1.Cache_Budget_Calendar
1676: (
1677: p_return_status => l_return_status ,
1678: p_budget_calendar_id => l_budget_calendar_id
1679: );

Line 1703: AND bg.effective_start_date <= PSB_WS_Acct1.g_startdate_pp

1699: WHERE cats.budget_group_id = l_budget_group_id
1700: AND rules.budget_group_id = l_root_budget_group_id
1701: AND rules.stage_id = cats.stage_id
1702: AND bg.budget_group_id = rules.review_budget_group_id
1703: AND bg.effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1704: AND ( ( bg.effective_end_date IS NULL)
1705: OR
1706: ( bg.effective_end_date >= PSB_WS_Acct1.g_enddate_cy )
1707: ) ;

Line 1706: ( bg.effective_end_date >= PSB_WS_Acct1.g_enddate_cy )

1702: AND bg.budget_group_id = rules.review_budget_group_id
1703: AND bg.effective_start_date <= PSB_WS_Acct1.g_startdate_pp
1704: AND ( ( bg.effective_end_date IS NULL)
1705: OR
1706: ( bg.effective_end_date >= PSB_WS_Acct1.g_enddate_cy )
1707: ) ;
1708:
1709: --
1710: -- Count total number of review groups to set the Loop Counter Activity.

Line 2822: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id

2818: --
2819: -- Get budget calendar related info to find whether the review groups is
2820: -- active in the current budget group hierarchy or not.
2821: --
2822: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
2823: THEN
2824: --
2825: PSB_WS_Acct1.Cache_Budget_Calendar
2826: (

Line 2825: PSB_WS_Acct1.Cache_Budget_Calendar

2821: --
2822: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
2823: THEN
2824: --
2825: PSB_WS_Acct1.Cache_Budget_Calendar
2826: (
2827: p_return_status => l_return_status ,
2828: p_budget_calendar_id => l_budget_calendar_id
2829: );

Line 2857: AND bg.effective_start_date <= PSB_WS_Acct1.g_startdate_pp

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
2858: AND (( bg.effective_end_date IS NULL)
2859: OR( bg.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))
2860: AND rules.stage_id = cats.stage_id
2861: AND relations.budget_workflow_rule_id = rules.budget_workflow_rule_id

Line 2859: OR( bg.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))

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
2858: AND (( bg.effective_end_date IS NULL)
2859: OR( bg.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))
2860: AND rules.stage_id = cats.stage_id
2861: AND relations.budget_workflow_rule_id = rules.budget_workflow_rule_id
2862: AND relations.account_position_set_id = ba.account_position_set_id
2863: AND EXISTS

Line 2906: AND bg.effective_start_date <= PSB_WS_Acct1.g_startdate_pp

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
2907: AND (( bg.effective_end_date IS NULL)
2908: OR( bg.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))
2909: AND rules.stage_id = cats.stage_id
2910: AND relations.budget_workflow_rule_id = rules.budget_workflow_rule_id

Line 2908: OR( bg.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))

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
2907: AND (( bg.effective_end_date IS NULL)
2908: OR( bg.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))
2909: AND rules.stage_id = cats.stage_id
2910: AND relations.budget_workflow_rule_id = rules.budget_workflow_rule_id
2911: AND relations.account_position_set_id = bp.account_position_set_id
2912: AND EXISTS

Line 2947: AND bgrp.effective_start_date <= PSB_WS_Acct1.g_startdate_pp

2943: WHERE cats.budget_group_id = l_budget_group_id
2944: AND rules.stage_id = cats.stage_id
2945: AND rules.budget_group_id = l_root_budget_group_id
2946: AND bgrp.budget_group_id = rules.review_budget_group_id
2947: AND bgrp.effective_start_date <= PSB_WS_Acct1.g_startdate_pp
2948: AND (( bgrp.effective_end_date IS NULL )
2949: OR( bgrp.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))
2950: AND EXISTS
2951: (SELECT 1

Line 2949: OR( bgrp.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))

2945: AND rules.budget_group_id = l_root_budget_group_id
2946: AND bgrp.budget_group_id = rules.review_budget_group_id
2947: AND bgrp.effective_start_date <= PSB_WS_Acct1.g_startdate_pp
2948: AND (( bgrp.effective_end_date IS NULL )
2949: OR( bgrp.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))
2950: AND EXISTS
2951: (SELECT 1
2952: FROM PSB_POSITIONS ppos,
2953: PSB_WS_LINES_POSITIONS lines,