Skip to main content

Annual Leave Balance in Oracle HRMS

In oracle HRMS annual leave balance is saved in SIT.
we can find the balance info for employees by this query.

SELECT distinct papf.employee_number,papf.full_name,papf.email_address,pac.segment1 leave_type,pac.segment3 leave_balance
  FROM apps.fnd_id_flex_structures fifs,
       per_person_analyses ppa,
       hr.per_all_people_f papf,
       per_analysis_criteria pac,
       xxgp.xxgp_all_employee_info xae
 WHERE fifs.id_flex_structure_code = 'XXGP_LEAVE_BALANCE_DETAILS'
   and pac.segment1='Annual Leave'
   and PAPF.EMPLOYEE_NUMBER= xae.employee_number
   AND ppa.id_flex_num = fifs.id_flex_num
   AND ppa.person_id = papf.person_id
   AND ppa.analysis_criteria_id = pac.analysis_criteria_id
   AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date
                                    AND papf.effective_end_date                                  
   order by employee_number asc
Labels:

Comments

  1. Shagul.HJanuary 9, 2017 at 1:28 AM

    xxgp.xxgp_all_employee_info xae ??

    ReplyDelete
  2. sofiananJuly 27, 2018 at 10:44 PM

    Hey, Wow Provided Post will be Very much Informative to the People Who Visit this Site. Good Work! Thank You for Sharing.
    Automotive Services

    Construction Services

    ReplyDelete
  3. Credit Loan SolutionMarch 5, 2019 at 6:24 AM

    Are you tired of seeking loans and Mortgages,have you been turned down constantly By your banks and other financial institutions,We offer any form of loan to individuals and corporate bodies at low interest rate.If you are interested in taking a loan,feel free to contact us today,we promise to offer you the best services ever.Just give us a try,because a trial will convince you.What are your Financial needs?Do you need a business loan?Do you need a personal loan?Do you want to buy a car?Do you want to refinance?Do you need a mortgage loan?Do you need a huge capital to start off your business proposal or expansion? Have you lost hope and you think there is no way out, and your financial burdens still persists? Contact us (gaincreditloan1@gmail.com)

    Your Name:...............
    Your Country:...............
    Your Occupation:...............
    Loan Amount Needed:...............
    Loan Duration...............
    Monthly Income:...............
    Your Telephone Number:.....................
    Business Plan/Use Of Your Loan:...............
    Contact Us At : gaincreditloan1@gmail.com
    Phone number :+1-270-551-4764 (WhatsApp Only)

    ReplyDelete
  4. fautuPsuppnoApril 24, 2022 at 7:59 AM

    fautuPsuppno Robin Brown https://wakelet.com/wake/e1MX0yEO9AD3xPVdAaNEU
    zievatycatch

    ReplyDelete
  5. 0casidu-mo-1979July 31, 2022 at 10:26 PM

    0luntaprot_za Steven Holmes link
    download
    download
    https://colab.research.google.com/drive/1BsQCbl3Foij__67vyUppgVCP7XSVokja
    terpeovevi

    ReplyDelete
  6. onorhau-kiNovember 30, 2022 at 10:10 PM

    Wcrattanapht_go Carlos Ruiz
    There
    carnidoma

    ReplyDelete

Post a Comment

Popular posts from this blog

How to get iRecruitment Vacancy details in Oracle HRMS before Vacancy is approved.

Generally details of Vacancies created in Oracle iRecruitment are store in ‘PER_ALL_VACANCIES’ table. But you cant see the vacancy details in ‘PER_ALL_VACANCIES’ table if the vacancy is NOT approved . Where does Vacancy details get stored  before Approval/Rejection As soon as vacancy is created the vacancy related data goes and resides in some temporary tables. This data is retained within the temporary tables until the vacancy is either Rejected or Approved. These temporary table names begin with name ‘HR_API%’. Not only vacancies but also other Self Service HRMS details are stored in temporary table before completion of it entire transaction, i.e either Approved or Rejected. Coming to iRecruitment vacancy, the data entered by the user is either just stored within one table HR_API_TRANSACTIONS or within HR_API_TRANSACTION_VALUES. The entire data entered by the user is captured in a CLOB column of HR_API_TRANSACTIONS. The data is captured into this CLOB Column be...
1 comment
Read more

How to deploy Oracle Custom Application developed in OAF in Oracle Application Server

Step 1:Create your necessary Database Obejcts i.e.Tables,Views,Sequences,Synonims in Apps schema. i) CREATE TABLE apps.XXGP_JDMS_APP_TABLE (   JD_ID               VARCHAR2 ( 100 BYTE),   APP_USER_NAME       VARCHAR2 ( 100 BYTE),   APP_STATUS          VARCHAR2 ( 100 BYTE),   APP_LEVEL           NUMBER ,   APPROVER_COMMENTS   VARCHAR2 ( 1000 BYTE),   NOTIFICATION_ID     VARCHAR2 ( 100 BYTE),   CREATED_BY          NUMBER ,   CREATION_DATE       DATE ,   LAST_UPDATE_LOGIN   NUMBER ,   LAST_UPDATED_BY     NUMBER ,   LAST_UPDATE_DATE    DATE ) ii) DROP SEQUENCE APPS . GP_JDMS_TRX_SEQ ; CREATE SEQUEN...
Post a Comment
Read more

Query for Employee's Time Card information retrieval

SELECT DISTINCT paaf.assignment_id, hshwf.date_worked,                          TO_CHAR (hshwf.date_worked, 'YYYY') YEAR,                          TO_CHAR (hshwf.date_worked, 'Month') MONTH,                          papf.employee_number,                          hshwf.time_in, hshwf.time_out, hshwf.hours,                          --petf.element_name,                          (select petf1.element_name                           from hr.pay_element_types_f petf1                     ...
Post a Comment
Read more