APPS.GMF_ALLOC_PROC dependencies on GMF_PERIOD_STATUSES

Line 186: FROM gmf_period_statuses

182: BEGIN
183: IF (p_calendar_code IS NOT NULL AND p_period_code IS NOT NULL) THEN
184: SELECT period_id
185: INTO g_period_id
186: FROM gmf_period_statuses
187: WHERE legal_entity_id = p_legal_entity_id
188: AND calendar_code = p_calendar_code
189: AND period_code = p_period_code
190: AND cost_type_id = p_cost_type_id;

Line 503: FROM gmf_period_statuses gps,

499: FUNCTION get_legal_entity_details RETURN NUMBER IS
500: CURSOR Cur_get_le(p_period_id NUMBER) IS
501: SELECT gps.legal_entity_id,
502: xep.name
503: FROM gmf_period_statuses gps,
504: xle_entity_profiles xep
505: WHERE gps.period_id = p_period_id
506: AND gps.legal_entity_id = xep.legal_entity_id
507: AND gps.delete_mark = 0;