APPS.PA_DATE_RANGE_PKG dependencies on PA_PERIOD_MASKS_B

Line 231: cursor get_period_mask_id_csr(c_time_phased_code pa_period_masks_b.time_phase_code%TYPE)

227:
228:
229: -- Bug 3804286, 12-AUG-03, jwhite ---------------------------------------------------------
230:
231: cursor get_period_mask_id_csr(c_time_phased_code pa_period_masks_b.time_phase_code%TYPE)
232: is
233: select period_mask_id
234: from pa_period_masks_b
235: where pre_defined_flag='Y'

Line 234: from pa_period_masks_b

230:
231: cursor get_period_mask_id_csr(c_time_phased_code pa_period_masks_b.time_phase_code%TYPE)
232: is
233: select period_mask_id
234: from pa_period_masks_b
235: where pre_defined_flag='Y'
236: and time_phase_code = c_time_phased_code;
237:
238: -- End Bug 3804286, 12-AUG-03, jwhite ------------------------------------------------------

Line 289: l_period_mask_id pa_period_masks_b.period_mask_id%type;

285:
286: l_project_start_date pa_projects_all.start_date%TYPE := NULL;
287: l_org_id pa_projects_all.org_id%TYPE := NULL;
288:
289: l_period_mask_id pa_period_masks_b.period_mask_id%type;
290: l_curr_plan_period pa_budget_versions.current_planning_period%type;
291: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
292: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
293: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;