[Home] [Help]
208:
209: Select min(nvl(request_priority, profile_priority_number))
210: Into program_priority
211: From Fnd_Concurrent_Programs P,
212: Fnd_Request_Set_Programs S
213: Where S.set_application_id = app_id
214: and S.request_set_id = set_id
215: and P.concurrent_program_id = S.concurrent_program_id
216: and P.application_id = S.program_application_id;