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 645: v_SelectSQL := 'select user_je_source_name from gl_je_sources ' ||

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

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

662: ' AND user_je_source_name = :s_name';
663: EXECUTE IMMEDIATE v_UpdateSQL USING group_id, ledger_id, pd_name,
664: actual_flag, l_user_je_source_name;
665: ELSE
666: v_SelectSQL := 'select user_je_source_name from gl_je_sources ' ||
667: 'WHERE je_source_name = :s_name';
668: EXECUTE IMMEDIATE v_SelectSQL INTO l_user_je_source_name USING l_je_source;
669: gl_journal_import_pkg.populate_interface_control(
670: --+ 'Consolidation',