APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on AP_AUD_WORKLOADS

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

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

Line 337: ap_aud_workloads w

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

Line 520: l_current_workload_percent AP_AUD_WORKLOADS.WORKLOAD_PERCENT%TYPE;

516:
517: l_current_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
518: l_current_workload NUMBER;
519: l_current_adjusted_workload NUMBER;
520: l_current_workload_percent AP_AUD_WORKLOADS.WORKLOAD_PERCENT%TYPE;
521: -- temporary scratchpad variable
522: l_num NUMBER;
523: l_parent_auditor_id NUMBER;
524: BEGIN