DBA Data[Home] [Help]

APPS.GL_ACCOUNTS_MAP_GRP dependencies on GL_ACCTS_MAP_BSV_GT

Line 1565: UPDATE GL_ACCTS_MAP_BSV_GT

1561: p_debug IN BOOLEAN) IS
1562: l_rollup_stmt VARCHAR2(2000);
1563: BEGIN
1564: IF p_mapping_rule = 'S' THEN
1565: UPDATE GL_ACCTS_MAP_BSV_GT
1566: SET target_bsv = p_single_value;
1567: ELSIF p_mapping_rule = 'C' THEN
1568: UPDATE GL_ACCTS_MAP_BSV_GT
1569: SET target_bsv = source_bsv;

Line 1568: UPDATE GL_ACCTS_MAP_BSV_GT

1564: IF p_mapping_rule = 'S' THEN
1565: UPDATE GL_ACCTS_MAP_BSV_GT
1566: SET target_bsv = p_single_value;
1567: ELSIF p_mapping_rule = 'C' THEN
1568: UPDATE GL_ACCTS_MAP_BSV_GT
1569: SET target_bsv = source_bsv;
1570: ELSE -- mapping rule is a rollup
1571: EXECUTE IMMEDIATE
1572: 'UPDATE GL_ACCTS_MAP_BSV_GT bm ' ||

Line 1572: 'UPDATE GL_ACCTS_MAP_BSV_GT bm ' ||

1568: UPDATE GL_ACCTS_MAP_BSV_GT
1569: SET target_bsv = source_bsv;
1570: ELSE -- mapping rule is a rollup
1571: EXECUTE IMMEDIATE
1572: 'UPDATE GL_ACCTS_MAP_BSV_GT bm ' ||
1573: 'SET target_bsv = ' ||
1574: '(SELECT ami.target_flex_value ' ||
1575: 'FROM GL_ACCTS_MAP_SEG' || substr(p_to_segment,8,2) || '_GT ami ' ||
1576: 'WHERE ami.source_flex_value = bm.source_bsv)';