276: */
277: FUNCTION get_Period_Id(p_legal_entity_id IN NUMBER, p_calendar_code IN VARCHAR2,
278: p_period_code IN VARCHAR2, p_cost_type_id IN NUMBER) RETURN NUMBER IS
279:
280: l_period_id gmf_period_statuses.period_id%TYPE := -1;
281: BEGIN
282: SELECT period_id INTO l_period_id FROM gmf_period_statuses
283: WHERE legal_entity_id = p_legal_entity_id
284: AND calendar_code = p_calendar_code
278: p_period_code IN VARCHAR2, p_cost_type_id IN NUMBER) RETURN NUMBER IS
279:
280: l_period_id gmf_period_statuses.period_id%TYPE := -1;
281: BEGIN
282: SELECT period_id INTO l_period_id FROM gmf_period_statuses
283: WHERE legal_entity_id = p_legal_entity_id
284: AND calendar_code = p_calendar_code
285: AND period_code = p_period_code
286: AND cost_type_id = p_cost_type_id;