DBA Data[Home] [Help]

APPS.AMW_LOAD_SOD_DATA dependencies on FND_CONCURRENT_PROGRAMS_VL

Line 1684: FROM FND_CONCURRENT_PROGRAMS_VL conc,

1680: SELECT appl.APPLICATION_ID,appl.APPLICATION_NAME,conc.USER_CONCURRENT_PROGRAM_NAME
1681: BULK COLLECT INTO l_appl_id_list,
1682: l_appl_name_list,
1683: l_cp_name_list
1684: FROM FND_CONCURRENT_PROGRAMS_VL conc,
1685: FND_APPLICATION_VL appl
1686: WHERE conc.CONCURRENT_PROGRAM_ID=l_function_id_list(i)
1687: AND conc.APPLICATION_ID=appl.APPLICATION_ID
1688: AND conc.ENABLED_FLAG='Y'

Line 1749: FROM FND_CONCURRENT_PROGRAMS_VL conc,

1745: SELECT appl.APPLICATION_ID,appl.APPLICATION_NAME,conc.USER_CONCURRENT_PROGRAM_NAME
1746: BULK COLLECT INTO l_appl_id_list,
1747: l_appl_name_list,
1748: l_cp_name_list
1749: FROM FND_CONCURRENT_PROGRAMS_VL conc,
1750: FND_APPLICATION_VL appl
1751: WHERE conc.CONCURRENT_PROGRAM_ID=l_function_id_list(i)
1752: AND conc.APPLICATION_ID=appl.APPLICATION_ID
1753: AND conc.ENABLED_FLAG='Y';

Line 1803: FROM FND_CONCURRENT_PROGRAMS_VL conc,

1799: SELECT appl.APPLICATION_ID,appl.APPLICATION_NAME,conc.USER_CONCURRENT_PROGRAM_NAME
1800: BULK COLLECT INTO l_appl_id_list,
1801: l_appl_name_list,
1802: l_cp_name_list
1803: FROM FND_CONCURRENT_PROGRAMS_VL conc,
1804: FND_APPLICATION_VL appl
1805: WHERE conc.CONCURRENT_PROGRAM_ID=l_function_id_list(i)
1806: AND conc.APPLICATION_ID=appl.APPLICATION_ID
1807: AND conc.ENABLED_FLAG='Y';