DBA Data[Home] [Help]

APPS.GMF_ALLOC_PROC dependencies on GMF_PERIOD_STATUSES

Line 169: FROM gmf_period_statuses

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;

Line 373: FROM gmf_period_statuses gps,

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;