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

Line 711: from hr_lookups

707: else
708: declare
709: cursor hlsel is
710: select null
711: from hr_lookups
712: where lookup_type = 'GB_BANKS'
713: and lookup_code = p_segment1;
714: l_dummy number;
715: begin

Line 879: cursor csr_chk_hr_lookups is

875: hr_utility.raise_error;
876: else
877: declare
878: l_exists varchar2(80);
879: cursor csr_chk_hr_lookups is
880: select null
881: from hr_lookups
882: where LOOKUP_TYPE = 'GB_COUNTRY'
883: and lookup_code = p_segment8;

Line 881: from hr_lookups

877: declare
878: l_exists varchar2(80);
879: cursor csr_chk_hr_lookups is
880: select null
881: from hr_lookups
882: where LOOKUP_TYPE = 'GB_COUNTRY'
883: and lookup_code = p_segment8;
884: begin
885: --

Line 886: -- ensure that the p_segment8 exists in hr_lookups where

882: where LOOKUP_TYPE = 'GB_COUNTRY'
883: and lookup_code = p_segment8;
884: begin
885: --
886: -- ensure that the p_segment8 exists in hr_lookups where
887: -- lookup_type = 'GB_COUNTRY'
888: --
889: open csr_chk_hr_lookups;
890: fetch csr_chk_hr_lookups into l_exists;

Line 889: open csr_chk_hr_lookups;

885: --
886: -- ensure that the p_segment8 exists in hr_lookups where
887: -- lookup_type = 'GB_COUNTRY'
888: --
889: open csr_chk_hr_lookups;
890: fetch csr_chk_hr_lookups into l_exists;
891: if csr_chk_hr_lookups%notfound then
892: close csr_chk_hr_lookups;
893: hr_utility.set_message(801,

Line 890: fetch csr_chk_hr_lookups into l_exists;

886: -- ensure that the p_segment8 exists in hr_lookups where
887: -- lookup_type = 'GB_COUNTRY'
888: --
889: open csr_chk_hr_lookups;
890: fetch csr_chk_hr_lookups into l_exists;
891: if csr_chk_hr_lookups%notfound then
892: close csr_chk_hr_lookups;
893: hr_utility.set_message(801,
894: 'HR_51430_EXA_BANK_LOC_UNKNOWN');

Line 891: if csr_chk_hr_lookups%notfound then

887: -- lookup_type = 'GB_COUNTRY'
888: --
889: open csr_chk_hr_lookups;
890: fetch csr_chk_hr_lookups into l_exists;
891: if csr_chk_hr_lookups%notfound then
892: close csr_chk_hr_lookups;
893: hr_utility.set_message(801,
894: 'HR_51430_EXA_BANK_LOC_UNKNOWN');
895: hr_utility.raise_error;

Line 892: close csr_chk_hr_lookups;

888: --
889: open csr_chk_hr_lookups;
890: fetch csr_chk_hr_lookups into l_exists;
891: if csr_chk_hr_lookups%notfound then
892: close csr_chk_hr_lookups;
893: hr_utility.set_message(801,
894: 'HR_51430_EXA_BANK_LOC_UNKNOWN');
895: hr_utility.raise_error;
896: end if;

Line 897: close csr_chk_hr_lookups;

893: hr_utility.set_message(801,
894: 'HR_51430_EXA_BANK_LOC_UNKNOWN');
895: hr_utility.raise_error;
896: end if;
897: close csr_chk_hr_lookups;
898: end; -- end of anonymous block
899: end if;
900: end if;
901: end if;