APPS.PON_EMD_VALIDATION_PKG SQL Statements

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

Line: 191

      SELECT Max(acr.cash_receipt_id), Max(arp.receivable_application_id)
        INTO x_cash_receipt_id, x_receivable_app_id
        from ar_receivable_applications_all arp,
             ra_customer_trx_all            rct,
             ra_cust_trx_types_all          ctyp,
             ar_cash_receipts_all           acr
       where arp.applied_customer_trx_id = p_trx_id
         AND arp.org_id = p_org_id
         AND arp.status = 'APP'
         AND arp.applied_customer_trx_id = rct.customer_trx_id
         AND arp.org_id = rct.org_id
         AND rct.CUST_TRX_TYPE_ID = ctyp.CUST_TRX_TYPE_ID
         AND rct.org_id = ctyp.org_id
         AND ctyp.type = 'DEP'
         AND arp.cash_receipt_id = acr.cash_receipt_id
         AND arp.amount_applied > 0;

Line: 236

        SELECT acr.receipt_number, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('RECEIPT_CREATION_STATUS',
                                       acrh.STATUS),acrh.STATUS
          INTO x_receipt_num, x_receipt_status,x_receipt_status_code
          FROM ar_cash_Receipt_history_all acrh, ar_cash_receipts_all acr
         WHERE acrh.cash_receipt_id = acr.cash_receipt_id
           AND acrh.current_record_flag = 'Y'
           AND acr.cash_receipt_id = x_cash_receipt_id;

Line: 315

INSERT INTO PON_BIDDING_PARTIES
(
AUCTION_HEADER_ID,
LIST_ID,
SEQUENCE,
TRADING_PARTNER_NAME,
TRADING_PARTNER_ID,
VENDOR_SITE_ID,
VENDOR_SITE_CODE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
ACCESS_TYPE,
FROM_EMD_FLAG
)
VALUES
(
L_AUCTION_HEADER_ID,
L_LIST_ID          ,
L_SEQUENCE         ,
L_TRADING_PARTNER_NAME,
L_TRADING_PARTNER_ID,
-1,
'-1',
SYSDATE,
L_USER_ID,
SYSDATE,
L_USER_ID,
'FULL',
'Y'
);

Line: 362

SELECT PERSON_PARTY_ID INTI INTO L_PARTY_ID FROM FND_USER WHERE USER_ID=P_USER_ID;

Line: 364

SELECT
PERSON_FIRST_NAME,
PERSON_MIDDLE_NAME,
PERSON_LAST_NAME,
PERSON_PRE_NAME_ADJUNCT,
PERSON_NAME_SUFFIX
INTO
L_PERSON_FIRST_NAME,
L_PERSON_MIDDLE_NAME,
L_PERSON_LAST_NAME,
L_PERSON_PRE_NAME_ADJUNCT,
L_PERSON_NAME_SUFFIX
FROM
HZ_PARTIES
WHERE
PARTY_ID=L_PARTY_ID;