APPS.GCS_PERIOD_INIT_PKG dependencies on GCS_CATEGORIES_B

Line 89: FROM gcs_categories_b

85: l_query_entity_id := p_entity_id;
86:
87: SELECT target_entity_code
88: INTO l_target_entity_code
89: FROM gcs_categories_b
90: WHERE category_code = p_category_code;
91:
92: IF (l_target_entity_code = 'PARENT') THEN
93: SELECT nvl(decode(dim_attribute_varchar_member, 'E', 'Y', 'N'), 'N')

Line 260: FROM gcs_categories_b

256: --Bugfix 5449718: No longer need to query Net to RE Flag as its available on g_entry_info
257: /*
258: SELECT net_to_re_flag
259: INTO l_net_to_re_flag
260: FROM gcs_categories_b
261: WHERE category_code = l_category_code;
262: */
263: l_net_to_re_flag := g_entry_info(p_cat_index).net_to_re_flag;
264:

Line 536: gcs_categories_b gcb

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
540: AND gcerd.category_code = gcb.category_code

Line 553: gcs_categories_b gcb

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
557: AND gcerd.category_code = gcb.category_code