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.PER_POS_BUS dependencies on HR_LOCATIONS

Line 540: -- HR_LOCATIONS table and are active for the PER_POSITIONS.DATE_EFFECTIVE

536: -- organization's LOCATION_ID is null the value for the business group is
537: -- selected.
538: --
539: -- Validates that values entered for this column exist in the
540: -- HR_LOCATIONS table and are active for the PER_POSITIONS.DATE_EFFECTIVE
541: -- i.e. HR_LOCATIONS.INACTIVE_DATE must be null or greater than
542: -- PER_POSITIONS.DATE_EFFECTIVE
543: --
544: -- Pre-conditions:

Line 541: -- i.e. HR_LOCATIONS.INACTIVE_DATE must be null or greater than

537: -- selected.
538: --
539: -- Validates that values entered for this column exist in the
540: -- HR_LOCATIONS table and are active for the PER_POSITIONS.DATE_EFFECTIVE
541: -- i.e. HR_LOCATIONS.INACTIVE_DATE must be null or greater than
542: -- PER_POSITIONS.DATE_EFFECTIVE
543: --
544: -- Pre-conditions:
545: -- Format for p_date_effective must be correct

Line 581: from hr_locations loc

577: l_api_updating boolean;
578: --
579: cursor csr_valid_location is
580: select 'x'
581: from hr_locations loc
582: where loc.location_id = p_location_id
583: and p_date_effective < nvl(loc.inactive_date,
584: hr_api.g_eot);
585: --