APPS.AR_ARXAPRCL_XMLP_PKG SQL Statements

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

Line: 11

    SELECT substr(cp.user_concurrent_program_name, 1, 80)
    INTO   l_report_name
    FROM   FND_CONCURRENT_PROGRAMS_VL cp,
           FND_CONCURRENT_REQUESTS cr
    WHERE  cr.request_id = P_CONC_REQUEST_ID
    AND    cp.application_id = cr.program_application_id
    AND    cp.concurrent_program_id = cr.concurrent_program_id;

Line: 105

 SELECT lc.meaning
 INTO   l_sort_by
 FROM   AR_LOOKUPS lc
 WHERE  lc.lookup_type = 'SORT_BY_ARXAPRCL'
 AND    lc.lookup_code = P_SORT_BY;

Line: 124

 SELECT meaning
 INTO   l_remit_method
 FROM   AR_LOOKUPS
 WHERE  lookup_type = 'REMITTANCE_METHOD'
 AND    lookup_code = P_REMIT_METHOD;

Line: 142

 SELECT CBA.BANK_ACCOUNT_NAME,
        BB.BANK_NAME
 INTO   l_account_name,RP_BANK_NAME
 FROM   CE_BANK_ACCOUNTS CBA,
        CE_BANK_ACCT_USES BA,
        CE_BANK_BRANCHES_V BB
 WHERE  BA.BANK_ACCT_USE_ID = P_REMIT_ACCOUNT
 AND    CBA.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID
 AND    CBA.BANK_BRANCH_ID = BB.BRANCH_PARTY_ID;