APPS.AP_WEB_EMP_NUM_MATCH_PKG SQL Statements

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

Line: 9

  CURSOR ccard IS SELECT employee_number
                  FROM ap_card_details
                  WHERE card_id = p_card_id
                  AND EMPLOYEE_NUMBER IS NOT NULL;

Line: 31

    INSERT INTO ap_card_emp_candidates(card_id, employee_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
    SELECT card.card_id,
         pap.person_id,
         fnd_global.user_id,
         trunc(sysdate),
         fnd_global.user_id,
         trunc(sysdate),
         fnd_global.login_id
    FROM PER_ALL_PEOPLE_F pap, FINANCIALS_SYSTEM_PARAMS_ALL fsp, PER_PERSON_TYPES ppt, AP_CARDS_ALL card
    WHERE
        card.CARD_ID = p_card_id
    AND card.ORG_ID = fsp.ORG_ID
    AND TRUNC(sysdate) BETWEEN pap.effective_start_date AND pap.effective_end_date
    AND pap.business_group_id = fsp.business_group_id
    AND pap.business_group_id = ppt.business_group_id
    AND UPPER(ppt.user_person_type) <> 'CONTACT'
    AND pap.person_type_id = ppt.person_type_id
    AND EMPLOYEE_NUMBER = p_employee_number
   ;