APPS.PAY_NL_RETRO_SETUP_REPORT SQL Statements

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

Line: 9

        SELECT tag
          FROM fnd_lookup_values
         WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
           AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
                                    INSTR(USERENV('LANGUAGE'), '.') + 1)
           AND language = 'US';

Line: 42

SELECT DISTINCT
		pec.classification_id,
		pec1.classification_name
FROM
		pay_element_classifications pec ,
		pay_element_classifications_tl pec1 ,
		pay_element_types_f pat
WHERE
		pec.legislation_code = 'NL'
AND  		pec.parent_classification_id IS NULL
AND		pec1.language = USERENV('LANG') -- Bug ref. 5837256
AND 		pat.classification_id = pec.classification_id
AND 		pat.business_group_id = c_bg_id
AND 		pec1.classification_id = pat.classification_id
AND		(EXISTS (SELECT NULL FROM pay_retro_component_usages prcu WHERE
			    pat.element_type_id = prcu.creator_id
		AND         prcu.creator_type   = 'ET') OR  c_ele_rec = 'A');

Line: 63

SELECT
            pat.element_name,
            prc.component_name,
            hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.default_component,'N')) default_component,
            hr_general.decode_lookup('RETRO_REPROCESS_TYPE',prcu.reprocess_type) reprocess_type,
            hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.replace_run_flag,'N')) replace_run_flag,
            hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.use_override_dates,'N')) use_override_dates,
            pat1.element_name  Retro_Element,
            ptd1.definition_name Time_from ,
            ptd2.definition_name  Time_To ,
            pec.classification_name

FROM
            pay_element_types_f pat,
            pay_retro_component_usages prcu,
            pay_element_span_usages pesu,
            pay_time_spans pts,
            pay_time_definitions ptd1,
            pay_time_definitions ptd2,
            pay_element_types_f pat1,
            pay_retro_components prc,
            pay_element_classifications_tl pec

WHERE
            pat.business_group_id = c_bg_id
AND	    c_eff_date between pat.effective_start_date AND pat.effective_end_date
AND	    pat.classification_id = c_class_id
AND         pat.element_type_id = prcu.creator_id
AND         prcu.creator_type   = 'ET'
AND		pec.language = USERENV('LANG') -- Bug ref. 5837256
AND         prcu.retro_component_usage_id = pesu.retro_component_usage_id(+)
AND         pesu.time_span_id = pts.time_span_id(+)
AND         pts.start_time_def_id = ptd1.time_definition_id(+)
AND         pts.end_time_def_id  = ptd2.time_definition_id(+)
AND         pesu.retro_element_type_id = pat1.element_type_id(+)
AND         prcu.retro_component_id = prc.retro_component_id
AND 	    pat1.classification_id = pec.classification_id(+)
ORDER BY    pat.element_name, PRC.component_name	;

Line: 105

SELECT DISTINCT
	    pat.element_name
FROM
            pay_element_types_f pat,
            pay_retro_component_usages prcu
WHERE
            pat.business_group_id = c_bg_id
AND	    c_eff_date between pat.effective_start_date AND pat.effective_end_date
AND	    pat.classification_id = c_class_id
AND         pat.element_type_id = prcu.creator_id (+)
AND         prcu.creator_type (+)  = 'ET'
AND	    prcu.creator_id IS NULL;

Line: 123

SELECT name FROM per_business_groups
WHERE business_group_id = c_bg_id
AND   c_eff_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time);

Line: 383

insert into my_table15 values(l_xml);