APPS.GL_CI_REMOTE_INVOKE_PKG dependencies on GL_JE_SOURCES

Line 28: FROM GL_JE_SOURCES

24: IS
25: BEGIN
26: SELECT USER_JE_SOURCE_NAME
27: INTO p_adb_name
28: FROM GL_JE_SOURCES
29: WHERE JE_SOURCE_NAME = 'Average Consolidation';
30:
31: SELECT USER_JE_SOURCE_NAME
32: INTO p_name

Line 33: FROM GL_JE_SOURCES

29: WHERE JE_SOURCE_NAME = 'Average Consolidation';
30:
31: SELECT USER_JE_SOURCE_NAME
32: INTO p_name
33: FROM GL_JE_SOURCES
34: WHERE JE_SOURCE_NAME = 'Consolidation';
35:
36: END Get_Target_Je_source_Name;
37: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 640: v_SelectSQL := 'select user_je_source_name from gl_je_sources ' ||

636: l_je_source := 'Consolidation';
637:
638: l_table_name := 'GL_CONS_INTERFACE_' || group_id;
639: IF avg_flag = 'Y' THEN
640: v_SelectSQL := 'select user_je_source_name from gl_je_sources ' ||
641: 'WHERE je_source_name = :s_name';
642: EXECUTE IMMEDIATE v_SelectSQL INTO l_user_je_source_name USING l_adb_je_source;
643: gl_journal_import_pkg.populate_interface_control(
644: --+ 'Average Consolidation',

Line 661: v_SelectSQL := 'select user_je_source_name from gl_je_sources ' ||

657: ' AND user_je_source_name = :s_name';
658: EXECUTE IMMEDIATE v_UpdateSQL USING group_id, ledger_id, pd_name,
659: actual_flag, l_user_je_source_name;
660: ELSE
661: v_SelectSQL := 'select user_je_source_name from gl_je_sources ' ||
662: 'WHERE je_source_name = :s_name';
663: EXECUTE IMMEDIATE v_SelectSQL INTO l_user_je_source_name USING l_je_source;
664: gl_journal_import_pkg.populate_interface_control(
665: --+ 'Consolidation',