Query to get Basic Salary from Grade Step in Fusion HCM

-
SELECT round(prvf.value, 2)
            FROM fusion.per_rates_f              prf,
           fusion.per_rate_values_f        prvf,
           fusion.per_assign_grade_steps_f pagsf,
           fusion.per_all_assignments_m    paam
     WHERE prf.rate_id = prvf.rate_id
       AND prf.rate_object_type = 'STEP'
       AND prf.grade_ladder_id = paam.grade_ladder_pgm_id
       AND TRUNC(P_DATE) BETWEEN prf.effective_start_date AND
           prf.effective_end_date
       AND prvf.rate_object_type = 'STEP'
       AND TRUNC(P_DATE) BETWEEN prvf.effective_start_date AND
           prvf.effective_end_date
       AND pagsf.grade_step_id = prvf.rate_object_id
       AND TRUNC(P_DATE) BETWEEN pagsf.effective_start_date AND
           pagsf.effective_end_date
       AND pagsf.assignment_id = paam.assignment_id
       and paam.assignment_type = 'E'
       AND PAAM.Assignment_Status_Type = 'ACTIVE'
       and paam.person_id = P_PERSON_ID
       and trunc(P_DATE) between paam.effective_start_date and
           paam.effective_end_date;

* P_DATE is the date on which the basic salary will be displayed

Comments

Post a Comment

Popular posts from this blog

Query to get Salary Change details in Fusion HCM

-
 SELECT papf.person_number PERSON_NUMBER, (select full_name from per_person_names_f ppnf where ppnf.person_id = papf.person_id and name_type = 'GLOBAL' and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name, ple.name LEGAL_EMPLOYE, (CASE  when cs.SALARY_BASIS_CODE = 'ANNUAL' THEN 'Salary Change'  else  'Hourly Rate Change' end)  ACTION_NAME, to_char(cs_old.salary_amount) OLD_DATA,  to_char(CS.salary_amount) NEW_DATA    ,TO_CHAR(cs.date_from, 'MM/DD/YYYY') EFFECTIVE_DATE    ,  TO_CHAR(cs.creation_date, 'MM/DD/YYYY') CHANGED_DATE    , cs.LAST_UPDATED_BY CHANGED_BY           from  fusion.CMP_SALARY cs,           CMP_SALARY cs_old,   PER_ALL_ASSIGNMENTS_M  PAAM,   PER_ALL_PEOPLE_F PAPF   ,per_legal_employers ple          where 1 = 1    AND PAPF.PERSON_ID = P...
Read more

CAPTCHA IMAGE GENERATION IN OAF PAGE

-
Image
THE DOCUMENT DESCRIBES HOW TO CREATE CAPTCHA IMAGE IN OAF PAGE: Step 1: get captcha: // to get the captchaImage Field in OAF page(code to be written in controller)=>     OAImageBean captchaImage = (OAImageBean)webBean.findIndexedChildRecursive("CaptchaImageField");     captchaImage.setSource("captchaservlet"); Step 2: Creation of captcha servlet: Step 3:  captchaservlet code to generate captcha image: import com.sun.java.util.collections.Random; import java.awt.Color; import java.awt.Font; import java.awt.Graphics2D; import java.awt.image.BufferedImage; import java.io.IOException; import java.io.OutputStream; import javax.imageio.ImageIO; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.awt.GradientPaint; import java.awt.RenderingHints;   public class CaptchaServlet ex...
Read more

Oracle Fusion HCM :: Creating and Assigning a Work Schedule Activity

-
A  Work Schedule Activity  defines a recurring period of work for employees, including hours, shifts, and work patterns. Assigning it ensures correct time, absence, and payroll calculations. 1. Navigate to Work Schedule Activities Login to  Oracle HCM Cloud . Navigate to: My Client Groups → Work Structures → Work Schedules → Work Schedule Activities Click  Tasks → Manage Work Schedule Activities . 2. Create a New Work Schedule Activity Click  Create . Enter the following details: Name : Descriptive name for the activity (e.g., “Regular Shift”). Code : Short identifier. Description : Optional, e.g., “Standard office hours 9 AM – 5 PM.” Assignment Type : Select  Full-Time ,  Part-Time , or other relevant type. Work Hours : Specify start time, end time, and duration. Frequency : Daily, weekly, or custom recurrence pattern. Time Zone : If your enterprise spans multiple regions. Optionally, define  Breaks : Break name, start, duration, and whether it’s...
Read more