eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_SICKNESS_ABSENCE dependencies on PER_PERIODS_OF_SERVICE

Line 388: From per_periods_of_service ppos

384: --
385: -- Defining cursor selecting hiredate
386: Cursor csr_assg_hiredate(c_person_id number) is
387: Select max(ppos.date_start)
388: From per_periods_of_service ppos
389: Where ppos.person_id = c_person_id
390: And ppos.date_start <= p_date_start;
391: --
392: -- Cursor to sum up existing absences against entitled holidays

Line 509: From per_periods_of_service ppos

505: --
506: -- Defining cursor selecting hiredate
507: Cursor csr_assg_hiredate(c_person_id number) is
508: Select max(ppos.date_start)
509: From per_periods_of_service ppos
510: Where ppos.person_id = c_person_id
511: And ppos.date_start <= p_date_start;
512: --
513: -- Cursor to sum up existing absences against entitled holidays