APPS.AP_WEB_CC_NOTIFICATIONS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 277

  select count(*), sum(decode(employee_id, null, 1, 0)), sum(decode(employee_id, null, 0, 1))
  into l_new_count, l_registered_count, l_active_count
  from ap_cards_all
  where request_id = l_request_id;

Line: 282

  select count(*) into l_inactive_count from ap_cards_all c
  where request_id = l_request_id
  and employee_id is null
  and 1 = (select count(*) from ap_card_emp_candidates e
            where e.card_id = c.card_id);

Line: 352

    select lookup_code, displayed_field
    from ap_lookup_codes
    where lookup_type = 'OIE_CC_VALIDATION_ERROR'
    and lookup_code not in ('INVALID_ALL' );

Line: 378

    SELECT COUNT(*) INTO valcnt
    FROM AP_CREDIT_CARD_TRXNS_ALL
    WHERE request_id = l_request_id
    AND validate_code = cvalrec.lookup_code;

Line: 424

   select count(*) into l_inactive_count from ap_cards_all c
   where request_id = l_request_id
   and employee_id is null
   and 1 = (select count(*) from ap_card_emp_candidates e
            where e.card_id = c.card_id);