APPS.PJI_AUDIT_RPT SQL Statements

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

Line: 40

SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_SET_NAME
INTO l_period_set_name
FROM dual;

Line: 44

SELECT PJI_UTILS.GET_EXTRACTION_START_DATE
INTO l_global_st_date
FROM dual;

Line: 48

SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_TYPE
INTO l_period_type
FROM dual;

Line: 52

SELECT BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE
INTO l_currency_code
FROM dual;

Line: 56

SELECT BIS_COMMON_PARAMETERS.GET_RATE_TYPE
INTO l_rate_type
FROM dual;

Line: 60

SELECT BIS_COMMON_PARAMETERS.GET_START_DAY_OF_WEEK_ID
INTO l_start_dt_of_week
FROM dual;

Line: 65

l_bis_param_name_tbl.DELETE;

Line: 70

	SELECT meaning
	INTO l_period_set_name_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
	and lookup_code = 'BIS_ENT_CAL';

Line: 83

	SELECT meaning
	INTO l_global_st_date_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
	and lookup_code = 'BIS_GLO_ST_DT';

Line: 96

	SELECT meaning
	INTO l_period_type_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
	and lookup_code = 'BIS_PD_TYPE';

Line: 109

	SELECT meaning
	INTO l_currency_code_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
	and lookup_code = 'BIS_PR_CURR';

Line: 122

	SELECT meaning
	INTO l_rate_type_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
	and lookup_code = 'BIS_PR_RATE';

Line: 135

	SELECT meaning
	INTO l_start_dt_of_week_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
	and lookup_code = 'BIS_ST_DT_WK';

Line: 146

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')
	INTO l_all_msg_text
	FROM dual;

Line: 150

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')
	INTO l_param_msg
	FROM dual;

Line: 159

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_BIS_PARAM_TEXT')
	INTO l_bis_msg_text
	FROM dual;

Line: 196

SELECT  organization_structure_id,
	org_structure_version_id
INTO    l_org_structure_id,
	l_org_structure_ver_id
FROM    pji_system_settings;

Line: 203

l_pji_param_name_tbl.DELETE;

Line: 208

	SELECT meaning
	INTO l_org_structure_id_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_PJI_SET_PARAMS'
	and lookup_code = 'ORG_STRUC';

Line: 221

	SELECT meaning
	INTO l_org_structure_ver_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_PJI_SET_PARAMS'
	and lookup_code = 'ORG_ST_VER';

Line: 232

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')
	INTO l_all_msg_text
	FROM dual;

Line: 236

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')
	INTO l_param_msg
	FROM dual;

Line: 245

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJI_PARAM_TEXT')
	INTO l_pji_msg_text
	FROM dual;

Line: 277

SELECT 1
INTO l_time_cal_dim
FROM dual
WHERE EXISTS (
		SELECT 1
		FROM fii_time_day
	     );

Line: 291

SELECT 1
INTO l_org_dim
FROM dual
WHERE EXISTS (
		SELECT 1
		FROM hri_org_hrchy_summary
	     );

Line: 305

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_TIME_CAL_DIMENSION')
	INTO l_time_cal_msg_text
	FROM dual;

Line: 313

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ORG_DIMENSION')
	INTO l_org_msg_text
	FROM dual;

