eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_HRTCA_INTEGRATION dependencies on HR_LOOKUPS

Line 61: FROM hr_lookups hrl

57: ,c_meaning IN Varchar2
58: ,c_effective_date IN Date) IS
59: SELECT hrl.meaning
60: ,hrl.lookup_code
61: FROM hr_lookups hrl
62: WHERE hrl.lookup_type = c_lookup_type
63: AND (Upper(hrl.meaning) = Upper(c_meaning)
64: OR
65: Upper(hrl.lookup_code) = Upper(c_meaning)

Line 78: FROM hr_lookups hrl,

74: SELECT hrl.lookup_code ins_code
75: ,hrl.meaning ins_mapping
76: ,irs.lookup_code irs_code
77: ,irs.meaning irs_meaning
78: FROM hr_lookups hrl,
79: hr_lookups irs
80: WHERE hrl.lookup_type = 'PQP_US_COUNTRY_TRANSLATE'
81: AND hrl.enabled_flag = 'Y'
82: AND irs.lookup_type = 'PER_US_COUNTRY_CODE'

Line 79: hr_lookups irs

75: ,hrl.meaning ins_mapping
76: ,irs.lookup_code irs_code
77: ,irs.meaning irs_meaning
78: FROM hr_lookups hrl,
79: hr_lookups irs
80: WHERE hrl.lookup_type = 'PQP_US_COUNTRY_TRANSLATE'
81: AND hrl.enabled_flag = 'Y'
82: AND irs.lookup_type = 'PER_US_COUNTRY_CODE'
83: AND irs.enabled_flag = 'Y'