575: WHERE
576: h.CALENDAR_ID = NVL(v_calendar_id, -1)
577: and h.PERIOD_TYPE = pv_period_type
578: and h.personal_flag = 'N'
579: and h.hierarchy_usage_code = 'STANDARD'
580: and h.HIERARCHY_OBJ_ID=o.OBJECT_ID
581: and o.folder_id=pv_folder_id ;
582: EXCEPTION
583: WHEN NO_DATA_FOUND THEN
2337: -- 02-02-05 Shintaro Okuda Created
2338: -- 08-29-05 Harikiran Bug 4350620
2339: -- Get the calendar period hierarchy name
2340: -- Arguments
2341: -- x_errbuf Standard Concurrent Program parameter
2342: -- x_retcode Standard Concurrent Program parameter
2343: -- p_cal_rule_obj_def_id Calendar Rule Object Definition ID
2344: -- p_period_set_name Period Set Name
2345: -- p_period_type Period Type
2338: -- 08-29-05 Harikiran Bug 4350620
2339: -- Get the calendar period hierarchy name
2340: -- Arguments
2341: -- x_errbuf Standard Concurrent Program parameter
2342: -- x_retcode Standard Concurrent Program parameter
2343: -- p_cal_rule_obj_def_id Calendar Rule Object Definition ID
2344: -- p_period_set_name Period Set Name
2345: -- p_period_type Period Type
2346: -- p_period_year Period Year