Danish Halim: Oracle apps EBS r12 Report for the HRMS and Payroll Report - Report Name

Monday, 22 October 2018

Oracle apps EBS r12 Report for the HRMS and Payroll Report - Report Name - Temporary Employment Review Form

Oracle apps EBS r12 Report for the HRMS and Payroll Report - Report Name - Temporary Employment Review Form

Template File - RTF File Design :

Download the Format of the RTF File means Template File:

https://drive.google.com/file/d/1P5D8SxMae-0pTqJ6e9WGByiKl4KwWlMs/view?usp=sharing

Format Like This.

XX Chemical Division

TEMPORARY EMPLOYMENT REVIEW FORM

To: MR. HEAD Department: DEP

Designation: DESIG Legal Entity: LEGAL

Subject: Temporary Employee Status Review

Name of the Employee: NAME Employee No.: NUM

Designation: DESIG Grade: GRADE

Date of Joining: JOIN_DTE Date of Birth: DOB

Date of Retirement: RET_DATE Age: AGE

Start Date of Agreement: AGR_SD End Date of Agreement: AGR_ED

Please enter your recommendations in the spaces provided below and return it to HRD by DATE

HOD_DESG: Date: ______/______/_______

Recommendations: Please mark with "X" in the box.

	Contractual to Regular Employee with effect from normal due date shown above.

	Extension of temporary employment by _____ months / years.

	Termination of services. Reasons:

	Any Comments:

.
Performance Feedback (1-10 Scales)	1 2	3 4	5 6	7 8	9 10
(Please tick)	Poor	Below Average	Average	Good	Outstanding
.

Special Considerations: (If considered)

a. Present Basic: Tk. BASIC b. Present Gross Salary: Tk. GROS

c. Total Increase: Tk. TOTAL_INC d. New Gross Salary: Tk. NET_GROSS

HR Recommendations:

New Gross Salary: Tk. HR_REC_INC Total Increase: Tk. HR_GROSS

Comments:

Signed by	Signed by	Checked by	Approved by
Supervisor / Sub-Dept. Head / Dept. Head	Function / Dept. Head	HOD_DESG	Managing Director

----------------------------

---------------------------------- XXBEX_TEMP_EMP_REV.xml --------------------------

Data Definition File :

Download the Format of the Data Definition File ::

https://drive.google.com/file/d/1gvui7eY0iNQ9pli74XxVEz0AQqSbISvp/view?usp=sharing

<?xml version="1.0" encoding="UTF-8" ?>

</properties>

</parameters>

