DBA Data[Home] [Help]

APPS.GMF_CBOM_REP_PKG dependencies on GMF_PERIOD_STATUSES

Line 280: l_period_id gmf_period_statuses.period_id%TYPE := -1;

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

Line 282: SELECT period_id INTO l_period_id FROM gmf_period_statuses

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;