APPS.FII_PROJECT_HOOK SQL Statements

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

Line: 13

  select
    lstg.task_pk
  from
    (
      select
        task_pk,
        denorm_task_org_fk
      from
        edw_proj_task_lstg
      where
        ( task_pk, creation_date ) in
        (
          select
            task_pk              task_pk,
            max(creation_date)   creation_date
          from
            edw_proj_task_lstg
          where
                collection_status = 'READY'
            and edw_record_type   = 'ORACLE'
          group by
            task_pk
        )
    )                   lstg,
    edw_proj_task_ltc   ltc
  where
        ltc.task_pk = lstg.task_pk
    and nvl(ltc.denorm_task_org_fk, 'NULL') <> nvl( lstg.denorm_task_org_fk, 'NULL' );

Line: 47

    insert into fii_system_event_log
    (
      EVENT_TYPE,
      EVENT_ID,
      EVENT_OBJECT,
      ATTRIBUTE1,
      STATUS
    )
    values
    (
      'DNRM:FII_PA_COST_F',
      fii_system_event_log_s.nextval,
      'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK',
      c.task_pk,
      'READY'
    );

Line: 66

    insert into fii_system_event_log
    (
      EVENT_TYPE,
      EVENT_ID,
      EVENT_OBJECT,
      ATTRIBUTE1,
      STATUS
    )
    values
    (
      'DNRM:FII_PA_REVENUE_F',
      fii_system_event_log_s.nextval,
      'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK',
      c.task_pk,
      'READY'
    );

Line: 85

    insert into fii_system_event_log
    (
      EVENT_TYPE,
      EVENT_ID,
      EVENT_OBJECT,
      ATTRIBUTE1,
      STATUS
    )
    values
    (
      'DNRM:FII_PA_BUDGET_F',
      fii_system_event_log_s.nextval,
      'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK',
      c.task_pk,
      'READY'
    );