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.GHR_PAR_BUS dependencies on HR_LOOKUPS

Line 905: from hr_lookups hl ,

901:
902: cursor c_la_code is
903: select hl.lookup_code ,
904: hl.meaning
905: from hr_lookups hl ,
906: ghr_noac_las nla
907: where nla.nature_of_action_id = p_first_nature_of_action_id
908: and SUBSTR(nla.lac_lookup_code,1,3) = p_first_action_la_code1
909: and nla.valid_first_lac_flag = 'Y'

Line 982: from hr_lookups hl,

978: -- while checking the LAC codes which are duplicated. Like VWN and VWN1 etc.
979: cursor c_la_code is
980: select hl.lookup_code ,
981: hl.meaning
982: from hr_lookups hl,
983: ghr_noac_las nla
984: where nla.nature_of_action_id = p_first_nature_of_action_id
985: and SUBSTR(nla.lac_lookup_code,1,3) = p_first_action_la_code2
986: and nla.valid_second_lac_flag = 'Y'

Line 1159: from hr_lookups hl ,

1155: -- while checking the LAC codes which are duplicated. Like VWN and VWN1 etc.
1156: cursor c_la_code is
1157: select hl.lookup_code ,
1158: hl.meaning
1159: from hr_lookups hl ,
1160: ghr_noac_las nla
1161: where nla.nature_of_action_id = p_second_nature_of_action_id
1162: and SUBSTR(nla.lac_lookup_code,1,3) = p_second_action_la_code1
1163: and nla.valid_first_lac_flag = 'Y'

Line 1236: from hr_lookups hl ,

1232: -- while checking the LAC codes which are duplicated. Like VWN and VWN1 etc.
1233: cursor c_la_code is
1234: select hl.lookup_code ,
1235: hl.meaning
1236: from hr_lookups hl ,
1237: ghr_noac_las nla
1238: where nla.nature_of_action_id = p_second_nature_of_action_id
1239: and substr(nla.lac_lookup_code,1,3) = p_second_action_la_code2
1240: and nla.valid_second_lac_flag = 'Y'