DBA Data[Home] [Help]

APPS.PJI_PMV_DFLT_PARAMS_PVT SQL Statements

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

Line: 61

  SELECT        ORGANIZATION_STRUCTURE_ID,
                ORG_STRUCTURE_VERSION_ID,
                DFLT_PRJPIP_PERIOD_TYPE,
                DFLT_PRJPIP_CYCLE_ID,
                DFLT_PRJBAB_PERIOD_TYPE,
                DFLT_PRJBAB_CYCLE_ID,
                DFLT_RESUTL_PERIOD_TYPE,
                DFLT_RESUTL_CYCLE_ID,
                DFLT_RESAVL_PERIOD_TYPE,
                DFLT_RESAVL_CYCLE_ID,
                DFLT_RESPLN_PERIOD_TYPE,
                DFLT_RESPLN_CYCLE_ID,
                DFLT_PRJHLT_PERIOD_TYPE,
                DFLT_PRJHLT_CYCLE_ID,
                DFLT_PRJACT_PERIOD_TYPE,
                DFLT_PRJACT_CYCLE_ID,
                DFLT_PRJPRF_PERIOD_TYPE,
                DFLT_PRJPRF_CYCLE_ID,
                DFLT_PRJCST_PERIOD_TYPE,
                DFLT_PRJCST_CYCLE_ID
      INTO InitialValues
      FROM PJI_SYSTEM_SETTINGS;
Line: 84

    select  MONTH_ID,
            ENT_PERIOD_ID,
            ENT_QTR_ID,
            ENT_YEAR_ID,
            WEEK_ID
    into    G_Month_ID_Value,
            G_Ent_Period_ID_Value,
            G_Ent_Quarter_ID_Value,
            G_Ent_Year_ID_Value,
            G_Week_ID_Value
    from   fii_time_day
    where report_date = trunc(sysdate);
Line: 176

l_insert_top_org_flag   VARCHAR2(1);
Line: 186

    x_insert_top_org_flag => l_insert_top_org_flag);
Line: 190

	SELECT DISTINCT first_value(ID) over (ORDER BY lvl) into G_Org_ID
	FROM
	    (
		SELECT organization_level  Lvl
		     , organization_id  id
		FROM
		       hri_org_hrchy_summary org_roll
		WHERE org_roll.org_structure_version_id = G_Org_Version_Id
        AND   organization_level - sub_organization_level =0
	    );
Line: 202

	SELECT DISTINCT first_value(ID) over (ORDER BY lvl) into G_Org_ID
	FROM
	    (
		SELECT org_roll.sup_org_absolute_level Lvl
		     , org_list.id id
		     , org_list.value value
		FROM
		       hri_cs_orghro_v org_roll
		     , pji_organizations_v org_list
		WHERE
		org_roll.org_hierarchy_version_id = G_Org_Version_Id
		AND org_roll.sup_organization_id = org_list.id
		AND org_roll.sup_org_absolute_level - org_roll.sub_org_absolute_level = 0
		AND org_roll.subro_sup_org_relative_level = 0
		AND org_roll.subro_sub_org_relative_level = 0
	    );
Line: 238

SELECT  prjpip.ID into G_Period_Type_ID
-- 	,prjbab.value
        FROM
        pji_system_settings syssetting
        , pji_period_types_v prjpip
        , pji_period_types_v prjbab
        WHERE
        prjbab.global_disp_flag = 0
        AND prjpip.global_disp_flag = 0
        AND prjpip.ID='FII_TIME_'||DECODE(G_Period_Type_Code,
				'YEAR','ENT_YEAR',
				'QUARTER','ENT_QTR',
				'MONTH','ENT_PERIOD',
				'WEEK','WEEK')
        AND prjbab.ID='FII_TIME_'||DECODE(G_Period_Type_Code,
				'YEAR','ENT_YEAR',
				'QUARTER','ENT_QTR',
				'MONTH','ENT_PERIOD',
				'WEEK','WEEK');
Line: 266

SELECT  LOOKUP_CODE into G_EntPeriod_ID
        FROM
        pji_lookups
        WHERE LOOKUP_TYPE='PJI_PERIOD_TYPE_LIST'
            AND LOOKUP_CODE='FII_TIME_ENT_PERIOD';
Line: 280

SELECT  LOOKUP_CODE into G_EntWeek_ID
        FROM
        pji_lookups
        WHERE LOOKUP_TYPE='PJI_PERIOD_TYPE_LIST'
            AND LOOKUP_CODE='FII_TIME_WEEK';
Line: 305

select DECODE(G_Period_Type_Code,'WEEK', WEEK_ID
                                ,'MONTH', MONTH_ID
                                ,'PERIOD',ENT_PERIOD_ID
                                ,'QUARTER',ENT_QTR_ID
                                ,'YEAR',ENT_YEAR_ID)

into   G_Period_Id_Value from
       fii_time_day
where report_date = trunc(sysdate);
Line: 356

 select TO_CHAR(seq) into G_Avail_Threshold
     from pji_mt_buckets where bucket_set_code ='PJI_RESOURCE_AVAILABILITY'
     and default_flag='Y';