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 318: ,p_location OUT NOCOPY hr_locations.location_code%type

314: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
315: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
316: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
317: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
318: ,p_location OUT NOCOPY hr_locations.location_code%type
319: ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type
320: ) is
321: --
322: l_proc varchar2(72) :=g_package||'get_bg_defaults';

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

402: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
403: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
405: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
406: ,p_location OUT NOCOPY hr_locations.location_code%type
407: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
408: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
409: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
410: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

Line 441: l_location hr_locations.location_code%type;

437: l_payroll_id per_all_assignments_f.payroll_id%type;
438: l_supervisor_id per_all_assignments_f.supervisor_id%type;
439: l_grade_id per_all_assignments_f.grade_id%type;
440: l_frequency_meaning hr_lookups.meaning%type;
441: l_location hr_locations.location_code%type;
442: l_probation_unit_meaning hr_lookups.meaning%type;
443: l_salary_basis per_pay_bases.name%type;
444: l_pay_basis per_pay_bases.pay_basis%type;
445: l_payroll pay_all_payrolls_f.payroll_name%type;

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

644: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
645: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
647: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
648: ,p_location OUT NOCOPY hr_locations.location_code%type
649: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
650: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
651: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
652: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

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

837: ,p_position OUT NOCOPY hr_all_positions_f.name%type
838: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
839: ,p_job OUT NOCOPY per_jobs.name%type
840: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
841: ,p_location OUT NOCOPY hr_locations.location_code%type
842: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
843: ,p_organization OUT NOCOPY hr_organization_units.name%type
844: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
845: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type