Line: 351

  select /*+ full(org) parallel(org) use_hash(org)
             full(all_org) parallel(all_org) use_hash(all_org) */
    all_org.NAME ORGANIZATION_NAME
  from
    (
    select
      org.ORGANIZATION_ID
    from
      (
      select -- Resource Management
        org.ORGANIZATION_ID
      from
        (
        select /*+ index_ffs(org, PA_ALL_ORGANIZATIONS_U1)
                   parallel_index(org, PA_ALL_ORGANIZATIONS_U1) */
          distinct
          org.ORGANIZATION_ID
        from
          PA_ALL_ORGANIZATIONS org
        where
          p_settings_util_flag = 'Y' and
          p_params_util_flag = 'N'
        ) org
      where
        p_settings_util_flag = 'Y' and
        p_params_util_flag = 'N' and
        exists (select /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2)
                           parallel_index(fid, PA_FORECAST_ITEM_DETAILS_N2) */
                       1
                from   PA_FORECAST_ITEM_DETAILS fid
                where  fid.EXPENDITURE_ORGANIZATION_ID > 0 and
                       fid.EXPENDITURE_ORGANIZATION_ID = org.ORGANIZATION_ID)
      union -- Financial Management
      select /*+ ordered
                 use_hash(psc) swap_join_inputs(psc)
                 parallel(prj) use_hash(prj) */
        distinct
        prj.ORGANIZATION_ID
      from
        (
        select /*+ no_merge(prj) */
          prj.PROJECT_STATUS_CODE
        from
          (
          select /*+ index_ffs(prj, PA_PROJECTS_N4)
                     parallel_index(prj, PA_PROJECTS_N4) */
            distinct
            prj.PROJECT_STATUS_CODE
          from
            PA_PROJECTS_ALL prj
          where
            ((p_settings_cost_flag = 'Y' and
              p_params_cost_flag = 'N') or
             (p_settings_profit_flag = 'Y' and
              p_params_profit_flag = 'N'))
          ) prj
        where
          ((p_settings_cost_flag = 'Y' and
            p_params_cost_flag = 'N') or
           (p_settings_profit_flag = 'Y' and
            p_params_profit_flag = 'N')) and
          PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED
            (prj.PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'Y'
        ) psc,
        (
        select /*+ index_ffs(prj, PA_PROJECTS_N2)
                   parallel_index(prj, PA_PROJECTS_N2) */
          distinct
          prj.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID,
          prj.PROJECT_STATUS_CODE
        from
          PA_PROJECTS_ALL prj
        where
          ((p_settings_cost_flag = 'Y' and
            p_params_cost_flag = 'N') or
           (p_settings_profit_flag = 'Y' and
            p_params_profit_flag = 'N'))
        --  disregarding CLOSED_DATE massively improves performance
        --  nvl(closed_date,to_date('01-JAN-1997')) >= to_date('01-JAN-1997')
        ) prj
      where
        ((p_settings_cost_flag = 'Y' and
          p_params_cost_flag = 'N') or
         (p_settings_profit_flag = 'Y' and
          p_params_profit_flag = 'N')) and
        psc.project_status_code = prj.project_status_code
      ) org,
      (
      select /*+ index_ffs(hrchy, HRI_ORG_HRCHY_SUMMARY_N1)
                 parallel_index(hrchy, HRI_ORG_HRCHY_SUMMARY_N1) */
        distinct
        hrchy.ORGANIZATION_ID
      from
        HRI_ORG_HRCHY_SUMMARY hrchy
      where
        ((p_settings_cost_flag = 'Y' and
          p_params_cost_flag = 'N') or
         (p_settings_profit_flag = 'Y' and
          p_params_profit_flag = 'N') or
         (p_settings_util_flag = 'Y' and
          p_params_util_flag = 'N')) and
        hrchy.ORG_STRUCTURE_VERSION_ID = p_org_structure_version_id
      ) hrchy
    where
      ((p_settings_cost_flag = 'Y' and
        p_params_cost_flag = 'N') or
       (p_settings_profit_flag = 'Y' and
        p_params_profit_flag = 'N') or
       (p_settings_util_flag = 'Y' and
        p_params_util_flag = 'N')) and
      org.ORGANIZATION_ID = hrchy.ORGANIZATION_ID (+) and
      hrchy.ORGANIZATION_ID is null
    union
    select /*+ full(org) parallel(org) use_hash(org)
               full(denorm) parallel(denorm) use_hash(denorm) */
      org.ORGANIZATION_ID
    from
      (
      select /*+ parallel(org) */
        distinct
        org.ORGANIZATION_ID
      from
        (
        select /*+ index_ffs(rmr, PJI_RM_RES_WT_F_N1)
                   parallel_index(rmr, PJI_RM_RES_WT_F_N1) */
          rmr.EXPENDITURE_ORGANIZATION_ID ORGANIZATION_ID
        from
          PJI_RM_RES_WT_F rmr
        where
          p_params_util_flag = 'Y'
        union all
        select /*+ index_ffs(fpp, PJI_FP_PROJ_F_N1)
                   parallel_index(fpp, PJI_FP_PROJ_F_N1) */
          fpp.PROJECT_ORGANIZATION_ID ORGANIZATION_ID
        from
          PJI_FP_PROJ_F fpp
        where
          p_params_cost_flag = 'Y' and
          fpp.CALENDAR_TYPE = 'C'
        union all
        select /*+ index_ffs(acp, PJI_AC_PROJ_F_N1)
                   parallel_index(acp, PJI_AC_PROJ_F_N1) */
          acp.PROJECT_ORGANIZATION_ID ORGANIZATION_ID
        from
          PJI_AC_PROJ_F acp
        where
          p_params_profit_flag = 'Y' and
          acp.CALENDAR_TYPE = 'C'
        )org
      ) org,
      (
        select /*+ index_ffs(denorm, PJI_ORG_DENORM_N1)
                   parallel_index(denorm, PJI_ORG_DENORM_N1) */
          distinct
          denorm.ORGANIZATION_ID
        from
          PJI_ORG_DENORM denorm
        where
          (p_params_cost_flag = 'Y' or
           p_params_profit_flag = 'Y' or
           p_params_util_flag = 'Y')
      ) denorm
    where
      (p_params_cost_flag = 'Y' or
       p_params_profit_flag = 'Y' or
       p_params_util_flag = 'Y') and
      org.ORGANIZATION_ID = denorm.ORGANIZATION_ID (+) and
      denorm.ORGANIZATION_ID is null
    ) org,
    HR_ALL_ORGANIZATION_UNITS all_org
  where
    org.ORGANIZATION_ID = all_org.ORGANIZATION_ID
  order by all_org.NAME;

