Useful LookupsPrimary tabs

Submitted by code_admin on Tue, 07/17/2018 - 12:51
  1. SELECT
  2.     hr_reports.get_lookup_meaning('LEAV_REAS', :leav_reas),
  3.     hr_general.DECODE_ASS_STATUS_TYPE(:ass_stat,:p_business_group_id),
  4.     hr_general.DECODE_ORGANIZATION(:org),
  5.     hr_general.DECODE_PAYROLL(:payroll),
  6.     hr_general.DECODE_PEOPLE_GROUP(:ppl),
  7.     hr_general.DECODE_GRADE(:gra),
  8.     hr_general.DECODE_POSITION(:pos),
  9.     hr_general.DECODE_LOCATION(:loc),
  10.     hr_general.decode_lookup ('GB_COUNTY', :region_1) ,
  11.     hr_general.decode_lookup ('ETH_TYPE', :region_2),
  12.     hr_general.DECODE_JOB(:job),
  13.     fnd_global.user_id,
  14.     fnd_global.per_business_group_id
  15.     fnd_global.login_id,
  16.     apps.fnd_profile.value('USER_ID'),
  17.     apps.fnd_profile.value('RESP_ID'),
  18.     apps.fnd_profile.value('APPLICATION_ID'), --NOT SURE ABOUT THIS ONE
  19.     apps.FND_PROFILE.VALUE('ORG_ID')
  20. FROM dual

If this isn't working

Search Terms

Business Group ID, Profile

RJM Article Type
Quick Reference