APPS.AP_WEB_CC_NOTIFICATIONS_PKG dependencies on AP_CARDS_ALL

Line 279: from ap_cards_all

275: l_card_program_id := to_number(substr(document_id, colon+1));
276:
277: select count(*), sum(decode(employee_id, null, 1, 0)), sum(decode(employee_id, null, 0, 1))
278: into l_new_count, l_registered_count, l_active_count
279: from ap_cards_all
280: where request_id = l_request_id;
281:
282: select count(*) into l_inactive_count from ap_cards_all c
283: where request_id = l_request_id

Line 282: select count(*) into l_inactive_count from ap_cards_all c

278: into l_new_count, l_registered_count, l_active_count
279: from ap_cards_all
280: where request_id = l_request_id;
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);

Line 424: select count(*) into l_inactive_count from ap_cards_all c

420: FUNCTION GET_INACTIVE_COUNT(l_request_id NUMBER) return NUMBER
421: IS
422: l_inactive_count NUMBER;
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);