APPS.PSB_WORKFLOW_PVT dependencies on PSB_WS_ACCT1

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

154: --
155: -- Get budget calendar related info to find all the budget groups down in
156: -- the current hierarchy.
157: --
158: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
159: THEN
160: --
161: PSB_WS_Acct1.Cache_Budget_Calendar
162: (

Line 161: PSB_WS_Acct1.Cache_Budget_Calendar

157: --
158: IF NVL(PSB_WS_Acct1.g_budget_calendar_id, -99) <> l_budget_calendar_id
159: THEN
160: --
161: PSB_WS_Acct1.Cache_Budget_Calendar
162: (
163: p_return_status => l_return_status,
164: p_budget_calendar_id => l_budget_calendar_id
165: );

Line 168: FND_MSG_PUB.Add_Exc_Msg( 'PSB_WS_Acct1', 'Cache_Budget_Calendar') ;

164: p_budget_calendar_id => l_budget_calendar_id
165: );
166: --
167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
168: FND_MSG_PUB.Add_Exc_Msg( 'PSB_WS_Acct1', 'Cache_Budget_Calendar') ;
169: RAISE FND_API.G_EXC_ERROR ;
170: END IF ;
171: --
172: END IF ;

Line 257: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp

253: (
254: SELECT budget_group_id, short_name short_name
255: FROM psb_budget_groups
256: WHERE budget_group_type = 'R'
257: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
258: AND ((effective_end_date IS NULL)
259: OR
260: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
261: START WITH budget_group_id = l_budget_groups_rec.budget_group_id

Line 260: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))

256: WHERE budget_group_type = 'R'
257: AND effective_start_date <= PSB_WS_Acct1.g_startdate_pp
258: AND ((effective_end_date IS NULL)
259: OR
260: (effective_end_date >= PSB_WS_Acct1.g_enddate_cy))
261: START WITH budget_group_id = l_budget_groups_rec.budget_group_id
262: CONNECT BY PRIOR budget_group_id = parent_budget_group_id
263: )
264: LOOP