628: ) THEN
629: -- Get template application id
630: SELECT APP.APPLICATION_ID
631: INTO l_template_appl
632: FROM FND_APPLICATION_VL APP,
633: FND_CONCURRENT_PROGRAMS FCP,
634: FND_CONCURRENT_REQUESTS R
635: WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
636: AND R.REQUEST_ID = l_fsg_request_id