281:
282: select count(*) into l_inactive_count from ap_cards_all c
283: where request_id = l_request_id
284: and employee_id is null
285: and 1 = (select count(*) from ap_card_emp_candidates e
286: where e.card_id = c.card_id);
287:
288: l_unassigned_count := l_registered_count - l_inactive_count;
289:
423: BEGIN
424: select count(*) into l_inactive_count from ap_cards_all c
425: where request_id = l_request_id
426: and employee_id is null
427: and 1 = (select count(*) from ap_card_emp_candidates e
428: where e.card_id = c.card_id);
429: return l_inactive_count;
430:
431: EXCEPTION