APPS.IEX_SCORE_CASE_PVT SQL Statements

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

Line: 29

      SELECT object_id
      FROM IEX_CASE_OBJECTS
      where CAS_ID = nCaseID;

Line: 52

           SELECT SUM (PS.ACCTD_AMOUNT_DUE_REMAINING) AMOUNT
           FROM
           AR_PAYMENT_SCHEDULES PS,
           OKL_CNSLD_AR_STRMS_B ST,
           OKC_K_HEADERS_B KH,
           IEX_CASE_OBJECTS CAO
           WHERE
           PS.CUSTOMER_TRX_ID = ST.RECEIVABLES_INVOICE_ID
           AND KH.ID = ST.KHR_ID
           AND CAO.object_id =KH.ID
           AND CAO.OBJECT_CODE = 'CONTRACTS'
           AND CAO.object_id =KH.ID
           AND CAO.CAS_ID = nCaseId;

Line: 142

        SELECT column_value
          INTO l_CustAccountID
          FROM iex_case_definitions
         WHERE cas_id = p_case_id AND
               column_name = 'CUSTOMER_ACCOUNT';

Line: 218

         select amount into l_AmountOutstanding
           from IEX_BPD_CONTRACT_REMAINING_V
          where contract_id = l_ContractID;

Line: 274

                 select a.score_value
                   into l_LastScore
                   from iex_score_histories a
                  where a.SCORE_OBJECT_ID = p_case_id
                    and a.creation_date = (select max(b.creation_date)
                                             from iex_score_histories b
                                            where b.score_object_id = p_case_id
                                              AND b.score_object_code = 'IEX_CASES');

Line: 311

            select count(1)
              into l_NumPromiseBroken
              from iex_promise_details A, iex_delinquencies B
             where A.DELINQUENCY_ID = B.DELINQUENCY_ID
               and B.CASE_ID = p_case_id
               and A.STATE = 'BROKEN_PROMISE'
               and A.STATUS <> 'PENDING';

Line: 359

                      select count(1)
                        into l_NumDelinquencies
                        from iex_delinquencies
                       where creation_date = sysdate - (s_nConsiderPastXMonths * 30)
                         and cust_account_id = l_CustAccountID
                         and status <> 'PREDELINQUENT';

Line: 433

                    select round(ps.due_date - sysdate) into l_DueInDays
                    from   okc_k_headers_b chr
                           ,okc_rules_b sll
                           ,okc_rules_b slh
                           ,okc_rule_groups_b rg
                           ,OKL_CNSLD_AR_STRMS_B ST
                           ,okl_strm_type_v strm
                           ,AR_PAYMENT_SCHEDULES PS
                    where  chr.id = rg.dnz_chr_id
                    and    sll.rule_information_category = 'SLL'
                    and    sll.object2_id1 = slh.id
                    and    sll.jtot_object1_code = 'OKL_TUOM'
                    and    slh.rule_information_category = 'SLH'
                    and    sll.object1_id1 = 'A'
                    and    nvl(sll.object1_id2,'#') = '#'
                    and    slh.rgp_id = rg.id
                    and    rg.rgd_code = 'LALEVL'
                    and    rg.dnz_chr_id = l_contractID
                    and    rg.dnz_chr_id = st.khr_id
                    and    rg.cle_id = st.kle_id
                    and    strm.id=st.sty_id
                    and    strm.name not like 'CURE'
                    and    st.receivables_invoice_id = ps.customer_trx_id
                    and    ps.due_date between sysdate and sysdate + s_nAnnualPayInXDays
                    and    ps.amount_due_remaining > 0;

Line: 529

      SELECT code, value
        FROM IEX_SCORE_COMP_PARAMS
       WHERE SCORE_COMPONENT_ID = p_Component_id;