ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717E51A9E05362FB09050512Y select per.person_id pid, per.last_name surname, per.first_name first_name, hr_general.decode_lookup('SEX',per.sex) gender, to_char(per.date_of_birth,'YYYY') year_of_birth, --trunc(to_number(months_between(:pc_31dec_m,per.date_of_birth)/12)) age, trunc(months_between(:pc_31dec,per.date_of_birth)/12) age, decode(pdf.category,'A','A','B','B','C','C') cotorep_category, pdf.dis_information2 previous_cotorep, decode(pdf.reason,'OCC_INC','Y','N') due_to_wa, pdf.degree disability_rate, hr_general.decode_lookup('FR_INVALIDITY_CLASS',pdf.dis_information1) disability_class, pdf.dis_information1 disability_class_code, pdf.effective_start_date disability_start_date, pdf.effective_end_date disability_end_date, PER_PERFRD2R_XMLP_PKG.fc_set_job_infoformula(per.person_id) FC_SET_JOB_INFO, PER_PERFRD2R_XMLP_PKG.PC_HIRE_YEAR_p PC_HIRE_YEAR, PER_PERFRD2R_XMLP_PKG.PC_YEAR_BECAME_PERMANENT_p PC_YEAR_BECAME_PERMANENT, PER_PERFRD2R_XMLP_PKG.PC_JOB_TITLE_p PC_JOB_TITLE, PER_PERFRD2R_XMLP_PKG.PC_HOURS_TRAINING_p PC_HOURS_TRAINING, PER_PERFRD2R_XMLP_PKG.PC_PCS_CODE_p PC_PCS_CODE, --PER_PERFRD2R_XMLP_PKG.c_set_unitsformula(decode ( pdf.category , 'A' , 'A' , 'B' , 'B' , 'C' , 'C' ), trunc(to_number(months_between (:pc_31dec_m , per.date_of_birth ) / 12)), pdf.dis_information2, pdf.degree, decode ( pdf.reason , 'OCC_INC' , 'Y' , 'N' ), pdf.dis_information1, per.person_id) FC_SET_UNITS, PER_PERFRD2R_XMLP_PKG.c_set_unitsformula(decode ( pdf.category , 'A' , 'A' , 'B' , 'B' , 'C' , 'C' ), trunc(months_between (:pc_31dec , per.date_of_birth ) / 12), pdf.dis_information2, pdf.degree, decode ( pdf.reason , 'OCC_INC' , 'Y' , 'N' ), pdf.dis_information1, per.person_id) FC_SET_UNITS, PER_PERFRD2R_XMLP_PKG.PC_UNITS_TOTAL_p PC_UNITS_TOTAL, PER_PERFRD2R_XMLP_PKG.PC_UNITS_COEF_p PC_UNITS_COEF, PER_PERFRD2R_XMLP_PKG.PC_UNITS_ACTUAL_p PC_UNITS_ACTUAL from per_all_people_f per, per_disabilities_f pdf where pdf.person_id = per.person_id and per.effective_start_date = (select max(effective_start_date) from per_all_people_f where person_id = per.person_id and effective_start_date <= :pc_31dec) &pc_disabled_where_clause and (pdf.category in ('A','B','C') or pdf.reason = 'OCC_INC' or pdf.dis_information1 in ('CIVIL','MILITARY','MILITARY_EQUIVALENT')) and pdf.DIS_INFORMATION_CATEGORY='FR' /*order by disability_end_date*/ order by per.last_name, per.first_name, pdf.effective_end_date PER PERFRD2R_XML F PER France - Etat D2 Imported from BI Publisher Description: France - Etat D2 Application: Human Resources Source: France - Etat D2 (XML) Short Name: PERFRD2R_XML DB package: PER_PERFRD2R_XMLP_PKG US PER French D2 Imported from BI Publisher Description: French D2 Report Application: Human Resources Source: French D2 Report (XML) Short Name: PERFRD2R_XML DB package: PER_PERFRD2R_XMLP_PKG BI Publisher &pc_disabled_where_clause :p_conc_request_id :p_establishment_id :p_year :p_year_first_obligation :pc_1jan :pc_31dec :pc_31dec_m :pc_basis_obligation :pc_breakdown_particular :pc_count_disabled :pc_disabled_where_clause :pc_headcount_obligation :pc_headcount_particular :pc_hire_year :pc_hours_training :pc_job_title :pc_obligation :pc_pcs_code :pc_units_actual :pc_units_coef :pc_units_total :pc_year_became_permanent 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y F ID entité professionnelle ID entité professionnelle US Business Group Id Business Group Id 2 10 :p_establishment_id LOV Oracle HR_FR_ESTABLISHMENTS Y select organization_id id, name value, null description from hr_organization_units where business_group_id=fnd_global.per_business_group_id and organization_id in (select organization_id from hr_organization_information where org_information1='FR_ETABLISSEMENT' and org_information_context='CLASS') order by value,description Y F Etablissement ID établissement US Establishment Establishment Id 3 20 :p_year Number Select to_number(substr(to_char(sysdate,'DD-MM-YYYY'),7,4))-1 from dual Y F Année Année US Year Year 4 30 :p_year_first_obligation Number F Première année engagement Première année engagement US Year First Obligation Year First Obligation