DBA Data[Home] [Help]

APPS.PER_FR_REPORT_UTILITIES dependencies on PER_JOBS

Line 15: per_jobs pj,

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
19: and pjd.job_definition_id = pj.job_definition_id

Line 34: l_resultant per_jobs_tl.name%type;

30: and fifst.application_id = fsav.application_id
31: order by fifs.segment_num;
32: l_column_name varchar2(200);
33: l_select varchar2(50);
34: l_resultant per_jobs_tl.name%type;
35: l_sql_statement varchar2(1000);
36: l_delimeter fnd_id_flex_structures.concatenated_segment_delimiter%type;
37: l_proc varchar2(400);
38: BEGIN