[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
flex_value_set_id
INTO
ln_prj_value_set_id
FROM
fnd_id_flex_segments
WHERE application_id = 101
AND id_flex_code = 'GL#'
AND id_flex_num = pn_coa_id -- coa id parameter
AND application_column_name = lv_prj_seg; -- variable lv_prj_seg
lv_cursor_sql := 'SELECT '
--project id attribute
|| lv_prj_id_seg || ' project_id,'
--project name attribute
|| lv_prj_name_seg || ' project_name,'
--project level attribute
|| lv_prj_level_attr || ' project_level,'
--project type attribute
|| lv_prj_type_attr || ' project_type,'
--project category
|| lv_prj_category_attr || ' project_category,'
--project attribute
|| lv_prj_attribute_attr || ' project_attribute,'
--project start date
|| lv_prj_start_date_attr || ' project_start_date,'
--project end date
|| lv_prj_end_date_attr || ' project_end_date '
|| 'FROM '
|| ' fnd_flex_values_vl ' -- view fnd_flex_values_vl
|| 'WHERE flex_value_set_id = ' || ln_prj_value_set_id
--accounting year parameter and project start date
|| ' AND ('
|| lv_prj_start_date_attr || ' IS NULL '
|| ' OR '
|| 'EXTRACT(YEAR FROM
TO_DATE(' || lv_prj_start_date_attr ||
',' ||
'''YYYY/MM/DD HH24:MI:SS'''
|| '))' ||
' <= ' ||
pn_accounting_year || ')'
--accounting year parameter and project end date
|| ' AND ('
|| lv_prj_end_date_attr || ' IS NULL '
|| ' OR '
|| 'EXTRACT(YEAR FROM
TO_DATE(' || lv_prj_end_date_attr ||
',' ||
'''YYYY/MM/DD HH24:MI:SS'''
|| '))' ||
' >= ' ||
pn_accounting_year ||
')';