APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on AP_AUD_WORKLOADS

Line 306: | current entry in ap_aud_workloads for auditor_id. It should

302: | PUBLIC PROCEDURE open_load_cur
303: |
304: | DESCRIPTION
305: | This procedure opens cursor containing the open cursor for the
306: | current entry in ap_aud_workloads for auditor_id. It should
307: | return at most 1 row.
308: |
309: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
310: |

Line 334: ap_aud_workloads w

330: w.workload_percent
331: FROM
332: ap_aud_auditors a,
333: ap_aud_queue_summaries_v s,
334: ap_aud_workloads w
335: WHERE a.auditor_id = p_auditor_id
336: AND a.auditor_id = s.auditor_id(+)
337: AND a.auditor_id = w.auditor_id
338: AND w.start_date <= sysdate

Line 502: l_current_workload_percent AP_AUD_WORKLOADS.WORKLOAD_PERCENT%TYPE;

498:
499: l_current_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
500: l_current_workload NUMBER;
501: l_current_adjusted_workload NUMBER;
502: l_current_workload_percent AP_AUD_WORKLOADS.WORKLOAD_PERCENT%TYPE;
503: -- temporary scratchpad variable
504: l_num NUMBER;
505: l_parent_auditor_id NUMBER;
506: BEGIN