165: BEGIN
166: IF (p_calendar_code IS NOT NULL AND p_period_code IS NOT NULL) THEN
167: SELECT period_id
168: INTO g_period_id
169: FROM gmf_period_statuses
170: WHERE legal_entity_id = p_legal_entity_id
171: AND calendar_code = p_calendar_code
172: AND period_code = p_period_code
173: AND cost_type_id = p_cost_type_id;
369: FUNCTION get_legal_entity_details RETURN NUMBER IS
370: CURSOR Cur_get_le(p_period_id NUMBER) IS
371: SELECT gps.legal_entity_id,
372: xep.name
373: FROM gmf_period_statuses gps,
374: xle_entity_profiles xep
375: WHERE gps.period_id = p_period_id
376: AND gps.legal_entity_id = xep.legal_entity_id
377: AND gps.delete_mark = 0;