DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_UTILS dependencies on PA_PERIOD_MASK_DETAILS

Line 290: FROM pa_period_mask_details

286: IF l_plan_pref_code = 'COST_ONLY' THEN
287:
288: SELECT COUNT(*)
289: INTO l_no_of_periods
290: FROM pa_period_mask_details
291: WHERE period_mask_id = l_cost_period_mask_id
292: AND from_anchor_position not in (99999,-99999);
293: ELSIF l_plan_pref_code = 'REVENUE_ONLY' THEN
294:

Line 297: FROM pa_period_mask_details

293: ELSIF l_plan_pref_code = 'REVENUE_ONLY' THEN
294:
295: SELECT COUNT(*)
296: INTO l_no_of_periods
297: FROM pa_period_mask_details
298: WHERE period_mask_id = l_revenue_period_mask_id
299: AND from_anchor_position not in (99999,-99999);
300: ELSIF l_plan_pref_code = 'COST_AND_REV_SAME' THEN
301:

Line 304: FROM pa_period_mask_details

300: ELSIF l_plan_pref_code = 'COST_AND_REV_SAME' THEN
301:
302: SELECT COUNT(*)
303: INTO l_no_of_periods
304: FROM pa_period_mask_details
305: WHERE period_mask_id = l_all_period_mask_id
306: AND from_anchor_position not in (99999,-99999);
307: END IF;
308: