Search This Blog

Monday, April 6, 2015

Global Values from backend.....

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.   

No comments:

Post a Comment