APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_MERGE_SEG_MAPS_GT

Line 444: FROM XLA_MERGE_SEG_MAPS_GT

440: -- Validate only one segment code is provided per application/ledger/COA
441: BEGIN
442: SELECT 'Y'
443: INTO v_dummy
444: FROM XLA_MERGE_SEG_MAPS_GT
445: HAVING COUNT(DISTINCT SEGMENT_CODE) > 1
446: GROUP BY APPLICATION_ID, LEDGER_ID, CHART_OF_ACCOUNTS_ID;
447: EXCEPTION
448: WHEN NO_DATA_FOUND THEN

Line 585: XLA_MERGE_SEG_MAPS_GT gt,

581: FROM DUAL
582: WHERE EXISTS
583: (SELECT 'X'
584: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
585: XLA_MERGE_SEG_MAPS_GT gt,
586: gl_ledgers gld
587: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
588: AND rs.ledger_id = gld.ledger_id
589: AND gld.complete_flag = 'Y'

Line 669: -- Populate the table XLA_MERGE_SEG_MAPS based on XLA_MERGE_SEG_MAPS_GT

665:
666:
667: IF (v_mapping_flag = 'Y')
668: THEN
669: -- Populate the table XLA_MERGE_SEG_MAPS based on XLA_MERGE_SEG_MAPS_GT
670: -- for this current event/associated ledgers
671: trace( p_msg => 'Insert mapping rows'
672: , p_level => C_LEVEL_STATEMENT
673: , p_module => v_module);

Line 695: XLA_MERGE_SEG_MAPS_GT gt,

691: XLA_ENVIRONMENT_PKG.g_login_id,
692: sysdate,
693: XLA_ENVIRONMENT_PKG.g_prog_appl_id
694: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
695: XLA_MERGE_SEG_MAPS_GT gt,
696: GL_LEDGERS gl
697: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
698: AND rs.ledger_id = gl.ledger_id
699: AND gl.complete_flag = 'Y'