APPS.AP_WEB_CC_VALIDATION_WF_PKG dependencies on AP_CARD_EMP_CANDIDATES

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

350: l_card_program_id number;
351:
352: cursor cemp is
353: select c.card_id, max(emp.employee_id) as employee_id
354: from ap_cards_all ca, ap_card_details c, ap_card_emp_candidates emp
355: where c.card_id = emp.card_id
356: and ca.card_id = c.card_id
357: and ca.request_id = l_request_id
358: group by c.card_id