APPS.AP_WEB_CC_VALIDATION_WF_PKG dependencies on AP_CARD_EMP_CANDIDATES
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