APPS.JTF_TTY_CAL_METRICS_PVT SQL Statements

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

Line: 63

       INSERT into jtf_tty_acct_metrics
       ( NAMED_ACCT_METRIC_ID
        ,OBJECT_VERSION_NUMBER
        ,NAMED_ACCOUNT_ID
        ,METRIC_LOOKUP_TYPE
        ,METRIC_LOOKUP_CODE
        ,METRIC_VALUE
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN
        ,PROGRAM_ID
        ,PROGRAM_LOGIN_ID
        ,PROGRAM_APPLICATION_ID
        ,REQUEST_ID
       )
       ( select  jtf_tty_acct_metrics_s.nextval,
                 1,
                 na.named_account_id,
                 G_METRIC_TYPE,
                 l_align_metric_code,
                 nvl(hzop.emp_at_primary_adr,0),
                 G_USER_ID,
                 l_sysdate,
                 G_USER_ID,
                 l_sysdate,
                 G_LOGIN_ID,
                 G_PROGRAM_ID,
                 G_CONC_LOGIN_ID,
                 G_APPL_ID,
                 G_REQUEST_ID
            from hz_organization_profiles hzop,
                 jtf_tty_named_accts na
           where hzop.party_id = na.party_id
             and sysdate between hzop.effective_start_date and nvl(hzop.effective_END_date, sysdate)
             and na.party_id = partyList(i)
         );

Line: 103

      print_log('    Inserted ' || SQL%ROWCOUNT || ' rows IN JTF_TTY_ACCT_METRICS ');

Line: 116

        INSERT into jtf_tty_acct_metrics
          ( NAMED_ACCT_METRIC_ID
           ,OBJECT_VERSION_NUMBER
           ,NAMED_ACCOUNT_ID
           ,METRIC_LOOKUP_TYPE
           ,METRIC_LOOKUP_CODE
           ,METRIC_VALUE
           ,CREATED_BY
           ,CREATION_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN
           ,PROGRAM_ID
           ,PROGRAM_LOGIN_ID
           ,PROGRAM_APPLICATION_ID
           ,REQUEST_ID
          )
          ( select  jtf_tty_acct_metrics_s.nextval,
                 1,
                 na.named_account_id,
                 G_METRIC_TYPE,
                 l_align_metric_code,
                 nvl(hfn.financial_number,0),
                 G_USER_ID,
                 l_sysdate,
                 G_USER_ID,
                 l_sysdate,
                 G_LOGIN_ID,
                 G_PROGRAM_ID,
                 G_CONC_LOGIN_ID,
                 G_APPL_ID,
                 G_REQUEST_ID
           from hz_financial_numbers hfn,
                hz_financial_reports hfr,
                jtf_tty_named_accts na
         where hfn.financial_report_id = hfr.financial_report_id
           and hfr.type_of_financial_report = 'INCOME_STATEMENT'
           and hfn.financial_number_name = 'SALES'
           and hfr.party_id = na.party_id
           and hfr.actual_content_source = 'DNB'
           and hfn.actual_content_source = 'DNB'
           and hfr.report_end_date <=  l_sysdate
           and round(months_between (hfr.report_end_date, hfr.report_start_date ))  = 12
           and (  to_char(hfr.report_end_date, 'yyyy')  = to_char(l_sysdate, 'yyyy')  OR
                  to_char(hfr.report_end_date, 'yyyy')  = to_char(l_sysdate, 'yyyy')  - 1
               )
           and hfn.financial_number_currency = 'USD'
           and na.party_id = partyList(i)
         );

Line: 167

      print_log('    Inserted ' || SQL%ROWCOUNT || ' rows IN JTF_TTY_ACCT_METRICS ');

Line: 206

       INSERT into jtf_tty_acct_metrics
       (NAMED_ACCT_METRIC_ID
        ,OBJECT_VERSION_NUMBER
        ,NAMED_ACCOUNT_ID
        ,METRIC_LOOKUP_TYPE
        ,METRIC_LOOKUP_CODE
        ,METRIC_VALUE
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN
        ,PROGRAM_ID
        ,PROGRAM_LOGIN_ID
        ,PROGRAM_APPLICATION_ID
        ,REQUEST_ID
        )
       ( select  jtf_tty_acct_metrics_s.nextval,
                 1,
                 na_list.named_account_id,
                 G_METRIC_TYPE,
                 l_align_metric_code,
                 na_list.prior_sales,
                 G_USER_ID,
                 l_sysdate,
                 G_USER_ID,
                 l_sysdate,
                 G_LOGIN_ID,
                 G_PROGRAM_ID,
                 G_LOGIN_ID,
                 G_APPL_ID,
                 G_REQUEST_ID
           from ( select na.named_account_id,
                         nvl(sum(l.total_amount),0) prior_sales
                    from as_leads_all l,
                         as_statuses_b s,
                         jtf_tty_named_accts na
                   where l.status = s.status_code
                     and s.win_loss_indicator = 'W'
                     and l.decision_date between l_calc_start_date and l_calc_end_date
                     and l.customer_id = na.party_id
                     and na.party_id = partyList(i)
                  group by na.named_account_id
                ) na_list

         );

Line: 253

      print_log('    Inserted ' || SQL%ROWCOUNT || ' rows IN JTF_TTY_ACCT_METRICS ');

Line: 272

   SELECT party_id
     FROM jtf_tty_named_accts;

Line: 313

         delete from JTF_TTY_ACCT_METRICS where metric_lookup_code = p_metric_code;