APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_MERGE_SEG_MAPS_GT

Line 442: FROM XLA_MERGE_SEG_MAPS_GT

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

Line 580: XLA_MERGE_SEG_MAPS_GT gt,

576: FROM DUAL
577: WHERE EXISTS
578: (SELECT 'X'
579: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
580: XLA_MERGE_SEG_MAPS_GT gt,
581: gl_ledgers gld
582: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
583: AND rs.ledger_id = gld.ledger_id
584: AND gld.complete_flag = 'Y'

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

658: , p_module => v_module);
659:
660: IF (v_mapping_flag = 'Y')
661: THEN
662: -- Populate the table XLA_MERGE_SEG_MAPS based on XLA_MERGE_SEG_MAPS_GT
663: -- for this current event/associated ledgers
664: trace( p_msg => 'Insert mapping rows'
665: , p_level => C_LEVEL_STATEMENT
666: , p_module => v_module);

Line 688: XLA_MERGE_SEG_MAPS_GT gt,

684: XLA_ENVIRONMENT_PKG.g_login_id,
685: sysdate,
686: XLA_ENVIRONMENT_PKG.g_prog_appl_id
687: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
688: XLA_MERGE_SEG_MAPS_GT gt,
689: GL_LEDGERS gl
690: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
691: AND rs.ledger_id = gl.ledger_id
692: AND gl.complete_flag = 'Y'