Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
PAY: pay_element_entry_api.create_element_entry
Hello Guys,
Declare
Below is the code for the element entry in the custom form the upload the element values.
l_effective_start_date date ;
l_effective_end_date date ;
l_element_entry_id number(30) ;
l_object_version_number number(30) ;
l_create_warning boolean ;
err_num number;
err_msg varchar2(2000);
CURSOR C1 IS
select A.EMP_ID,A.LATE_HOURS,A.EARLY_HOURS,papf.EMPLOYEE_NUMBER,papf.person_id,paaf.assignment_ID,Paaf.payroll_ID,
decode(Paaf.payroll_ID,61,'3121',62,'3123',81,'3122',' ') Element_Link_ID
from
XX_ATTENDANCE_SUMMARY a,
per_all_people_f papf,
1