APPS.GCS_CONS_ENG_RUN_DTLS_PKG dependencies on GCS_CATEGORIES_B

Line 362: from gcs_categories_b

358: FROM gcs_cons_eng_run_dtls
359: WHERE run_name = p_prior_run_name
360: AND child_entity_id = p_entity_id
361: AND category_code IN (select category_code
362: from gcs_categories_b
363: where target_entity_code = 'CHILD'
364: and category_type_code <> 'PROCESS');
365: ELSE
366:

Line 371: from gcs_categories_b

367: DELETE FROM gcs_cons_eng_run_dtls
368: WHERE run_name = p_current_run_name
369: AND consolidation_entity_id = p_entity_id
370: AND category_code IN (select category_code
371: from gcs_categories_b
372: where target_entity_code IN ('ELIMINATION', 'PARENT'))
373: AND child_entity_id IS NULL;
374:
375: INSERT INTO gcs_cons_eng_run_dtls

Line 420: from gcs_categories_b

416: FROM gcs_cons_eng_run_dtls
417: WHERE run_name = p_prior_run_name
418: AND consolidation_entity_id = p_entity_id
419: AND category_code IN (select category_code
420: from gcs_categories_b
421: where target_entity_code IN ('ELIMINATION', 'PARENT'));
422: END IF;
423:
424: COMMIT;