DBA Data[Home] [Help]

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on GL_CONS_SEGMENT_MAP

Line 4104: ,gl_cons_segment_map cm

4100: BEGIN
4101:
4102: SELECT count(distinct parent_flex_value) into l_cnt
4103: FROM gl_coa_mappings C
4104: ,gl_cons_segment_map cm
4105: ,gl_cons_flex_hierarchies ch
4106: WHERE c.coa_mapping_id = g_coa_mapping_id
4107: AND cm.coa_mapping_id = c.coa_mapping_id
4108: AND cm.segment_map_type = 'R' --Detail Rollup Ranges

Line 4136: ,gl_cons_segment_map cm

4132: BEGIN
4133: SELECT parent_flex_value into l_referential_account
4134: FROM (SELECT ch.parent_flex_value
4135: FROM gl_coa_mappings C
4136: ,gl_cons_segment_map cm
4137: ,gl_cons_flex_hierarchies ch
4138: WHERE c.coa_mapping_id = g_coa_mapping_id
4139: AND cm.coa_mapping_id = c.coa_mapping_id
4140: AND cm.segment_map_type = 'R' --Detail Rollup Ranges