APPS.AP_WEB_CC_VALIDATION_WF_PKG dependencies on AP_CARD_DETAILS

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