APPS.OTA_TMT_BUS1 SQL Statements

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

Line: 25

        select null
        from OTA_TP_MEASUREMENT_TYPES
        where tp_measurement_code = p_tp_measurement_code
        and   business_group_id   = p_business_group_id;

Line: 95

        select null
        from PER_BUDGETS pb
            ,PER_BUDGET_VERSIONS pbv
            ,PER_BUDGET_ELEMENTS pbe
            ,PER_BUDGET_VALUES   pbva
        where pb.unit                  = p_tp_measurement_code
        and   pb.business_group_id     = p_business_group_id
        and   pb.budget_type_code      = 'OTA_BUDGET'
        and   pb.budget_id             = pbv.budget_id
        and   pbv.budget_version_id    = pbe.budget_version_id
        and   pbe.budget_element_id    = pbva.budget_element_id;

Line: 164

        select null
        from   OTA_TRAINING_PLAN_COSTS
        where  business_group_id      = p_business_group_id
        and    tp_measurement_type_id = p_tp_measurement_type_id;

Line: 264

        select null
        from   PER_BUDGETS pb
              ,PER_BUDGET_VERSIONS pbs
              ,PER_BUDGET_ELEMENTS pbe
        where pb.unit                = p_tp_measurement_code
        and   pb.business_group_id   = p_business_group_id
        and   pb.budget_type_code    = 'OTA_BUDGET'
        and   pb.budget_id           = pbs.budget_id
        and   pbs.budget_version_id  = pbe.budget_version_id;

Line: 436

        select null
        from  OTA_TRAINING_PLAN_COSTS
        where tp_measurement_type_id = p_tp_measurement_type_id
        and   business_group_id      = p_business_group_id;

Line: 532

        select count(pba.budget_value_id)
        from   PER_BUDGETS pb
              ,PER_BUDGET_VERSIONS pbv
              ,PER_BUDGET_ELEMENTS pbe
              ,PER_BUDGET_VALUES   pba
        where pb.unit                = p_tp_measurement_code
        and   pb.business_group_id   = p_business_group_id
        and   pb.budget_id           = pbv.budget_id
        and   pbv.budget_version_id  = pbe.budget_version_id
        and   pbe.budget_element_id  = pba.budget_element_id
        and   pb.budget_type_code    = 'OTA_BUDGET'
        group by pb.budget_id
        having count(pba.budget_value_id) >= 2;

Line: 642

        select null
        from   HR_SUMMARY_ITEM_TYPE_USAGE
        where  item_type_usage_id    = p_item_type_usage_id
        and    business_group_id     = p_business_group_id;

Line: 702

        select null
        from OTA_TRAINING_PLAN_COSTS
        where tp_measurement_type_id = p_tp_measurement_type_id;