APPS.CSM_HA_EVENT_PKG dependencies on FND_APPLICATION

Line 407: FND_APPLICATION app,

403: */
404: FOR rec IN (SELECT usr.USER_NAME,app.APPLICATION_SHORT_NAME app_name,mapp.HA_RESP_KEY resp_key
405: FROM FND_USER_RESP_GROUPS usr_rsp,
406: CSM_HA_RESP_MAPPINGS mapp,
407: FND_APPLICATION app,
408: FND_USER usr
409: WHERE SYSDATE BETWEEN nvl(usr_rsp.START_DATE,SYSDATE-1) AND nvl(usr_rsp.END_DATE,SYSDATE+1)
410: AND usr_rsp.USER_ID=usr.USER_ID
411: AND usr_rsp.RESPONSIBILITY_ID=mapp.RESPONSIBILITY_ID

Line 452: FROM FND_CONCURRENT_PROGRAMS a, FND_APPLICATION b

448:
449: /*
450: --Choose: Api call or the below direct update
451: FOR rec in (SELECT B.APPLICATION_SHORT_NAME APP_NAME, CONCURRENT_PROGRAM_NAME
452: FROM FND_CONCURRENT_PROGRAMS a, FND_APPLICATION b
453: WHERE (APPLICATION_ID,CONCURRENT_PROGRAM_ID) NOT IN
454: (SELECT APPLICATION_ID,CONCURRENT_PROGRAM_ID FROM CSM_HA_ACTIVE_CONC_DATA)
455: AND APPLICATION_ID NOT IN (0,1) -- non AOL
456: AND a.APPLICATION_ID = b.APPLICATION_ID)

Line 479: FROM CSM_HA_ACTIVE_CONC_DATA a, FND_APPLICATION b

475: SELECT application_id,request_group_id INTO l_app_id,l_grp_id from fnd_request_groups
476: where request_group_name='CSM_HA_REQUEST_GROUP';
477:
478: FOR rec in (SELECT B.APPLICATION_SHORT_NAME APP_NAME, CONCURRENT_PROGRAM_NAME
479: FROM CSM_HA_ACTIVE_CONC_DATA a, FND_APPLICATION b
480: WHERE a.APPLICATION_ID = b.APPLICATION_ID
481: AND a.APPLICATION_ID NOT IN (0,1)
482: AND NOT EXISTS (SELECT 1 FROM FND_REQUEST_GROUP_UNITS
483: WHERE UNIT_APPLICATION_ID=a.APPLICATION_ID