APPS.GL_ACCOUNTS_MAP_GRP dependencies on FND_ID_FLEX_SEGMENTS

Line 676: to_app_col_name fnd_id_flex_segments.application_column_name%TYPE;

672: where_rollup_buf_2 VARCHAR2(50) := null;
673:
674: parent_rule_exist VARCHAR2(1) := null;
675:
676: to_app_col_name fnd_id_flex_segments.application_column_name%TYPE;
677: from_app_col_name fnd_id_flex_segments.application_column_name%TYPE;
678:
679: -- this query will return a single row with 'Y' in it if there is segment
680: -- mapping that involves summary accounts

Line 677: from_app_col_name fnd_id_flex_segments.application_column_name%TYPE;

673:
674: parent_rule_exist VARCHAR2(1) := null;
675:
676: to_app_col_name fnd_id_flex_segments.application_column_name%TYPE;
677: from_app_col_name fnd_id_flex_segments.application_column_name%TYPE;
678:
679: -- this query will return a single row with 'Y' in it if there is segment
680: -- mapping that involves summary accounts
681: CURSOR rule_exist IS

Line 710: FROM FND_ID_FLEX_SEGMENTS ffs2,

706: decode(max(map.segment_map_type), 'S', max(map.single_value),
707: NULL)
708: SINGLE_VALUE
709:
710: FROM FND_ID_FLEX_SEGMENTS ffs2,
711: GL_CONS_SEGMENT_MAP map,
712: FND_ID_FLEX_SEGMENTS ffs1
713:
714: WHERE ffs1.application_id = g_application_id

Line 712: FND_ID_FLEX_SEGMENTS ffs1

708: SINGLE_VALUE
709:
710: FROM FND_ID_FLEX_SEGMENTS ffs2,
711: GL_CONS_SEGMENT_MAP map,
712: FND_ID_FLEX_SEGMENTS ffs1
713:
714: WHERE ffs1.application_id = g_application_id
715: AND ffs1.id_flex_code = g_id_flex_code
716: AND ffs1.enabled_flag = 'Y'

Line 741: FROM FND_ID_FLEX_SEGMENTS ffs

737: -- This gets all the source segments that were not involved in the segment
738: -- mappings
739: CURSOR c_unmapped_from_segments IS
740: SELECT ffs.application_column_name UNMAPPED_FROM_SEGMENT
741: FROM FND_ID_FLEX_SEGMENTS ffs
742: WHERE ffs.application_id = g_application_id
743: AND ffs.id_flex_code = g_id_flex_code
744: AND ffs.enabled_flag = 'Y'
745: AND ffs.id_flex_num = from_coa_id

Line 963: app_col_name fnd_id_flex_segments.application_column_name%TYPE;

959: -- number of segments for the source chart of accounts
960: source_nSegments NUMBER;
961:
962: -- for holding the application column name
963: app_col_name fnd_id_flex_segments.application_column_name%TYPE;
964:
965: -- segments in the target chart of accounts
966: CURSOR c_to_segments IS
967: SELECT ffs1.application_column_name TO_APPLICATION_COLUMN_NAME

Line 968: FROM FND_ID_FLEX_SEGMENTS ffs1

964:
965: -- segments in the target chart of accounts
966: CURSOR c_to_segments IS
967: SELECT ffs1.application_column_name TO_APPLICATION_COLUMN_NAME
968: FROM FND_ID_FLEX_SEGMENTS ffs1
969: WHERE ffs1.application_id = g_application_id
970: AND ffs1.id_flex_code = g_id_flex_code
971: AND ffs1.enabled_flag = 'Y'
972: AND ffs1.id_flex_num = to_coa_id

Line 978: FROM FND_ID_FLEX_SEGMENTS ffs1

974:
975: -- segments in the source chart of accounts
976: CURSOR c_from_segments IS
977: SELECT ffs1.application_column_name FROM_APPLICATION_COLUMN_NAME
978: FROM FND_ID_FLEX_SEGMENTS ffs1
979: WHERE ffs1.application_id = g_application_id
980: AND ffs1.id_flex_code = g_id_flex_code
981: AND ffs1.enabled_flag = 'Y'
982: AND ffs1.id_flex_num = from_coa_id

Line 1151: app_col_name fnd_id_flex_segments.application_column_name%TYPE;

1147: -- procedure.
1148: update_2 VARCHAR2(4000);
1149:
1150: -- used for holding the application column name 'SEGMENT'
1151: app_col_name fnd_id_flex_segments.application_column_name%TYPE;
1152:
1153: -- returns the list of segments in the target chart of accounts
1154: CURSOR c_to_segments IS
1155: SELECT ffs1.application_column_name TO_APPLICATION_COLUMN_NAME

Line 1156: FROM FND_ID_FLEX_SEGMENTS ffs1

1152:
1153: -- returns the list of segments in the target chart of accounts
1154: CURSOR c_to_segments IS
1155: SELECT ffs1.application_column_name TO_APPLICATION_COLUMN_NAME
1156: FROM FND_ID_FLEX_SEGMENTS ffs1
1157: WHERE ffs1.application_id = g_application_id
1158: AND ffs1.id_flex_code = g_id_flex_code
1159: AND ffs1.enabled_flag = 'Y'
1160: AND ffs1.id_flex_num = to_coa_id