APPS.PA_INVOICE_TIEBACK SQL Statements

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

Line: 17

     SELECT dii.acct_amount acct_amt,
            dii.line_num line_num
     FROM   pa_draft_invoice_items dii
     WHERE  dii.project_id    = l_project_id
     AND    dii.draft_invoice_num = l_draft_inv_num;

Line: 30

  Select  sum(tgl.acctd_amount)
     from   ra_cust_trx_line_gl_dist_all tgl,
            ra_customer_trx_lines trx
     where  trx.customer_trx_id = l_cust_trx_id
     and    trim(trx.interface_line_attribute6)
                  = to_char(l_line_num)
     and    rtrim(ltrim(trx.interface_line_attribute1)) = l_project_num
     and    tgl.customer_trx_line_id = trx.customer_trx_line_id
     and    tgl.account_class = 'REV';

Line: 42

        Select sum(tgl.acctd_amount)
    from  ra_cust_trx_line_gl_dist_all tgl,
            ra_customer_trx_lines trx_lines,
            ra_customer_trx trx, ra_batch_sources source
    where  trx_lines.customer_trx_id = trx.customer_trx_id
    and    trx.batch_source_id = source.batch_source_id
    and    trx_lines.interface_line_context = source.name
    and    trx_lines.customer_trx_id = l_cust_trx_id
    and    to_number(trunc(trx_lines.interface_line_attribute6))
            = l_line_num
    and    rtrim(ltrim(trx_lines.interface_line_attribute1)) = l_project_num
    and    tgl.customer_trx_line_id = trx_lines.customer_trx_line_id
    and    tgl.account_class = 'REV';

Line: 57

    Select sum(tgl.acctd_amount)
    from   ra_cust_trx_line_gl_dist_all tgl,
           ra_customer_trx_lines trx
    where  trx.customer_trx_id = l_cust_trx_id
    and    to_number(trunc(trx.interface_line_attribute6))
                 = l_line_num
    and    rtrim(ltrim(trx.interface_line_attribute1)) = l_project_num
    and    tgl.customer_trx_line_id = trx.customer_trx_line_id
    and    tgl.account_class = 'REV';

Line: 76

   SELECT Meaning
   INTO l_error_message
   FROM PA_Lookups
   WHERE Lookup_Type = 'TRANSFER REJECTION CODE'
   AND Lookup_Code = 'EXCHANGE_RATE_CHANGE';

Line: 115

       insert into pa_distribution_warnings
       (
       PROJECT_ID, DRAFT_INVOICE_NUM, LAST_UPDATE_DATE, LAST_UPDATED_BY,
       CREATION_DATE, CREATED_BY, REQUEST_ID, WARNING_MESSAGE
       )
       VALUES
       (
       P_project_id(i), P_draft_inv_num(i), sysdate, P_user_id,
       sysdate, P_user_id, P_request_id, l_error_message
       );