APPS.IEX_TRX_VIEW_PKG SQL Statements

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

Line: 12

    SELECT '1'
    FROM ar_cash_receipts acr,
         ar_receivable_applications ara
    WHERE ara.applied_payment_schedule_id = p_payment_schedule_id
      AND ara.cash_receipt_id = acr.cash_receipt_id
      AND nvl(acr.confirmed_flag, 'Y') = 'Y'
      AND acr.reversal_date is null
      AND EXISTS
      (SELECT '1'
        FROM ar_cash_receipt_history acrh
       WHERE acr.cash_receipt_id = acrh.cash_receipt_id
         AND ACRH.STATUS NOT IN (DECODE (ACRH.FACTOR_FLAG, 'Y', 'RISK_ELIMINATED', 'N', ' '), 'REVERSED')
         AND ACRH.CURRENT_RECORD_FLAG = 'Y');

Line: 26

    SELECT '1'
    FROM ar_cash_receipts acr,
         ar_receivable_applications ara,
         ar_cash_receipt_history acrh
    WHERE ara.applied_payment_schedule_id = p_payment_schedule_id
    AND ara.cash_receipt_id = acr.cash_receipt_id
    AND acr.cash_receipt_id = acrh.cash_receipt_id
    AND nvl(acr.confirmed_flag, 'Y') = 'Y'
    AND acr.reversal_date is null
    AND acrh.status not in (decode (acrh.factor_flag, 'Y', 'RISK_ELIMINATED',
                                                      'N', ' '), 'REVERSED')
    AND acrh.current_record_flag = 'Y';*/

Line: 58

    select '1'
    from iex_promISe_details
    where delinquency_id = p_delinquency_id
    and status = 'COLLECTABLE';

Line: 79

    select sales_order
	from ra_customer_trx_lines
	where customer_trx_id = p_customer_trx_id
        -- Begin fix bug #5012865-JYPARK-02/01/2006-getting line type to get sales_order
        and line_type = 'LINE'
        -- End fix bug #5012865-JYPARK-02/01/2006-getting line type to get sales_order
	and line_NUMBER = 1;

Line: 97

      SELECT a.score_value
      FROM iex_score_histories a
      WHERE a.creation_date =
            (SELECT MAX(creation_date)
             FROM iex_Score_histories
             WHERE score_object_code = 'IEX_INVOICES'
             AND score_object_id = p_payment_schedule_id)
      AND a.score_object_code = 'IEX_INVOICES'
      AND a.score_object_id = p_payment_schedule_id;

Line: 116

    SELECT str.strategy_id, str.strategy_template_id, str_temp.strategy_name
    FROM iex_strategies str, iex_strategy_templates_vl str_temp
    WHERE str.delinquency_id = p_delinquency_id
    AND str.strategy_template_id = str_temp.strategy_temp_id
    AND str_temp.category_type = 'DELINQUENT';

Line: 134

     select del.party_cust_id
       --from iex_delinquencies_all del
       from iex_delinquencies del
      where del.cust_account_id = in_id;

Line: 169

    SELECT '1'
    FROM ar_cash_receipts acr,
         ar_receivable_applications ara
    WHERE ara.applied_payment_schedule_id = p_payment_schedule_id
      AND ara.cash_receipt_id = acr.cash_receipt_id
      AND nvl(acr.confirmed_flag, 'Y') = 'Y'
      AND acr.reversal_date is null
-- Begin-fix bug #4572737-JYPARK-08/30/2005-exclude unapplied receipt
      AND ara.display = 'Y'
-- End-fix bug #4572737-JYPARK-08/30/2005-exclude unapplied receipt
      AND EXISTS
      (SELECT '1'
        FROM ar_cash_receipt_history acrh
       WHERE acr.cash_receipt_id = acrh.cash_receipt_id
         AND ACRH.STATUS NOT IN (DECODE (ACRH.FACTOR_FLAG, 'Y', 'RISK_ELIMINATED', 'N', ' '), 'REVERSED')
         AND ACRH.CURRENT_RECORD_FLAG = 'Y');

Line: 187

    SELECT '1'
    FROM ar_cash_receipts acr,
         ar_receivable_applications ara,
         ar_cash_receipt_history acrh
    WHERE ara.applied_payment_schedule_id = p_payment_schedule_id
    AND ara.cash_receipt_id = acr.cash_receipt_id
    AND acr.cash_receipt_id = acrh.cash_receipt_id
    AND nvl(acr.confirmed_flag, 'Y') = 'Y'
    AND acr.reversal_date is null
    AND acrh.status not in (decode (acrh.factor_flag, 'Y', 'RISK_ELIMINATED',
                                                      'N', ' '), 'REVERSED')
    AND acrh.current_record_flag = 'Y';*/

Line: 203

    select '1'
    from iex_promise_details
    where delinquency_id = p_delinquency_id
    and status = 'COLLECTABLE';

Line: 209

    select sales_order
	from ra_customer_trx_lines
	where customer_trx_id = p_customer_trx_id
        -- Begin fix bug #5012865-JYPARK-02/01/2006-getting line type to get sales_order
        and line_type = 'LINE'
        -- End fix bug #5012865-JYPARK-02/01/2006-getting line type to get sales_order
	and line_NUMBER = 1;

Line: 218

    SELECT str_temp.strategy_name
    FROM iex_strategies str, iex_strategy_templates_vl str_temp
    WHERE str.delinquency_id = p_delinquency_id
    AND str.strategy_template_id = str_temp.strategy_temp_id
    AND str_temp.category_type = 'DELINQUENT'
    AND str.status_code IN ('OPEN', 'ONHOLD');

Line: 226

      SELECT a.score_value
      FROM iex_score_histories a
      WHERE a.creation_date =
            (SELECT MAX(creation_date)
             FROM iex_Score_histories
             WHERE score_object_code = 'IEX_INVOICES'
             AND score_object_id = p_payment_schedule_id)
      AND a.score_object_code = 'IEX_INVOICES'
      AND a.score_object_id = p_payment_schedule_id;