APPS.AP_WEB_CC_VALIDATION_WF_PKG dependencies on AP_CARDS_ALL

Line 273: from ap_card_details det, ap_cards_all card

269: l_stmt varchar2(200);
270:
271: cursor ccard is
272: select det.card_id -- , det.name, det.employee_number, det.national_identifier
273: from ap_card_details det, ap_cards_all card
274: where det.card_id = card.card_id
275: and card.request_id = l_request_id;
276: begin
277: if ( funcmode = 'RUN' ) then

Line 330: from ap_cards_all ca, ap_card_details c, ap_card_emp_candidates emp

326: l_card_program_id number;
327:
328: cursor cemp is
329: select c.card_id, max(emp.employee_id) as employee_id
330: from ap_cards_all ca, ap_card_details c, ap_card_emp_candidates emp
331: where c.card_id = emp.card_id
332: and ca.card_id = c.card_id
333: and ca.request_id = l_request_id
334: group by c.card_id

Line 380: where exists (select 1 from ap_cards_all where request_id = l_request_id);

376: begin
377: if ( funcmode = 'RUN' ) then
378: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
379: select count(*) into l_exist from dual
380: where exists (select 1 from ap_cards_all where request_id = l_request_id);
381:
382: if l_exist = 0 then
383: resultout := 'COMPLETE:F';
384: else

Line 422: where exists (select 1 from ap_cards_all where request_id = l_request_id and employee_id is null);

418: begin
419: if ( funcmode = 'RUN' ) then
420: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
421: select count(*) into l_exist from dual
422: where exists (select 1 from ap_cards_all where request_id = l_request_id and employee_id is null);
423:
424: if l_exist = 0 then
425: resultout := 'COMPLETE:F';
426: else

Line 522: from ap_cards_all

518: begin
519: if ( funcmode = 'RUN' ) then
520: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
521: select count(*) into l_count
522: from ap_cards_all
523: where request_id = l_request_id;
524:
525: wf_engine.setitemattrnumber(itemtype,itemkey,'NEW_CARD_COUNT',l_count);
526: