-
SELECT
-
hr_reports.get_lookup_meaning('LEAV_REAS', :leav_reas),
-
hr_general.DECODE_ASS_STATUS_TYPE(:ass_stat,:p_business_group_id),
-
hr_general.DECODE_ORGANIZATION(:org),
-
hr_general.DECODE_PAYROLL(:payroll),
-
hr_general.DECODE_PEOPLE_GROUP(:ppl),
-
hr_general.DECODE_GRADE(:gra),
-
hr_general.DECODE_POSITION(:pos),
-
hr_general.DECODE_LOCATION(:loc),
-
hr_general.decode_lookup ('GB_COUNTY', :region_1) ,
-
hr_general.decode_lookup ('ETH_TYPE', :region_2),
-
hr_general.DECODE_JOB(:job),
-
fnd_global.user_id,
-
fnd_global.per_business_group_id
-
fnd_global.login_id,
-
apps.fnd_profile.value('USER_ID'),
-
apps.fnd_profile.value('RESP_ID'),
-
apps.fnd_profile.value('APPLICATION_ID'), --NOT SURE ABOUT THIS ONE
-
apps.FND_PROFILE.VALUE('ORG_ID')
-
FROM dual
If this isn't working
- Enter an effective into your session
- Run Apps Instalise
Search Terms
Business Group ID, Profile
RJM Article Type
Quick Reference