DBA Data[Home] [Help]

APPS.FND_OAM_CPCHARTS_COL dependencies on FND_RESPONSIBILITY

Line 293: Fnd_Responsibility_Tl RES,

289: select count(distinct(R.Request_ID)) into ct_pending
290: from Fnd_Concurrent_Programs_vl CP,
291: Fnd_User U,
292: Fnd_Concurrent_Requests R,
293: Fnd_Responsibility_Tl RES,
294: Fnd_Application A,
295: Fnd_amp_requests_v rv,
296: Fnd_lookups l
297: Where rv.phase_code = 'P'

Line 350: Fnd_Responsibility_Tl RES,

346: select count(distinct(R.Request_ID)) into ct_inactive
347: From Fnd_Concurrent_Programs_vl CP,
348: Fnd_User U,
349: Fnd_Concurrent_Requests R,
350: Fnd_Responsibility_Tl RES,
351: Fnd_Application A,
352: Fnd_amp_requests_v rv,
353: Fnd_lookups l
354: Where rv.phase_code = 'P'

Line 716: from fnd_concurrent_requests r, fnd_responsibility_vl v

712: PROCEDURE refresh_running_req_resp
713: IS
714: cursor req_c is
715: select count(*) count, responsibility_name
716: from fnd_concurrent_requests r, fnd_responsibility_vl v
717: where r.responsibility_application_id = v.application_id
718: and r.responsibility_id = v.responsibility_id and status_code = 'R'
719: group by responsibility_name;
720:

Line 1192: from fnd_responsibility

1188: fnd_program.program_exists('OAMCHARTCOL', 'FND') = true then
1189:
1190: select application_id, responsibility_id, responsibility_key
1191: into appl_id, resp_id, resp_key
1192: from fnd_responsibility
1193: where responsibility_key = 'SYSTEM_ADMINISTRATOR';
1194:
1195: select user_id, user_name
1196: into user_id, user_name