Line: 544

  select ORG_STRUCTURE_VERSION_ID
  into   l_org_structure_version_id
  from   PJI_SYSTEM_SETTINGS;

Line: 548

  select
    nvl(CONFIG_PROJ_PERF_FLAG, 'N'),
    nvl(CONFIG_COST_FLAG, 'N'),
    nvl(CONFIG_PROFIT_FLAG, 'N'),
    nvl(CONFIG_UTIL_FLAG, 'N')
  into
    l_settings_proj_perf_flag,
    l_settings_cost_flag,
    l_settings_profit_flag,
    l_settings_util_flag
  from
    PJI_SYSTEM_SETTINGS;

Line: 656

SELECT fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
INTO l_pji_security_prof
FROM dual;

Line: 660

SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL')
INTO l_mo_security_prof
FROM dual;

Line: 665

l_sec_prof_param_name_tbl.DELETE;

Line: 670

	SELECT meaning
	INTO l_pji_security_prof_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_SECURITY_PARAMS'
	and lookup_code = 'PJI_ORG_PROF';

Line: 683

	SELECT meaning
	INTO l_mo_security_prof_tkn
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_SECURITY_PARAMS'
	and lookup_code = 'PJI_MO_PROF';

Line: 694

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_NOT_SET')
	INTO l_prof_not_set_msg_text
	FROM dual;

Line: 703

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_NO_ACCESS')
	INTO l_no_access_msg_text
	FROM dual;

Line: 720

SELECT 	view_all_flag,
	view_all_organizations_flag
INTO
	l_org_view_all_flag,
	l_org_view_all_org_flag
FROM PER_SECURITY_PROFILES
where security_profile_id = l_pji_security_prof;

Line: 729

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_ALL_ACCESS')
	INTO l_org_all_access_msg_text
	FROM dual;

Line: 736

	l_org_name_tbl.DELETE;

Line: 738

	SELECT org.name
	BULK COLLECT INTO l_org_name_tbl
	FROM
	    hr_all_organization_units org
	   ,per_organization_list sec
	WHERE
		 org.organization_id = sec.organization_id
	AND  	 sec.security_profile_id = l_pji_security_prof;

Line: 747

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_PAR_ORG_ACCS')
	INTO l_org_par_access_msg_text
	FROM dual;

Line: 763

SELECT 	view_all_flag,
	view_all_organizations_flag
INTO
	l_ou_view_all_flag,
	l_ou_view_all_org_flag
FROM PER_SECURITY_PROFILES
where security_profile_id = l_mo_security_prof;

Line: 772

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_ALL_MO_ACCESS')
	INTO l_ou_all_access_msg_text
	FROM dual;

Line: 779

	l_ou_name_tbl.DELETE;

Line: 781

	SELECT org.name
	BULK COLLECT INTO l_ou_name_tbl
	FROM
		hr_all_organization_units org
	       ,per_organization_list sec
	WHERE
		 org.organization_id = sec.organization_id
	AND  sec.security_profile_id = l_mo_security_prof
	AND  exists
		 (
		 	SELECT 1
			FROM hr_organization_information info
			WHERE info.organization_id = org.organization_id
			AND   info.org_information_context = 'Operating Unit Information'
	 	);

Line: 797

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_PAR_MO_ACCS')
	INTO l_ou_par_access_msg_text
	FROM dual;

Line: 832

SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJI_BIS_REPORT_TEXT')
INTO l_pji_report_msg
FROM dual;

Line: 850

	SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SETUP_NOERR_TEXT')
	INTO l_pji_no_err_msg
	FROM dual;

Line: 881

SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SECURITY_REPORT_TEXT')
INTO l_security_report_msg
FROM dual;

Line: 890

	SELECT user_name
	INTO   l_username
	FROM   fnd_user
	WHERE  user_id = l_userid;

Line: 898

SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_USER_NAME')
INTO l_user_name_msg
FROM dual;