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_SALADMIN_UTILITY dependencies on HR_GENERAL

Line 212: and nvl(effective_end_date, hr_general.end_of_time);

208: from per_all_assignments_f
209: where assignment_id = p_assignment_id
210: and business_group_id + 0 = p_business_group_id
211: and p_change_date between effective_start_date
212: and nvl(effective_end_date, hr_general.end_of_time);
213: --
214: BEGIN
215: OPEN csr_sal_review_details;
216: FETCH csr_sal_review_details into l_sal_review_period,l_sal_review_period_frequency;

Line 444: hr_general.end_of_time );

440: --
441: l_last_payroll_dt := pqh_bdgt_actual_cmmtmnt_pkg.get_last_payroll_dt (
442: p_assignment_id,
443: l_asg_start_date,
444: hr_general.end_of_time );
445:
446: if l_last_payroll_dt is not null
447: then
448: return l_last_payroll_dt;

Line 489: and p_effective_date between nvl(change_date,hr_general.start_of_time) and nvl(date_to,hr_general.end_of_time);

485: cursor csr_sal is
486: select proposed_salary_n
487: from per_pay_proposals
488: where assignment_id = p_assignment_id
489: and p_effective_date between nvl(change_date,hr_general.start_of_time) and nvl(date_to,hr_general.end_of_time);
490: begin
491: open csr_sal;
492: fetch csr_sal into l_salary;
493: close csr_sal;

Line 515: SELECT HR_GENERAL.DECODE_LOOKUP('PAY_BASIS',PPB.PAY_BASIS)

511: PAF.EFFECTIVE_START_DATE AND
512: PAF.EFFECTIVE_END_DATE;
513:
514: CURSOR Currency IS
515: SELECT HR_GENERAL.DECODE_LOOKUP('PAY_BASIS',PPB.PAY_BASIS)
516: ,PPB.PAY_ANNUALIZATION_FACTOR
517: FROM PAY_ELEMENT_TYPES_F PET
518: ,PAY_INPUT_VALUES_F PIV
519: ,PER_PAY_BASES PPB

Line 575: select HR_GENERAL.DECODE_GRADE(paa.grade_id) as grade

571: is
572: l_grade per_grades_vl.name%type :=null ;
573:
574: cursor csr_grade is
575: select HR_GENERAL.DECODE_GRADE(paa.grade_id) as grade
576: from per_all_assignments_f paa
577: where paa.assignment_id = p_assignment_id
578: and p_effective_date between paa.effective_start_date and paa.effective_end_date;
579: begin

Line 605: l_grade_currency := hr_general.DEFAULT_CURRENCY_CODE(p_business_group_id);

601: fetch csr_grade_currency into l_grade_currency;
602: close csr_grade_currency;
603:
604: if(l_grade_currency is null) then
605: l_grade_currency := hr_general.DEFAULT_CURRENCY_CODE(p_business_group_id);
606: end if;
607:
608: RETURN l_grade_currency;
609: END get_grade_currency;

Line 628: and p_effective_date between nvl(paa.effective_start_date,hr_general.start_of_time) and nvl(paa.effective_end_date,hr_general.end_of_time)

624: where paa.pay_basis_id = ppb.pay_basis_id
625: and ppb.input_value_id = piv.input_value_id
626: and piv.element_type_id = pet.element_type_id
627: and paa.assignment_id = p_assignment_id
628: and p_effective_date between nvl(paa.effective_start_date,hr_general.start_of_time) and nvl(paa.effective_end_date,hr_general.end_of_time)
629: and p_effective_date between nvl(pet.effective_start_date,hr_general.start_of_time) and nvl(pet.effective_end_date,hr_general.end_of_time)
630: and p_effective_date between nvl(piv.effective_start_date,hr_general.start_of_time) and nvl(piv.effective_end_date,hr_general.end_of_time);
631: begin
632: open csr_currency;

Line 629: and p_effective_date between nvl(pet.effective_start_date,hr_general.start_of_time) and nvl(pet.effective_end_date,hr_general.end_of_time)

625: and ppb.input_value_id = piv.input_value_id
626: and piv.element_type_id = pet.element_type_id
627: and paa.assignment_id = p_assignment_id
628: and p_effective_date between nvl(paa.effective_start_date,hr_general.start_of_time) and nvl(paa.effective_end_date,hr_general.end_of_time)
629: and p_effective_date between nvl(pet.effective_start_date,hr_general.start_of_time) and nvl(pet.effective_end_date,hr_general.end_of_time)
630: and p_effective_date between nvl(piv.effective_start_date,hr_general.start_of_time) and nvl(piv.effective_end_date,hr_general.end_of_time);
631: begin
632: open csr_currency;
633: fetch csr_currency into l_currency;

Line 630: and p_effective_date between nvl(piv.effective_start_date,hr_general.start_of_time) and nvl(piv.effective_end_date,hr_general.end_of_time);

626: and piv.element_type_id = pet.element_type_id
627: and paa.assignment_id = p_assignment_id
628: and p_effective_date between nvl(paa.effective_start_date,hr_general.start_of_time) and nvl(paa.effective_end_date,hr_general.end_of_time)
629: and p_effective_date between nvl(pet.effective_start_date,hr_general.start_of_time) and nvl(pet.effective_end_date,hr_general.end_of_time)
630: and p_effective_date between nvl(piv.effective_start_date,hr_general.start_of_time) and nvl(piv.effective_end_date,hr_general.end_of_time);
631: begin
632: open csr_currency;
633: fetch csr_currency into l_currency;
634: close csr_currency;