APPS.PER_FR_REPORT_UTILITIES dependencies on PER_JOB_DEFINITIONS

Line 14: per_job_definitions pjd,

10: select fsav.application_column_name,
11: fifst.concatenated_segment_delimiter delimeter
12: from fnd_segment_attribute_values fsav,
13: fnd_id_flex_segments fifs,
14: per_job_definitions pjd,
15: per_jobs pj,
16: fnd_id_flex_structures fifst
17: where pj.job_id = p_job_id
18: and pj.job_definition_id = p_job_definition_id

Line 59: ' from per_job_definitions

55: hr_utility.set_location('Obtaining segment values '||l_proc, 30);
56: if l_column_name is not null then
57: l_column_name := substr(l_column_name, 1, length(l_column_name) - 10);
58: open csr_segment_values for 'select '||l_column_name||
59: ' from per_job_definitions
60: where job_definition_id = '||p_job_definition_id;
61: fetch csr_segment_values into l_resultant;
62: close csr_segment_values;
63: l_resultant := replace(l_resultant, l_delimeter||'_NULL_', NULL);