[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
stp.object_type section_code
,stp.object_type_msg_name section_heading
,CASE WHEN p_mode = 'COUNT'
THEN NVL(stp.object_type_desc,
DECODE(stp.object_name_msg_name,
NULL, stp.object_name_desc, NULL))
ELSE NVL(stp.object_type_dtl_desc_msg_name,
DECODE(stp.object_name_msg_name,
NULL, stp.object_name_dtl_desc_msg_name, NULL))
END section_description
,stp.object_name subsection_code
,stp.object_name_msg_name subsection_heading
,CASE WHEN p_mode = 'COUNT'
THEN stp.object_name_desc
ELSE stp.object_name_dtl_desc_msg_name
END subsection_description
,stp.default_mode
,stp.report_type
,stp.count_heading
,stp.col_heading1
,stp.col_heading2
,stp.col_heading3
,stp.col_heading4
,stp.col_heading5
,stp.object_type_msg_name
,stp.object_name_msg_name
,stp.object_type_dtl_desc_msg_name
,stp.object_type_desc
,stp.object_name_dtl_desc_msg_name
,stp.object_name_desc
,stp.dynamic_sql
,stp.dynamic_sql_type
,stp.impact_msg_name
,stp.seq_num
FROM
hri_adm_dgnstc_setup stp
WHERE stp.enabled_flag = 'Y'
AND ((stp.report_type = 'DATA' AND p_show_data = 'Y')
OR (stp.report_type = 'ALERT' AND p_show_alerts = 'Y' AND
NVL(fnd_profile.value('HRI_LOG_PRCSS_INFO'),'Y') = 'Y'))
AND ((stp.foundation_hr_flag ='Y' AND hri_bpl_system.is_full_hr_installed='N')
OR hri_bpl_system.is_full_hr_installed='Y' )
AND EXISTS
(SELECT null
FROM dual
WHERE (p_functional_area = 'ALL'
OR EXISTS
(SELECT null
FROM hri_adm_dgnstc_sbscrb sbs
WHERE sbs.functional_area_cd = p_functional_area
AND sbs.object_name = stp.object_name
AND sbs.object_type = stp.object_type)))
ORDER BY
DECODE(stp.functional_area_cd,
'PPL_MNGMNT', null,
stp.functional_area_cd) ASC NULLS FIRST
,stp.report_type desc
,stp.seq_num;