ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
C6E085D46F5651A9E05362FB09050512Y
select
distinct pil.per_in_ler_id PER_IN_LER_ID1,
pil.person_id per_id_rep3,
per.full_name PERNAME3,
per.national_identifier PERSSN3,
loc.location_id loc_id_plan_rep3,
loc_tl.location_code PERLOC3,
pil.ler_id ler_id_plan_rep3,
ler_tl.name LERNAME3,
hr_general.decode_lookup('BEN_PER_IN_LER_STAT', per_in_ler_stat_cd) LESTAT3,
hr_general.decode_lookup('BEN_LER_TYP', ler.typ_cd) LERTYPE3,
pil.lf_evt_ocrd_dt LEOCRDDT3,
pil.ntfn_dt ntfn_dt_plan_rep3,
pln.pl_id pl_id_plan_rep3,
pln.name pl_name_plan_rep3,
attr.counter COUNTER1,
dff1.form_left_prompt segment_prompt_text1,
attr.col_name col_name1,
decode(attr.counter,
1,PIL.PIL_ATTRIBUTE1 ,
2,PIL.PIL_ATTRIBUTE2 ,
3,PIL.PIL_ATTRIBUTE3 ,
4,PIL.PIL_ATTRIBUTE4 ,
5,PIL.PIL_ATTRIBUTE5 ,
6,PIL.PIL_ATTRIBUTE6 ,
7,PIL.PIL_ATTRIBUTE7 ,
8,PIL.PIL_ATTRIBUTE8 ,
9,PIL.PIL_ATTRIBUTE9 ,
10,PIL.PIL_ATTRIBUTE10 ,
11,PIL.PIL_ATTRIBUTE11 ,
12,PIL.PIL_ATTRIBUTE12 ,
13,PIL.PIL_ATTRIBUTE13 ,
14,PIL.PIL_ATTRIBUTE14 ,
15,PIL.PIL_ATTRIBUTE15 ,
16,PIL.PIL_ATTRIBUTE16 ,
17,PIL.PIL_ATTRIBUTE17 ,
18,PIL.PIL_ATTRIBUTE18 ,
19,PIL.PIL_ATTRIBUTE19 ,
20,PIL.PIL_ATTRIBUTE20 ,
21,PIL.PIL_ATTRIBUTE21 ,
22,PIL.PIL_ATTRIBUTE22 ,
23,PIL.PIL_ATTRIBUTE23 ,
24,PIL.PIL_ATTRIBUTE24 ,
25,PIL.PIL_ATTRIBUTE25 ,
26,PIL.PIL_ATTRIBUTE26 ,
27,PIL.PIL_ATTRIBUTE27 ,
28,PIL.PIL_ATTRIBUTE28 ,
29,PIL.PIL_ATTRIBUTE29 ,
30,PIL.PIL_ATTRIBUTE30
) attr_val1
from ben_per_in_ler pil,
per_all_people_f per,
per_all_assignments_f asg,
hr_locations_all loc,hr_locations_all_tl loc_tl,
ben_pl_f pln,
ben_ler_f ler,ben_ler_f_tl ler_tl,
( select distinct person_id,pl_id
from ben_prtt_enrt_rslt_f pen
where pen.business_group_id = :p_business_group_id
and pen.person_id=nvl(:p_person_id,pen.person_id)
and pen.comp_lvl_cd in ('PLAN', 'PLIP', 'OIPL')
and :p_run_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
and pen.enrt_cvg_thru_dt <= pen.effective_end_date
and pen.prtt_enrt_rslt_stat_cd is null
) pl_per,
FND_DESCR_FLEX_COL_USAGE_TL dff1,
(
select 1 counter, 'PIL_ATTRIBUTE1' col_name from dual union
select 2 counter, 'PIL_ATTRIBUTE2' col_name
from dual union
select 3 counter, 'PIL_ATTRIBUTE3' col_name
from dual union
select 4 counter, 'PIL_ATTRIBUTE4' col_name
from dual union
select 5 counter, 'PIL_ATTRIBUTE5' col_name
from dual union
select 6 counter, 'PIL_ATTRIBUTE6' col_name
from dual union
select 7 counter, 'PIL_ATTRIBUTE7' col_name
from dual union
select 8 counter, 'PIL_ATTRIBUTE8' col_name
from dual union
select 9 counter, 'PIL_ATTRIBUTE9' col_name
from dual union
select 10 counter, 'PIL_ATTRIBUTE10' col_name
from dual union
select 11 counter, 'PIL_ATTRIBUTE11' col_name
from dual union
select 12 counter, 'PIL_ATTRIBUTE12' col_name
from dual union
select 13 counter, 'PIL_ATTRIBUTE13' col_name
from dual union
select 14 counter, 'PIL_ATTRIBUTE14' col_name
from dual union
select 15 counter, 'PIL_ATTRIBUTE15' col_name
from dual union
select 16 counter, 'PIL_ATTRIBUTE16' col_name
from dual union
select 17 counter, 'PIL_ATTRIBUTE17' col_name
from dual union
select 18 counter, 'PIL_ATTRIBUTE18' col_name
from dual union
select 19 counter, 'PIL_ATTRIBUTE19' col_name
from dual union
select 20 counter, 'PIL_ATTRIBUTE20' col_name
from dual union
select 21 counter, 'PIL_ATTRIBUTE21' col_name
from dual union
select 22 counter, 'PIL_ATTRIBUTE22' col_name
from dual union
select 23 counter, 'PIL_ATTRIBUTE23' col_name
from dual union
select 24 counter, 'PIL_ATTRIBUTE24' col_name
from dual union
select 25 counter, 'PIL_ATTRIBUTE25' col_name
from dual union
select 26 counter, 'PIL_ATTRIBUTE26' col_name
from dual union
select 27 counter, 'PIL_ATTRIBUTE27' col_name
from dual union
select 28 counter, 'PIL_ATTRIBUTE28' col_name
from dual union
select 29 counter, 'PIL_ATTRIBUTE29' col_name
from dual union
select 30 counter, 'PIL_ATTRIBUTE30' col_name
from dual
) attr
where :p_report_module_cd in ('LEBYPLAN','ALLMODLS')
and :P_DISP_FLEX_FIELDS_FLAG ='Y'
and dff1.descriptive_flexfield_name = 'BEN_PER_IN_LER'
and dff1.APPLICATION_ID = 805
and dff1.APPLICATION_COLUMN_NAME = attr.col_name
and ( (dff1.DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Global Data Elements')
or
(dff1.DESCRIPTIVE_FLEX_CONTEXT_CODE = nvl(PIL.PIL_attribute_category, 'Global Data Elements'))
)
and :p_run_report ='Y'
and loc_tl.language=userenv('LANG')
and loc_tl.location_id=loc.location_id
and ler_tl.language=userenv('LANG')
and ler_tl.ler_id=ler.ler_id
and ler.effective_start_date = ler_tl.effective_start_date
and pil.business_group_id = :p_business_group_id
and ler.business_group_id = per.business_group_id
and ler.business_group_id = asg.business_group_id
and pil.lf_evt_ocrd_dt between :p_comp_perd_strt_dt and :p_comp_perd_end_dt
and pil.per_in_ler_stat_cd='PROCD'
and (:p_person_id is null or pil.person_id = :p_person_id)
and (:p_nat_ident is null or per.national_identifier = :p_nat_ident)
and pil.person_id = pl_per.person_id
and pl_per.person_id = per.person_id
and pln.pl_id=pl_per.pl_id
and :p_run_date between pln.effective_start_date and pln.effective_end_date
and (:p_benefit_group_id is null or per.benefit_group_id = :p_benefit_group_id)
and :p_run_date between per.effective_start_date and per.effective_end_date
and ler.ler_id = pil.ler_id
and (:p_ler_id is null or ler.ler_id = :p_ler_id)
and ler.typ_cd not in ('ABS','COMP','GSP')
and (:p_ler_type is null
or
(:p_ler_type = 'SCHEDULED' and ler.typ_cd in ('SCHEDDO','SCHEDDA','SCHEDDU') )
or
(:p_ler_type = 'EXPLICIT' and ler.typ_cd in ('ADDDURENRT','DRVDLSELG','DSBLTY','ENDDSBLTY','DRVDNLP','DRVDPOEELG',
'INFO','OVRRIDE','DRVDPOERT','PRSNL','REDUHRS','DRVDVEC','DRVDWTGSTF','UNRSTR','WORK','QUAINGR') )
or
(:p_ler_type = 'TEMPORAL' and ler.typ_cd in ('DRVDAGE','DRVDCAL','DRVDCMP','DRVDHRW','DRVDLOS','DRVDTPF') )
)
and :p_run_date between ler.effective_start_date and ler.effective_end_date
and pil.lf_evt_ocrd_dt between asg.effective_start_date and asg.effective_end_date
and asg.person_id = pil.person_id
and asg.location_id = loc.location_id (+)
and (:p_location_id is null or asg.location_id = :p_location_id)
and (instr(nvl(:p_assignment_type,assignment_type),assignment_type) >0)
and asg.assignment_type <> 'C'
and (:p_organization_id is null or asg.organization_id = :p_organization_id)
and :p_run_date between per.effective_start_date and per.effective_end_date
and ((asg.primary_flag = 'Y' and ((asg.assignment_type='E') or (asg.assignment_type='B')))
or
(asg.assignment_type = 'A'))
and (
decode(assignment_type,'E',1,'B',2,'A',3,10) =
(
(SELECT min(decode(assignment_type,'E',1,'B',2,'A',3,10)) min_decd_val
FROM per_all_assignments_f asg1
WHERE
(
(
((asg1.assignment_type='E') or (asg1.assignment_type='B')) and
(asg1.primary_flag='Y')
)
or
(asg1.assignment_type='A')
)
and asg1.assignment_type <> 'C'
and pil.lf_evt_ocrd_dt between asg1.EFFECTIVE_START_DATE and asg1.EFFECTIVE_END_DATE
and (instr(nvl(:p_assignment_type,assignment_type),assignment_type) >0)
and asg1.person_id=pil.person_id
)
)
)
and pln.pl_id=:valid_pl_id1
UNION ALL
select
distinct pil.per_in_ler_id per_in_ler_id1,
pil.person_id per_id_rep3,
per.full_name PERNAME3,
per.national_identifier PERSSN3,
loc.location_id loc_id_plan_rep3,
loc_tl.location_code PERLOC3,
pil.ler_id ler_id_plan_rep3,
ler_tl.name LERNAME3,
hr_general.decode_lookup('BEN_PER_IN_LER_STAT', per_in_ler_stat_cd) LESTAT3,
hr_general.decode_lookup('BEN_LER_TYP', ler.typ_cd) LERTYPE3,
pil.lf_evt_ocrd_dt LEOCRDDT3,
pil.ntfn_dt ntfn_dt_plan_rep3,
pln.pl_id pl_id_plan_rep3,
pln.name pl_name_plan_rep3,
attr.counter counter1,
dff1.form_left_prompt segment_prompt_text1,
attr.col_name col_name1,
decode(attr.counter,
1,PIL.PIL_ATTRIBUTE1 ,
2,PIL.PIL_ATTRIBUTE2 ,
3,PIL.PIL_ATTRIBUTE3 ,
4,PIL.PIL_ATTRIBUTE4 ,
5,PIL.PIL_ATTRIBUTE5 ,
6,PIL.PIL_ATTRIBUTE6 ,
7,PIL.PIL_ATTRIBUTE7 ,
8,PIL.PIL_ATTRIBUTE8 ,
9,PIL.PIL_ATTRIBUTE9 ,
10,PIL.PIL_ATTRIBUTE10 ,
11,PIL.PIL_ATTRIBUTE11 ,
12,PIL.PIL_ATTRIBUTE12 ,
13,PIL.PIL_ATTRIBUTE13 ,
14,PIL.PIL_ATTRIBUTE14 ,
15,PIL.PIL_ATTRIBUTE15 ,
16,PIL.PIL_ATTRIBUTE16 ,
17,PIL.PIL_ATTRIBUTE17 ,
18,PIL.PIL_ATTRIBUTE18 ,
19,PIL.PIL_ATTRIBUTE19 ,
20,PIL.PIL_ATTRIBUTE20 ,
21,PIL.PIL_ATTRIBUTE21 ,
22,PIL.PIL_ATTRIBUTE22 ,
23,PIL.PIL_ATTRIBUTE23 ,
24,PIL.PIL_ATTRIBUTE24 ,
25,PIL.PIL_ATTRIBUTE25 ,
26,PIL.PIL_ATTRIBUTE26 ,
27,PIL.PIL_ATTRIBUTE27 ,
28,PIL.PIL_ATTRIBUTE28 ,
29,PIL.PIL_ATTRIBUTE29 ,
30,PIL.PIL_ATTRIBUTE30
) attr_val1
from
per_all_people_f per,
per_all_assignments_f asg,
hr_locations_all loc,hr_locations_all_tl loc_tl,
ben_pl_f pln,
ben_ler_f ler,ben_ler_f_tl ler_tl,
ben_elig_per_elctbl_chc epe,
ben_per_in_ler pil,
FND_DESCR_FLEX_COL_USAGE_TL dff1,
(
select 1 counter, 'PIL_ATTRIBUTE1' col_name from dual union
select 2 counter, 'PIL_ATTRIBUTE2' col_name
from dual union
select 3 counter, 'PIL_ATTRIBUTE3' col_name
from dual union
select 4 counter, 'PIL_ATTRIBUTE4' col_name
from dual union
select 5 counter, 'PIL_ATTRIBUTE5' col_name
from dual union
select 6 counter, 'PIL_ATTRIBUTE6' col_name
from dual union
select 7 counter, 'PIL_ATTRIBUTE7' col_name
from dual union
select 8 counter, 'PIL_ATTRIBUTE8' col_name
from dual union
select 9 counter, 'PIL_ATTRIBUTE9' col_name
from dual union
select 10 counter, 'PIL_ATTRIBUTE10' col_name
from dual union
select 11 counter, 'PIL_ATTRIBUTE11' col_name
from dual union
select 12 counter, 'PIL_ATTRIBUTE12' col_name
from dual union
select 13 counter, 'PIL_ATTRIBUTE13' col_name
from dual union
select 14 counter, 'PIL_ATTRIBUTE14' col_name
from dual union
select 15 counter, 'PIL_ATTRIBUTE15' col_name
from dual union
select 16 counter, 'PIL_ATTRIBUTE16' col_name
from dual union
select 17 counter, 'PIL_ATTRIBUTE17' col_name
from dual union
select 18 counter, 'PIL_ATTRIBUTE18' col_name
from dual union
select 19 counter, 'PIL_ATTRIBUTE19' col_name
from dual union
select 20 counter, 'PIL_ATTRIBUTE20' col_name
from dual union
select 21 counter, 'PIL_ATTRIBUTE21' col_name
from dual union
select 22 counter, 'PIL_ATTRIBUTE22' col_name
from dual union
select 23 counter, 'PIL_ATTRIBUTE23' col_name
from dual union
select 24 counter, 'PIL_ATTRIBUTE24' col_name
from dual union
select 25 counter, 'PIL_ATTRIBUTE25' col_name
from dual union
select 26 counter, 'PIL_ATTRIBUTE26' col_name
from dual union
select 27 counter, 'PIL_ATTRIBUTE27' col_name
from dual union
select 28 counter, 'PIL_ATTRIBUTE28' col_name
from dual union
select 29 counter, 'PIL_ATTRIBUTE29' col_name
from dual union
select 30 counter, 'PIL_ATTRIBUTE30' col_name
from dual
) attr
where :p_report_module_cd in ('LEBYPLAN','ALLMODLS')
and :p_run_report ='Y'
and :P_DISP_FLEX_FIELDS_FLAG ='Y'
and dff1.descriptive_flexfield_name = 'BEN_PER_IN_LER'
and dff1.APPLICATION_ID = 805
and dff1.APPLICATION_COLUMN_NAME = attr.col_name
and ( (dff1.DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Global Data Elements')
or
(dff1.DESCRIPTIVE_FLEX_CONTEXT_CODE = nvl(PIL.PIL_attribute_category, 'Global Data Elements'))
)
and loc_tl.language=userenv('LANG')
and loc_tl.location_id=loc.location_id
and ler_tl.language=userenv('LANG')
and ler_tl.ler_id=ler.ler_id
and ler.effective_start_date = ler_tl.effective_start_date
and pil.business_group_id = :p_business_group_id
and ler.business_group_id = per.business_group_id
and pil.lf_evt_ocrd_dt between :p_comp_perd_strt_dt and :p_comp_perd_end_dt
and (:p_person_id is null or per.person_id = :p_person_id)
and (:p_nat_ident is null or per.national_identifier = :p_nat_ident)
and pil.person_id = per.person_id
and asg.person_id = pil.person_id
and pil.ler_id=ler.ler_id
and pln.pl_id=epe.pl_id
and pil.per_in_ler_id=epe.per_in_ler_id
and ler.ler_id = pil.ler_id
and :p_run_date >= epe.enrt_cvg_strt_dt
and pil.per_in_ler_stat_cd='STRTD'
and epe.elctbl_flag='Y'
and epe.comp_lvl_cd in ('PLAN', 'PLIP', 'OIPL')
and :p_run_date between pln.effective_start_date and pln.effective_end_date
and (:p_benefit_group_id is null or per.benefit_group_id = :p_benefit_group_id)
and :p_run_date between per.effective_start_date and per.effective_end_date
and (:p_ler_id is null or ler.ler_id = :p_ler_id)
and ler.typ_cd not in ('ABS','COMP','GSP')
and (:p_ler_type is null
or
(:p_ler_type = 'SCHEDULED' and ler.typ_cd in ('SCHEDDO','SCHEDDA','SCHEDDU') )
or
(:p_ler_type = 'EXPLICIT' and ler.typ_cd in ('ADDDURENRT','DRVDLSELG','DSBLTY','ENDDSBLTY','DRVDNLP','DRVDPOEELG',
'INFO','OVRRIDE','DRVDPOERT','PRSNL','REDUHRS','DRVDVEC','DRVDWTGSTF','UNRSTR','WORK','QUAINGR') )
or
(:p_ler_type = 'TEMPORAL' and ler.typ_cd in ('DRVDAGE','DRVDCAL','DRVDCMP','DRVDHRW','DRVDLOS','DRVDTPF') )
)
and :p_run_date between ler.effective_start_date and ler.effective_end_date
and pil.lf_evt_ocrd_dt between asg.effective_start_date and asg.effective_end_date
and asg.location_id = loc.location_id (+)
and (:p_location_id is null or asg.location_id = :p_location_id)
and (instr(nvl(:p_assignment_type,assignment_type),assignment_type) >0)
and asg.assignment_type <> 'C'
and (:p_organization_id is null or asg.organization_id = :p_organization_id)
and :p_run_date between per.effective_start_date and per.effective_end_date
and ((asg.primary_flag = 'Y' and ((asg.assignment_type='E') or (asg.assignment_type='B')))
or
(asg.assignment_type = 'A'))
and (
decode(assignment_type,'E',1,'B',2,'A',3,10) =
(
(SELECT min(decode(assignment_type,'E',1,'B',2,'A',3,10)) min_decd_val
FROM per_all_assignments_f asg1
WHERE
(
(
((asg1.assignment_type='E') or (asg1.assignment_type='B')) and
(asg1.primary_flag='Y')
)
or
(asg1.assignment_type='A')
)
and asg1.assignment_type <> 'C'
and pil.lf_evt_ocrd_dt between asg1.EFFECTIVE_START_DATE and asg1.EFFECTIVE_END_DATE
and (instr(nvl(:p_assignment_type,assignment_type),assignment_type) >0)
and asg1.person_id=pil.person_id
)
)
)
and pln.pl_id=:valid_pl_id1
&p_sort_dff3
--&p_sort_dff
-- and pln.pl_id=:valid_pl_id1
BEN
BENLESUM_XML
AR
BEN تقرير إجمالي أحداث العمر (بتنسيق XML)
Imported from BI Publisher
Description: تقرير إجمالي أحداث العمر
Application: المزايا المتقدمة
Source: تقرير إجمالي أحداث العمر (بتنسيق XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
D
BEN Veränderungen - Übersicht
Imported from BI Publisher
Description: Auswertung "Veränderungen - Übersicht"
Application: Advanced Benefits
Source: Veränderungen - Übersicht (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
E
BEN Resumen de Eventos Personales
Imported from BI Publisher
Description: Informe de resumen de eventos personales
Application: Advanced Benefits
Source: Resumen de Eventos Personales (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
F
BEN Etat Synthèse des événements personnels
Imported from BI Publisher
Description: Etat Synthèse des événements personnels
Application: Advanced Benefits
Source: Etat Synthèse des événements personnels (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
I
BEN Rapporto Sintetico eventi vita
Imported from BI Publisher
Description: Rapporto del sintetico eventi vita
Application: Advanced Benefits
Source: Rapporto Sintetico eventi vita (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
JA
BEN ライフ・イベント要約レポート
Imported from BI Publisher
Description: ライフ・イベント要約レポート
Application: Advanced Benefits
Source: ライフ・イベント要約レポート(XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
KO
BEN Life Event 요약 보고서
Imported from BI Publisher
Description: Life Event 요약 보고서
Application: Advanced Benefits
Source: Life Event 요약 보고서(XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
PTB
BEN Relatório Resumido de Eventos de Vida
Imported from BI Publisher
Description: Relatório Resumido de Eventos de Vida
Application: Advanced Benefits
Source: Relatório Resumido de Eventos de Vida (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
RU
BEN Сводный отчет о жизненных событиях
Imported from BI Publisher
Description: Сводный отчет о жизненных событиях
Application: Пособия
Source: Сводный отчет о жизненных событиях (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
S
BEN Översiktsrapport för livshändelser
Imported from BI Publisher
Description: Översiktsrapport för livshändelser
Application: Advanced Benefits
Source: Översiktsrapport för livshändelser (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
TR
BEN Önemli Kişisel Olaylar Özet Raporu
Imported from BI Publisher
Description: Önemli Kişisel Olaylar Özet Raporu
Application: Kazanç Yönetimi
Source: Önemli Kişisel Olaylar Özet Raporu (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
US
BEN Life Events Summary
Imported from BI Publisher
Description: Life Events Summary Report
Application: Advanced Benefits
Source: Life Events Summary Report (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
ZHS
BEN 人生事件汇总报表
Imported from BI Publisher
Description: 人生事件汇总报表
Application: 高级福利
Source: 人生事件汇总报表 (XML)
Short Name: BENLESUM_XML
DB package: BEN_BENLESUM_XMLP_PKG
BI Publisher
&p_sort_dff
&p_sort_dff3
:cp_asg_type
:cp_backedout_name_proc_comp
:cp_backedout_name_proc_rep
:cp_benefit_group_name
:cp_business_group_name
:cp_comp_strt_end_dt
:cp_detected_name_potnl_comp
:cp_detected_name_potnl_rep
:cp_displ_flex
:cp_ler_name
:cp_ler_type
:cp_location_name
:cp_manover_name_potnl_comp
:cp_manover_name_potnl_rep
:cp_nat_ident
:cp_organization_name
:cp_person_name
:cp_pln_name
:cp_processed_name_potnl_comp
:cp_processed_name_potnl_rep
:cp_processed_name_proc_comp
:cp_processed_name_proc_rep
:cp_report_module_name
:cp_reporting_group_name
:cp_rept_strt_end_dt
:cp_settomanual_name_potnl_comp
:cp_settomanual_name_potnl_rep
:cp_started_name_proc_comp
:cp_started_name_proc_rep
:cp_total_name_potnl_comp
:cp_total_name_potnl_rep
:cp_total_name_proc_comp
:cp_total_name_proc_rep
:cp_unprocessed_name_potnl_comp
:cp_unprocessed_name_potnl_rep
:cp_voided_name_potnl_comp
:cp_voided_name_potnl_rep
:cp_voided_name_proc_comp
:cp_voided_name_proc_rep
:p_assignment_type
:p_benefit_group_id
:p_business_group_id
:p_comp_perd_end_dt
:p_comp_perd_strt_dt
:p_conc_request_id
:p_date_mask
:p_disp_flex_fields_flag
:p_error
:p_ler_id
:p_ler_type
:p_location_id
:p_nat_ident
:p_organization_id
:p_person_id
:p_pl_id
:p_report_module_cd
:p_reporting_group_id
:p_rept_perd_end_dt
:p_rept_perd_strt_dt
:p_rptg_grp_id
:p_run_date
:p_run_report
:p_sort
:p_sort1
:p_sort_dff
:p_sort_dff2
:p_sort_dff3
:p_sort_order_1
:p_sort_order_2
:p_sort_order_3
:p_sort_order_4
:p_user_sort
:t_comp_perd_end_dt
:t_comp_perd_strt_dt
:t_conc_request_id
:t_rept_perd_end_dt
:t_rept_perd_strt_dt
:t_run_date
:valid_pl_id1
1
-20
:p_business_group_id
Char
fnd_profile.value('PER_BUSINESS_GROUP_ID')
AR
معرف مجموعة الأعمال
D
Kennung Unternehmensgruppe
E
Id Grupo de Trabajo
F
ID entité professionnelle
I
Id business group
JA
ビジネス・グループID
KO
업무 그룹 ID
PTB
Id do Grupo Funcional
RU
Идент. бизнес-группы
S
Id för verksamhetsgrupp
TR
İş Grubu No
US
Business Group Id
ZHS
业务组标识
2
10
:p_report_module_cd
LOV Oracle
BEN_LESUM_REPORT_MODULE_CODE
Y
select
lookup_code id,
meaning value,
null description
from
hr_lookups
where lookup_type='BEN_LESUM_REPT_MODL_CD'
and enabled_flag='Y'
and sysdate between start_date_active
and nvl(end_date_active,sysdate)
order by meaning
select meaning from hr_lookups where lookup_type='BEN_LESUM_REPT_MODL_CD' and lookup_code='ALLMODLS' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
Y
AR
وحدة التقرير
D
Auswertungsmodul
E
Módulo de Informe
F
Module d'état
I
Modulo rapporto
JA
レポート・モジュール
KO
보고서 모듈
PTB
Módulo do Relatório
RU
Модуль отчета
S
Rapportmodul
TR
Rapor Modülü
US
Report Module
ZHS
报表模块
3
20
:p_run_date
Date
select fnd_date.date_to_displaydate(sysdate) from sys.dual
Y
US
PER_DATES
4
30
:p_person_id
LOV Oracle
BEN_PERSON
Y
select
a.person_id id,
a.full_name || ' (Employee Number=' || a.employee_number || ') (Person ID=' || a.person_id || ')' value,
null description
from
per_people_f a
where a.business_group_id=
fnd_global.per_business_group_id
and a.effective_start_date=
(select max(effective_start_date)
from per_all_people_f ppf1
where ppf1.person_id=a.person_id)
order by a.last_name,a.first_name
AR
اسم الشخص
D
Personenname
E
Nombre de Persona
F
Nom de la personne
I
Nome persona
JA
個人名
KO
개인 이름
PTB
Nome da Pessoa
RU
Имя лица
S
Namn
TR
Kişi Adı
US
Person Name
ZHS
人员姓名
5
40
:p_nat_ident
LOV Oracle
BEN_US_SSN
Y
select
a.national_identifier id,
a.national_identifier value,
null description
from
per_people_f a
where a.business_group_id=
fnd_global.per_business_group_id
and to_date(:$flex$.per_dates,'YYYY/MM/DD HH24:MI:SS')
between a.effective_start_date and
a.effective_end_date
order by a.national_identifier
AR
رقم البطاقة الشخصية
D
Nationale Kennnummer
E
N.I.F.
F
Identifiant national
I
Codice fiscale
JA
国別識別子
KO
주민 등록 번호
PTB
Identificador Nacional
RU
ИНН
S
Personnummer
TR
Sosyal Güvenlik Numarası
US
National Identifier
ZHS
身份证
6
50
:p_rept_perd_strt_dt
Date
Y
AR
تاريخ بداية فترة التقرير
D
Startdatum Auswertungsperiode
E
Fecha de Inicio de Período de Informe
F
Date de début de la période de reporting
I
Data inizio periodo generazione rapporti
JA
レポート期間開始日
KO
보고 기간 시작 일자
PTB
Data Inicial do Período de Emissão de Relatórios
RU
Начальная дата отчетного периода
S
Startdatum för rapporteringsperiod
TR
Raporlama Dönemi Başlangıç Tarihi
US
Reporting Period Start Date
ZHS
报告期起始日期
7
60
:p_rept_perd_end_dt
Date
Y
AR
تاريخ نهاية فترة التقرير
D
Enddatum Auswertungsperiode
E
Fecha de Finalización de Período de Informe
F
Date de fin de la période de reporting
I
Data fine periodo dichiarazione
JA
レポート期間終了日
KO
보고 기간 종료 일자
PTB
Data Final do Período de Emissão de Relatórios
RU
Конечная дата отчетного периода
S
Slutdatum för rapporteringsperiod
TR
Raporlama Dönemi Bitiş Tarihi
US
Reporting Period End Date
ZHS
报告期终止日期
8
70
:p_comp_perd_strt_dt
Date
AR
تاريخ بداية فترة المقارنة
D
Startdatum Vergleichsperiode
E
Fecha de Inicio de Período de Comparación
F
Date de début de la période de comparaison
I
Data inizio periodo confronto
JA
比較期間開始日
KO
비교 기간 시작 일자
PTB
Data Inicial do Período de Comparação
RU
Начало периода для сравнения
S
Startdatum för jämförelseperiod
TR
Karşılaştırma Dönemi Başlangıç Tarihi
US
Comparison Period Start Date
ZHS
比较期间起始日期
9
80
:p_comp_perd_end_dt
Date
AR
تاريخ نهاية فترة المقارنة
D
Enddatum Vergleichsperiode
E
Fecha de Finalización de Período de Comparación
F
Date de fin de la période de comparaison
I
Data fine periodo confronto
JA
比較期間終了日
KO
비교 기간 종료 일자
PTB
Data Final do Período de Comparação
RU
Окончание периода для сравнения
S
Slutdatum för jämförelseperiod
TR
Karşılaştırma Dönemi Bitiş Tarihi
US
Comparison Period End Date
ZHS
比较期间终止日期
10
90
:p_location_id
LOV Oracle
HR_US_LOCATIONS
Y
select
hl.location_id id,
hl.location_code value,
null description
from
hr_locations hl
where location_use='HR'
order by location_code
AR
الموقع
D
Standort
E
Ubicación
F
Lieu
I
Ubicazione
JA
事業所
KO
위치
PTB
Local
RU
Расположение
S
Placering
TR
Yerleşim
US
Location
ZHS
地点
11
100
:p_assignment_type
LOV Oracle
BEN_LESUM_ASG_TYPE
Y
select
lookup_code id,
meaning value,
null description
from
hr_lookups
where lookup_type='BEN_LESUM_ASG_TYPE'
and enabled_flag='Y'
and sysdate between start_date_active
and nvl(end_date_active,sysdate)
order by meaning
AR
نوع التعيين
D
Zuordnungsart
E
Tipo de Asignación
F
Type d'affectation
I
Tipo assegnazione
JA
アサイメント・タイプ
KO
발령 유형
PTB
Tipo de Atribuição
RU
Тип назначения
S
Uppdragstyp
TR
Görev Tipi
US
Assignment Type
ZHS
分配类型
12
110
:p_organization_id
LOV Oracle
HR_US_ORGANIZATIONS
Y
select
hou.organization_id id,
hou.name value,
null description
from
hr_organization_units hou,hr_organization_information hoi
where hou.business_group_id=fnd_global.per_business_group_id
and hou.organization_id=hoi.organization_id
and hoi.org_information_context='CLASS'
and hoi.org_information1='HR_ORG'
order by hou.name
AR
المنشأة
D
Organisation
E
Organización
F
Organisation
I
Organizzazione
JA
組織
KO
조직
PTB
Organização
RU
Организация
S
Organisation
TR
Organizasyon
US
Organization
ZHS
组织
13
120
:p_reporting_group_id
LOV Oracle
BEN_RPTG_GRP
Y
select
rptg_grp_id id,
name value,
null description
from
ben_rptg_grp_v
where nvl(business_group_id,fnd_global.per_business_group_id)=
fnd_global.per_business_group_id
order by name
AR
مجموعة التقارير
D
Auswertungsgruppe
E
Grupo de Informes
F
Groupe de reporting
I
Gruppo rapporti
JA
レポート・グループ
KO
보고 그룹
PTB
Grupo de Emissão de Relatórios
RU
Группа отчетности
S
Rapporteringsgrupp
TR
Raporlama Grubu
US
Reporting Group
ZHS
报告组
14
130
:p_benefit_group_id
LOV Oracle
BEN_BENEFITS_GROUP
Y
select
benfts_grp_id id,
name value,
null description
from
ben_benfts_grp
where business_group_id=
fnd_global.per_business_group_id
order by name
AR
المجموعة التابع لها
D
Leistungsgruppe
E
Grupo de Beneficios
F
Groupe d'avantages
I
Gruppo benefit
JA
福利厚生グループ
KO
복리후생 그룹
PTB
Grupo de Benefícios
RU
Группа пособий
S
Förmånsgrupp
TR
Kazanç Grubu
US
Benefit Group
ZHS
福利组
15
140
:p_pl_id
LOV Oracle
BEN_PL
Y
select
pl_id id,
name value,
null description
from
ben_pl_f a
where a.business_group_id=fnd_global.per_business_group_id
and a.pl_typ_id in
(select pl_typ_id from ben_pl_typ_f where opt_typ_cd not in ('CWB','GSP','ABS','ICM'))
and a.effective_start_date=(select max(effective_start_date) from ben_pl_f b where b.pl_id=a.pl_id)
and not exists(select null
from ben_plip_f cpp
where cpp.pl_id=a.pl_id)
order by name
AR
الخطة
I
Piano
JA
プラン
KO
제도
PTB
Plano
RU
План
US
Plan
ZHS
计划
16
150
:p_ler_id
LOV Oracle
BEN_LER
Y
select
ler_id id,
name value,
null description
from
ben_ler_f a
where a.business_group_id=fnd_global.per_business_group_id
and a.typ_cd not in ('GSP','ABS','COMP','IREC')
and a.effective_start_date=(select max(b.effective_start_date) from ben_ler_f b where a.ler_id=b.ler_id)
order by name
AR
حدث العمر
D
Veränderung
E
Evento Personal
F
Evénement personnel
I
Evento vita
JA
ライフ・イベント
PTB
Evento de Vida
RU
Жизненное событие
S
Livshändelse
TR
Önemli Kişisel Olay
US
Life Event
ZHS
人生事件
17
160
:p_ler_type
LOV Oracle
BEN_LESUM_LER_TYPE
Y
select
lookup_code id,
meaning value,
null description
from
hr_lookups
where lookup_type='BEN_LESUM_LER_TYPE'
and enabled_flag='Y'
and sysdate between start_date_active
and nvl(end_date_active,sysdate)
order by meaning
AR
نوع حدث العمر
D
Veränderungsart
E
Tipo de Evento Personal
F
Type d'événement personnel
I
Tipo evento vita
JA
ライフ・イベント・タイプ
KO
Life Event 유형
PTB
Tipo de Evento de Vida
RU
Тип жизненного события
S
Typ av livshändelse
TR
Önemli Kişisel Olay Tipi
US
Life Event Type
ZHS
人生事件类型
18
170
:p_sort_order_1
LOV Oracle
BEN_LESUM_SORT_ORDR
Y
select
lookup_code id,
meaning value,
null description
from
hr_lookups
where lookup_type='BEN_LESUM_SORT_ORDR'
and enabled_flag='Y'
and sysdate between start_date_active
and nvl(end_date_active,sysdate)
order by meaning
Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_SORT_ORDR' and lookup_code = 'PERNAME' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
AR
ترتيب الفرز 1
D
Sortierfolge 1
E
Orden de Clasificación 1
F
Ordre de tri 1
I
Ordinamento 1
JA
ソート順1
KO
정렬 순서 1
PTB
Ordem de Classificação 1
RU
Порядок сортировки 1
S
Sorteringsordning 1
TR
Sıralama Düzeni 1
US
Sort Order 1
ZHS
排序顺序 1
19
180
:p_sort_order_2
LOV Oracle
BEN_LESUM_SORT_ORDR
Y
select
lookup_code id,
meaning value,
null description
from
hr_lookups
where lookup_type='BEN_LESUM_SORT_ORDR'
and enabled_flag='Y'
and sysdate between start_date_active
and nvl(end_date_active,sysdate)
order by meaning
Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_SORT_ORDR' and lookup_code = 'LESTAT' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
AR
ترتيب الفرز 2
D
Sortierfolge 2
E
Orden de Clasificación 2
F
Ordre de tri 2
I
Ordinamento 2
JA
ソート順2
KO
정렬 순서 2
PTB
Ordem de Classificação 2
RU
Порядок сортировки 2
S
Sorteringsordning 2
TR
Sıralama Düzeni 2
US
Sort Order 2
ZHS
排序顺序 2
20
190
:p_sort_order_3
LOV Oracle
BEN_LESUM_SORT_ORDR
Y
select
lookup_code id,
meaning value,
null description
from
hr_lookups
where lookup_type='BEN_LESUM_SORT_ORDR'
and enabled_flag='Y'
and sysdate between start_date_active
and nvl(end_date_active,sysdate)
order by meaning
Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_SORT_ORDR' and lookup_code = 'LERNAME' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
AR
ترتيب الفرز 3
D
Sortierfolge 3
E
Orden de Clasificación 3
F
Ordre de tri 3
I
Ordinamento 3
JA
ソート順3
KO
정렬 순서 3
PTB
Ordem de Classificação 3
RU
Порядок сортировки 3
S
Sorteringsordning 3
TR
Sıralama Düzeni 3
US
Sort Order 3
ZHS
排序顺序 3
21
200
:p_sort_order_4
LOV Oracle
BEN_LESUM_SORT_ORDR
Y
select
lookup_code id,
meaning value,
null description
from
hr_lookups
where lookup_type='BEN_LESUM_SORT_ORDR'
and enabled_flag='Y'
and sysdate between start_date_active
and nvl(end_date_active,sysdate)
order by meaning
Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_SORT_ORDR' and lookup_code = 'LEOCRDDT' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
AR
ترتيب الفرز 4
D
Sortierfolge 4
E
Orden de Clasificación 4
F
Ordre de tri 4
I
Ordinamento 4
JA
ソート順4
KO
정렬 순서 4
PTB
Ordem de Classificação 4
RU
Порядок сортировки 4
S
Sorteringsordning 4
TR
Sıralama Düzeni 4
US
Sort Order 4
ZHS
排序顺序 4
22
210
:p_disp_flex_fields_flag
LOV Oracle
Yes_No
Y
select
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,description
select meaning from hr_lookups where lookup_type='YES_NO' and lookup_code='N' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
AR
عرض الحقول المرنة
D
FlexFelder anzeigen
E
Mostrar Estructuras
F
Afficher les champs flexibles
I
Visualizza flexfield
JA
フレックスフィールドの表示
KO
가변필드 표시
PTB
Exibir Flexfields
RU
Вывод гибких полей
S
Visa flexfält
TR
Esnekalanları Görüntüle
US
Display Flexfields
ZHS
显示弹性域