APPS.AMW_LOAD_SOD_DATA dependencies on FND_APPLICATION_VL

Line 1589: FND_APPLICATION_VL APPL

1585: BULK COLLECT INTO l_appl_id_list,
1586: l_appl_name_list,
1587: l_resp_name_list
1588: FROM FND_RESPONSIBILITY_VL RESP,
1589: FND_APPLICATION_VL APPL
1590: WHERE RESP.RESPONSIBILITY_ID = l_resp_id_list(i)
1591: AND RESP.START_DATE <= SYSDATE
1592: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)
1593: AND RESP.APPLICATION_ID=APPL.APPLICATION_ID;

Line 1653: FND_APPLICATION_VL APPL

1649: BULK COLLECT INTO l_appl_id_list,
1650: l_appl_name_list,
1651: l_resp_name_list
1652: FROM FND_RESPONSIBILITY_VL RESP,
1653: FND_APPLICATION_VL APPL
1654: WHERE RESP.RESPONSIBILITY_ID = l_function_id_list(i)
1655: AND RESP.START_DATE <= SYSDATE
1656: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)
1657: AND RESP.APPLICATION_ID=APPL.APPLICATION_ID

Line 1685: FND_APPLICATION_VL appl

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'
1689: ORDER BY APPLICATION_ID;

Line 1750: FND_APPLICATION_VL appl

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';
1754:

Line 1804: FND_APPLICATION_VL appl

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';
1808:

Line 1864: FND_APPLICATION_VL APPL

1860: BULK COLLECT INTO l_appl_id_list,
1861: l_appl_name_list,
1862: l_resp_name_list
1863: FROM FND_RESPONSIBILITY_VL RESP,
1864: FND_APPLICATION_VL APPL
1865: WHERE RESP.RESPONSIBILITY_ID = l_resp_id_list(i)
1866: AND RESP.START_DATE <= SYSDATE
1867: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)
1868: AND RESP.APPLICATION_ID=APPL.APPLICATION_ID