APPS.AP_APXCCPUT_XMLP_PKG SQL Statements

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

Line: 25

      SELECT  NAME
      INTO    c_organization_name
      FROM    HR_OPERATING_UNITS
      WHERE   ORGANIZATION_ID = p_org_id;

Line: 116

   SELECT  ly.meaning,
           ln.meaning,
           la.displayed_field
   INTO    nls_yes,  nls_no,  nls_all
   FROM    fnd_lookups ly,  fnd_lookups ln,  ap_lookup_codes la
   WHERE   ly.lookup_type = 'YES_NO'
     AND   ly.lookup_code = 'Y'
     AND   ln.lookup_type = 'YES_NO'
     AND   ln.lookup_code = 'N'
     AND   la.lookup_type = 'NLS REPORT PARAMETER'
     AND   la.lookup_code = 'ALL';

Line: 209

                update ap_credit_card_trxns
                set CATEGORY = 'DEACTIVATED',
                    REPORT_HEADER_ID =  -1,
                    LAST_UPDATE_DATE = sysdate,
                    LAST_UPDATED_BY = l_user_id
                WHERE REPORT_HEADER_ID IS NULL
                AND CATEGORY IS NULL
                AND ORG_ID = NVL(p_org_id, ORG_ID)
                AND TRANSACTION_AMOUNT = NVL(p_amount, TRANSACTION_AMOUNT)
                AND POSTED_DATE between  (nvl(p_start_date, POSTED_DATE-1))
                          and p_end_date
                AND CARD_ID = NVL(p_card_number, CARD_ID)
                AND INACTIVE_EMP_WF_ITEM_KEY is NULL;

Line: 226

                update ap_credit_card_trxns
                set CATEGORY = NULL,
                    REPORT_HEADER_ID =  NULL,
                    LAST_UPDATE_DATE = sysdate,
                    LAST_UPDATED_BY = l_user_id
                WHERE REPORT_HEADER_ID = -1
                AND CATEGORY = 'DEACTIVATED'
                AND ORG_ID = NVL(p_org_id, ORG_ID)
                AND TRANSACTION_AMOUNT = NVL(p_amount, TRANSACTION_AMOUNT)
                AND POSTED_DATE between  (nvl(p_start_date, POSTED_DATE-1))
                          and p_end_date
                AND CARD_ID = NVL(p_card_number, CARD_ID)
                AND INACTIVE_EMP_WF_ITEM_KEY is NULL;

Line: 253

select distinct card.employee_id, card.card_program_id
from   ap_credit_card_trxns txn,
       ap_cards card
where  txn.report_header_id = -1
and    txn.category = 'DEACTIVATED'
and    txn.org_id = nvl(p_org_id, txn.org_id)
and    txn.card_id = nvl(p_card_number, txn.card_id)
and    txn.transaction_amount = nvl(p_amount, txn.transaction_amount)
and    txn.posted_date between  (nvl(p_start_date, txn.posted_date-1))
           and p_end_date
and    txn.card_program_id = card.card_program_id
and    txn.card_id = card.card_id
and    card.org_id = nvl(p_org_id, card.org_id)
and    txn.org_id  = card.org_id;