DBA Data[Home] [Help]

APPS.GCS_PERIOD_INIT_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 535: FROM gcs_cons_eng_run_dtls gcerd,

531: count(decode(gcb.net_to_re_flag, 'N', null, gcerd.entry_id)),
532: count(decode(gcb.net_to_re_flag, 'N', null, gcerd.stat_entry_id)),
533: min(gcb.net_to_re_flag)
534: BULK COLLECT INTO g_entry_info
535: FROM gcs_cons_eng_run_dtls gcerd,
536: gcs_categories_b gcb
537: WHERE gcerd.run_name = p_run_name
538: AND gcerd.consolidation_entity_id = p_cons_entity_id
539: AND gcerd.child_entity_id IS NOT NULL

Line 552: FROM gcs_cons_eng_run_dtls gcerd,

548: count(decode(gcb.net_to_re_flag, 'N', null, gcerd.entry_id)),
549: count(decode(gcb.net_to_re_flag, 'N', null, gcerd.stat_entry_id)),
550: min(gcb.net_to_re_flag)
551: BULK COLLECT INTO g_entry_info
552: FROM gcs_cons_eng_run_dtls gcerd,
553: gcs_categories_b gcb
554: WHERE gcerd.run_name = p_run_name
555: AND gcerd.consolidation_entity_id = p_cons_entity_id
556: AND gcerd.child_entity_id = p_entity_id