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_VGR_BUS dependencies on HR_POSITIONS_F

Line 107: -- hr_positions_f for the position_id if it is not null.

103: -- Validates that date from must be within the range specified by date_from
104: -- and date_to on per_grades for the grade_id.
105: --
106: -- Validates that date from is equal to or later than the effective_date of
107: -- hr_positions_f for the position_id if it is not null.
108: --
109: -- Validates that date from is equal to or later than the date_from of
110: -- per_jobs_v for the job_id if it is not null.
111: --

Line 165: -- Changes 22-APR-02. replaced hr_positions with hr_positions_f and added effective_date

161: where job.job_id = p_job_id
162: and p_date_from >= job.date_from;
163: --
164: -- Changes 12-Oct-99 SCNair (per_positions to hr_positions) Date tracked position req.
165: -- Changes 22-APR-02. replaced hr_positions with hr_positions_f and added effective_date
166: -- condition
167: cursor csr_chk_pos_dates is
168: select null
169: from hr_positions_f pos

Line 169: from hr_positions_f pos

165: -- Changes 22-APR-02. replaced hr_positions with hr_positions_f and added effective_date
166: -- condition
167: cursor csr_chk_pos_dates is
168: select null
169: from hr_positions_f pos
170: where pos.position_id = p_position_id
171: and p_date_from >= pos.date_effective
172: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
173: --

Line 241: -- hr_positions_f p_position_id

237: end if;
238: hr_utility.set_location(l_proc, 5);
239: --
240: -- Check that date_from is on or later than the effective_date on
241: -- hr_positions_f p_position_id
242: --
243: if p_position_id is not null then
244: open csr_chk_pos_dates;
245: fetch csr_chk_pos_dates into l_exists;

Line 431: -- Validates that a position id exists in the table hr_positions_f

427: -- |---------------------------< chk_position_id >----------------------------|
428: -- ----------------------------------------------------------------------------
429: --
430: -- Description :
431: -- Validates that a position id exists in the table hr_positions_f
432: --
433: -- Validates that the business group id for the position is the same as
434: -- that for the valid grade.
435: --

Line 443: -- If a row does exist in hr_positions_f for the given position id then

439: -- In Arguments :
440: -- p_position_id
441: --
442: -- Post Success :
443: -- If a row does exist in hr_positions_f for the given position id then
444: -- processing continues
445: --
446: -- Post Failure :
447: -- If a row does not exist in hr_positions_f for the given position id then

Line 447: -- If a row does not exist in hr_positions_f for the given position id then

443: -- If a row does exist in hr_positions_f for the given position id then
444: -- processing continues
445: --
446: -- Post Failure :
447: -- If a row does not exist in hr_positions_f for the given position id then
448: -- 0an application error will be raised and processing is terminatet
449: --
450: -- Access Status :
451: -- Internal Table Handler Use only.

Line 467: -- Changed 22-APR-02.hr_positions is replaced with hr_positions_f and added the

463: l_business_group_id number(15);
464: --
465: --
466: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions) Date tracked position req
467: -- Changed 22-APR-02.hr_positions is replaced with hr_positions_f and added the
468: -- effective_date condition. Bug 1760707
469: cursor csr_valid_pos is
470: select pos.business_group_id
471: from hr_positions_f pos

Line 471: from hr_positions_f pos

467: -- Changed 22-APR-02.hr_positions is replaced with hr_positions_f and added the
468: -- effective_date condition. Bug 1760707
469: cursor csr_valid_pos is
470: select pos.business_group_id
471: from hr_positions_f pos
472: where pos.position_id = p_position_id
473: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
474: --
475: cursor csr_chk_pos_grd_comb is

Line 498: -- position on hr_positions_f

494: p_argument_value => p_business_group_iD
495: );
496: --
497: -- Check that the position ID , if it is not null, is linked to a valid
498: -- position on hr_positions_f
499: --
500: if p_position_id is not null then
501: open csr_valid_pos;
502: fetch csr_valid_pos into l_business_group_id;

Line 543: -- hr_positions_f for the position_id if it is not null.

539: -- Validates that date to must be within the range specified by date_from
540: -- and date_to on per_grades for the grade_id.
541: --
542: -- Validates that date to is equal to or earlier than the effective_date of
543: -- hr_positions_f for the position_id if it is not null.
544: --
545: -- Validates that date to is equal to or earlier than the date_to of
546: -- per_jobs_v for the job_id if it is not null.
547: --

Line 604: from hr_positions_f pos

600: -- replaced hr_positions with hr_position_f.Added effective_date condition. Bug 1760707
601: --
602: cursor csr_chk_pos_dates is
603: select null
604: from hr_positions_f pos
605: where pos.position_id = p_position_id
606: and nvl(p_date_to, hr_api.g_eot) <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)
607: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
608: --

Line 678: -- hr_positions_f p_position_id

674: end if;
675: hr_utility.set_location(l_proc, 5);
676: --
677: -- Check that date_to is on or later than the end_date on
678: -- hr_positions_f p_position_id
679: --
680: if p_position_id is not null then
681: open csr_chk_pos_dates;
682: fetch csr_chk_pos_dates into l_exists;