1. GLOBAL VALUES:
TOTAL COMPENSATION> BASIC> GLOBAL VALUES
F11
'JOB_HARDSHIP_RATE' CHECK THE VALUE
SELECT NVL(GLOBAL_VALUE,0)
FROM ff_globals_f_vl b, hr_lookups hlu, fnd_sessions ses
WHERE hlu.lookup_type = 'DATA_TYPE'
AND hlu.lookup_code = b.data_type
AND ses.session_id = USERENV ('SESSIONID')
AND ses.effective_date BETWEEN b.effective_start_date AND b.effective_end_date
AND BASE_GLOBAL_NAME = 'JOB_HARDSHIP_RATE' ;
Above query depends on session id, so insert into table of fnd_sessions to view the data.
TO INSERT INTO FND_SESSIONS USE THE BELOW INSERT STATEMENT
Insert into fnd_sessions (session_id, effective_date)
values (userenv('sessionid'),SYSDATE)
TO GET THE SESSIONID INTHE REPORT, GO TO AFTER PARAMETER FORM
AND TYPE ABOVE THE INSERT STATEMENT.
TOTAL COMPENSATION> BASIC> GLOBAL VALUES
F11
'JOB_HARDSHIP_RATE' CHECK THE VALUE
SELECT NVL(GLOBAL_VALUE,0)
FROM ff_globals_f_vl b, hr_lookups hlu, fnd_sessions ses
WHERE hlu.lookup_type = 'DATA_TYPE'
AND hlu.lookup_code = b.data_type
AND ses.session_id = USERENV ('SESSIONID')
AND ses.effective_date BETWEEN b.effective_start_date AND b.effective_end_date
AND BASE_GLOBAL_NAME = 'JOB_HARDSHIP_RATE' ;
Above query depends on session id, so insert into table of fnd_sessions to view the data.
TO INSERT INTO FND_SESSIONS USE THE BELOW INSERT STATEMENT
Insert into fnd_sessions (session_id, effective_date)
values (userenv('sessionid'),SYSDATE)
TO GET THE SESSIONID INTHE REPORT, GO TO AFTER PARAMETER FORM
AND TYPE ABOVE THE INSERT STATEMENT.
No comments:
Post a Comment