<![CDATA[

SELECT

(SELECT initcap(peop.title) title

FROM per_all_people_f peop

WHERE 1 =1

AND peop.person_id=:P_DEPT_HEAD

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN peop.effective_start_date AND peop.effective_end_date

) title_dep_head,

(SELECT trim(initcap(peop.first_name

||' '

||peop.middle_names

||DECODE(peop.middle_names,NULL,'',' ')

||peop.last_name)) full_name

FROM per_all_people_f peop

WHERE 1 =1

AND peop.person_id=:P_DEPT_HEAD

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN peop.effective_start_date AND peop.effective_end_date

) name_of_dep_head,

(SELECT SUBSTR(pp.NAME,instr(pp.NAME,'|',1,2)+1)

FROM per_all_positions pp,

per_all_assignments_f asgn

WHERE 1 =1

AND asgn.position_id =pp.position_id(+)

AND asgn.business_group_id=pp.business_group_id

AND asgn.person_id =:P_DEPT_HEAD

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN asgn.effective_start_date AND asgn.effective_end_date

) dep_head_dep,

(SELECT pj.NAME

FROM per_jobs pj,

per_all_assignments_f asgn

WHERE 1 =1

AND asgn.job_id =pj.job_id(+)

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN asgn.effective_start_date AND asgn.effective_end_date

AND asgn.person_id=:P_DEPT_HEAD

) des_of_dept_head,

(SELECT DECODE(pgd.segment1,'BAIL','Bangladesh Antibiotic Industries Limited', 'BPL','Beximco Pharmaceuticals Limited','IIS','I'

||'&'

||'I Services Limited','PCL','Pharmatek Chemicals Limited','SPL','Shuktara Printers Limited')

FROM per_grade_definitions pgd,

per_grades pg,

per_all_assignments_f asgn

WHERE 1 =1

AND pgd.grade_definition_id=pg.grade_definition_id

AND asgn.grade_id =pg.grade_id(+)

AND asgn.person_id =:P_DEPT_HEAD

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN asgn.effective_start_date AND asgn.effective_end_date

) legal_entity,

papf.person_id person_id,

trim(initcap(papf.first_name

||' '

||papf.middle_names

||DECODE(papf.middle_names,NULL,'',' ')

||papf.last_name)) name_of_temp_emp,

papf.employee_number employee_number,

pj.NAME des_of_temp_emp,

TO_CHAR(ppos.date_start,'DD-Mon-YYYY') joining_date,

substr(pg.name,instr(pg.name,'.')+1) grade_of_temp_emp,

TO_CHAR(papf.date_of_birth,'DD-Mon-YYYY') date_of_birth,

TO_CHAR(papf.date_of_birth,'DD-Mon-')

||TO_CHAR(EXTRACT(YEAR FROM SYSDATE)+(60-ROUND((SYSDATE-papf.date_of_birth)/365.25))) date_of_retirement,

ROUND((SYSDATE -papf.date_of_birth)/365.25) age,

(SELECT TO_CHAR(pcf.effective_start_date,'DD-Mon-YYYY')

FROM per_contracts_f pcf

WHERE 1 =1

AND pcf.person_id=papf.person_id

AND pcf.status ='A-ACTIVE'

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN pcf.effective_start_date AND pcf.effective_end_date

) start_date_of_temp_agr,

(SELECT TO_CHAR(cont.effective_end_date,'DD-Mon-YYYY')

FROM per_contracts_f cont

WHERE 1 =1

AND cont.person_id=papf.person_id

AND cont.status ='A-ACTIVE'

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN cont.effective_start_date AND cont.effective_end_date

) end_date_of_temp_agr,

TO_CHAR(to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss'),'DD-Mon-YYYY') "DATE",

(SELECT

NVL(PJ.NAME,'No Job Assigned') HOD_POSITION

FROM per_people_extra_info pei,

per_all_people_f ppf,

per_all_assignments_f paaf,

per_jobs pj,

per_all_positions pos,

per_position_definitions ppd,

fnd_user usr,

pqh_roles rls

WHERE information_type = 'PQH_ROLE_USERS'

AND pei.person_id = ppf.person_id

AND usr.employee_id = ppf.person_id

and ppf.PERSON_ID=paaf.PERSON_ID

and paaf.JOB_ID=pj.JOB_ID(+)

and trunc(sysdate) between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE

and paaf.BUSINESS_GROUP_ID=ppf.BUSINESS_GROUP_ID

and paaf.position_id=pos.position_id(+)

and pos.POSITION_DEFINITION_ID=ppd.POSITION_DEFINITION_ID(+)

AND rls.role_id = TO_NUMBER (pei.pei_information3)

AND NVL (pei.pei_information5, 'Y') = 'Y'

and rls.role_name ='HR Letters Signatory') des_of_hr_hod,

ppp.proposed_salary_n present_basic_salary,

ppp.attribute14 present_gross_salary,

:P_HOD_HR hod_hr,

:P_TOTAL_INC total_inc,

:P_NET_GROSS net_gross,

:P_HR_REC_INC hr_rec_inc,

:P_HR_REC_GROSS_SAL hr_rec_gross_sal

FROM per_all_people_f papf,

per_all_assignments_f paaf,

per_jobs pj,

per_grades pg,

per_pay_proposals ppp,

per_periods_of_service ppos

WHERE 1 =1

AND papf.person_id =paaf.person_id

AND paaf.job_id =pj.job_id

AND paaf.grade_id =pg.grade_id

AND paaf.assignment_id=ppp.assignment_id

AND ppos.person_id =papf.person_id

AND paaf.period_of_service_id=ppos.period_of_service_id

AND ppos.actual_termination_date is null

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN paaf.effective_start_date AND paaf.effective_end_date

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN papf.effective_start_date AND papf.effective_end_date

AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN ppp.change_date AND ppp.date_to +1

AND papf.person_id=NVL(:P_EMP_NUM,papf.person_id)

]]>

</sqlStatement>

</dataQuery>

</group>

</dataStructure>

</dataTemplate>

---------------------------------- End----------------

Download the Format of the XXBEX_TEMP_EMP_REV.rtf::

https://drive.google.com/file/d/1P5D8SxMae-0pTqJ6e9WGByiKl4KwWlMs/view?usp=sharing

Download the Format of the XXBEX_TEMP_EMP_REV.xml ::

https://drive.google.com/file/d/1gvui7eY0iNQ9pli74XxVEz0AQqSbISvp/view?usp=sharing

Download the Format of the XXBEX_TEMP_EMP_REV_CP.ldt::

https://drive.google.com/file/d/1Jm58GEDorMTw4vbW42w4600D8slakL4P/view?usp=sharing

Download the Format of the XXBEX_TEMP_EMP_REV_DD.ldt ::

https://drive.google.com/file/d/1X1rchx-Ck2-ADxNF075sSRDMJb-5kHoM/view?usp=sharing

Download the Format of the XXBEX_TEMP_EMP_REV_REQ.ldt::

https://drive.google.com/file/d/11qgP3PnpyhQfrEL3CSJLH222PTjoYo9I/view?usp=sharing

Danish Halim

Monday, 22 October 2018

Oracle apps EBS r12 Report for the HRMS and Payroll Report - Report Name - Temporary Employment Review Form

Name of the Employee: NAME Employee No.: NUM

Designation: DESIG Grade: GRADE

Date of Joining: JOIN_DTE Date of Birth: DOB

Date of Retirement: RET_DATE Age: AGE

No comments:

Post a Comment

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)