Who's Online
0 registered (), 11 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Interfacing iRec and external sites
by DanC
Yesterday at 11:42 PM
Time and Labour & Oracle Projects
by Paul
Yesterday at 07:34 PM
End of Year Legislation Patch for 11i
by delboy
Yesterday at 02:00 PM
Search Engine Optimizers
by delboy
Yesterday at 01:30 PM
Abseces in oracle hrms, super user: how to do I:
by JayTee
Yesterday at 07:26 AM
Update EIT in SSHR
by Mr Oracle
08/02/12 01:50 PM
Function for getting retropay-maintained balances
by CT
08/02/12 12:21 PM
Grade End Date
by Chris
03/02/12 10:46 AM
OLM Mandatory Enrolments
by bcooper
01/02/12 12:23 PM
Retro-Notifs Report missing some ele entries
by CT
01/02/12 06:51 AM
Top Posters (30 Days)
CT 27
delboy 25
bcooper 14
Gus 5
paulgos 5
Sahir 4
tovia123 4
SBi 3
MichaelWest 3
Simon_Mc 3
(Views)Popular Topics
Family Pack K issues thread 18194
CREATE_GRADE api returns:PLS-00306: wrong number o 13736
Still trying to locate... 12185
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 10634
Viewing Output of another user 9123
HR_PF.K RUP4 8816
Review of my Release 12 laptop 8485
Adding a taskflow button to a form 7842
Enhanced Retro & Release 12 7661
Family Pack K 7102
Topic Options
Rate This Topic
#4370 - 14/04/09 08:00 AM SSP Paid Days
kp_rapolu Offline
claiming squatters rights

Registered: 15/11/07
Posts: 213
Loc: U.K
Hi,

I am looking for function to get the SSP Paid days for employee in a given start & end dates.

Please advice.


thanks
KP/..
_________________________
Krishna Prasad Rapolu
Oracle HRMS Consultant

Top
#4376 - 15/04/09 05:45 AM Re: SSP Paid Days [Re: kp_rapolu]
delboy Offline
battle-hardened campaigner

Registered: 15/03/05
Posts: 499
Loc: Somewhere in Berkshire
Hi KP,

There are functions that return the amount of SSP for a given start and end date. Not sure there is one for the number of days?

Delboy

Top
#4381 - 15/04/09 04:43 PM Re: SSP Paid Days [Re: delboy]
kp_rapolu Offline
claiming squatters rights

Registered: 15/11/07
Posts: 213
Loc: U.K
I am not able to find the function, So I am doing reverse engineering.

Calling the function to get the SSP amount for a given start and end dates, then dividing it by SSP daily rate to get the number of Paid days.
_________________________
Krishna Prasad Rapolu
Oracle HRMS Consultant

Top



Moderator:  bcooper, CT 
Forum Stats
755 Members
48 Forums
1516 Topics
7282 Posts

Max Online: 63 @ 24/11/10 07:21 AM
Today's Birthdays
No Birthdays
Recent vacancies
Tea boy available 4 basic chores & some! services
by Simon_Mc
19/01/12 03:59 PM
Top Posters
bcooper 1094
CT 1080
delboy 499
Geoff Dixon 369
SBi 344
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 160
Gus 132
February
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29