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_QH_POPULATE dependencies on HR_LOCATIONS

Line 17: l_location_name hr_locations.location_code%type;

13: function get_location
14: (p_location_id number) return varchar2 is
15: --
16: l_proc varchar2(72) :=g_package||'get_location';
17: l_location_name hr_locations.location_code%type;
18: --
19: cursor csr_location is
20: /*select location_code
21: from hr_locations

Line 21: from hr_locations

17: l_location_name hr_locations.location_code%type;
18: --
19: cursor csr_location is
20: /*select location_code
21: from hr_locations
22: where location_id=p_location_id;*/
23: --Modified as per bug 5504410
24: --
25: SELECT lot.location_code

Line 26: from hr_locations_all hrl, hr_locations_all_tl lot

22: where location_id=p_location_id;*/
23: --Modified as per bug 5504410
24: --
25: SELECT lot.location_code
26: from hr_locations_all hrl, hr_locations_all_tl lot
27: where hrl.location_id = lot.location_id
28: and lot.language = userenv('LANG')
29: and hrl.location_id=p_location_id;
30:

Line 311: ,p_location OUT NOCOPY hr_locations.location_code%type

307: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
308: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
309: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
310: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
311: ,p_location OUT NOCOPY hr_locations.location_code%type
312: ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type
313: ) is
314: --
315: l_proc varchar2(72) :=g_package||'get_bg_defaults';

Line 399: ,p_location OUT NOCOPY hr_locations.location_code%type

395: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
396: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
397: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
398: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
399: ,p_location OUT NOCOPY hr_locations.location_code%type
400: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
401: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
402: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
403: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

Line 434: l_location hr_locations.location_code%type;

430: l_payroll_id per_all_assignments_f.payroll_id%type;
431: l_supervisor_id per_all_assignments_f.supervisor_id%type;
432: l_grade_id per_all_assignments_f.grade_id%type;
433: l_frequency_meaning hr_lookups.meaning%type;
434: l_location hr_locations.location_code%type;
435: l_probation_unit_meaning hr_lookups.meaning%type;
436: l_salary_basis per_pay_bases.name%type;
437: l_pay_basis per_pay_bases.pay_basis%type;
438: l_payroll pay_all_payrolls_f.payroll_name%type;

Line 641: ,p_location OUT NOCOPY hr_locations.location_code%type

637: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
638: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
639: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
640: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
641: ,p_location OUT NOCOPY hr_locations.location_code%type
642: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
643: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
644: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
645: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

Line 834: ,p_location OUT NOCOPY hr_locations.location_code%type

830: ,p_position OUT NOCOPY hr_all_positions_f.name%type
831: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
832: ,p_job OUT NOCOPY per_jobs.name%type
833: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
834: ,p_location OUT NOCOPY hr_locations.location_code%type
835: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
836: ,p_organization OUT NOCOPY hr_organization_units.name%type
837: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
838: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type