APPS.AMW_LOAD_SOD_DATA dependencies on FND_CONCURRENT_PROGRAMS

Line 61: fnd_concurrent_programs cpv

57: AND NOT EXISTS
58: (
59: SELECT 'Y'
60: FROM fnd_request_group_units rgu ,
61: fnd_concurrent_programs cpv
62: WHERE rgu.request_unit_type = 'P'
63: AND rgu.request_unit_id = cpv.concurrent_program_id
64: AND cpv.enabled_flag = 'Y'
65: AND cpv.concurrent_program_id =cst_entries_function_id

Line 1493: FROM FND_CONCURRENT_PROGRAMS conc

1489: AND (acv.END_DATE IS NULL OR acv.END_DATE>=SYSDATE)
1490: AND acv.CONSTRAINT_REV_ID=ace.CONSTRAINT_REV_ID
1491: AND ace.OBJECT_TYPE = 'CP'
1492: AND 1 < ( SELECT COUNT(1)
1493: FROM FND_CONCURRENT_PROGRAMS conc
1494: WHERE conc.CONCURRENT_PROGRAM_ID=ace.FUNCTION_ID
1495: AND ENABLED_FLAG='Y');
1496:
1497:

Line 1514: FROM FND_CONCURRENT_PROGRAMS conc

1510: AND avu.USER_VIOLATION_ID=avue.USER_VIOLATION_ID
1511: AND avue.OBJECT_TYPE='CP'
1512: AND av.STATUS_CODE <> 'NA'
1513: AND 1 < ( SELECT COUNT(1)
1514: FROM FND_CONCURRENT_PROGRAMS conc
1515: WHERE conc.CONCURRENT_PROGRAM_ID=avue.FUNCTION_ID
1516: AND ENABLED_FLAG='Y');
1517:
1518: -- Identifies the Constraint whose Responsibility Violation has Concurrent Program

Line 1534: FROM FND_CONCURRENT_PROGRAMS conc

1530: AND avr.RESP_VIOLATION_ID = avre.RESP_VIOLATION_ID
1531: AND avre.OBJECT_TYPE='CP'
1532: AND av.STATUS_CODE <> 'NA'
1533: AND 1 < ( SELECT COUNT(1)
1534: FROM FND_CONCURRENT_PROGRAMS conc
1535: WHERE conc.CONCURRENT_PROGRAM_ID = avre.FUNCTION_ID
1536: AND ENABLED_FLAG='Y');
1537:
1538: -- Identifies the Constraint Responsibility Wiaver

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