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 216: and nvl(effective_end_date, hr_general.end_of_time);

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

Line 450: and paf.effective_start_date <= hr_general.end_of_time)

446: per_all_assignments_f paf,
447: pay_payroll_actions ppa
448: where paf.assignment_id = p_assignment_id
449: and (paf.effective_end_date >= l_asg_start_date
450: and paf.effective_start_date <= hr_general.end_of_time)
451: and paa.assignment_id = paf.assignment_id
452: and ppa.payroll_action_id = paa.payroll_action_id
453: and ppa.effective_date +0 between
454: greatest(l_asg_start_date,paf.effective_start_date)

Line 455: and least(hr_general.end_of_time,paf.effective_end_date)

451: and paa.assignment_id = paf.assignment_id
452: and ppa.payroll_action_id = paa.payroll_action_id
453: and ppa.effective_date +0 between
454: greatest(l_asg_start_date,paf.effective_start_date)
455: and least(hr_general.end_of_time,paf.effective_end_date)
456: --start of code change for bug 14054849
457: /*and ((nvl(paa.run_type_id, ppa.run_type_id) is null and
458: paa.source_action_id is null)
459: or (nvl(paa.run_type_id, ppa.run_type_id) is not null and

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

516: cursor csr_sal is
517: select proposed_salary_n
518: from per_pay_proposals
519: where assignment_id = p_assignment_id
520: and p_effective_date between nvl(change_date,hr_general.start_of_time) and nvl(date_to,hr_general.end_of_time);
521: begin
522: open csr_sal;
523: fetch csr_sal into l_salary;
524: close csr_sal;

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

542: PAF.EFFECTIVE_START_DATE AND
543: PAF.EFFECTIVE_END_DATE;
544:
545: CURSOR Currency IS
546: SELECT HR_GENERAL.DECODE_LOOKUP('PAY_BASIS',PPB.PAY_BASIS)
547: ,PPB.PAY_ANNUALIZATION_FACTOR
548: FROM PAY_ELEMENT_TYPES_F PET
549: ,PAY_INPUT_VALUES_F PIV
550: ,PER_PAY_BASES PPB

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

602: is
603: l_grade per_grades_vl.name%type :=null ;
604:
605: cursor csr_grade is
606: select HR_GENERAL.DECODE_GRADE(paa.grade_id) as grade
607: from per_all_assignments_f paa
608: where paa.assignment_id = p_assignment_id
609: and p_effective_date between paa.effective_start_date and paa.effective_end_date;
610: begin

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

632: fetch csr_grade_currency into l_grade_currency;
633: close csr_grade_currency;
634:
635: if(l_grade_currency is null) then
636: l_grade_currency := hr_general.DEFAULT_CURRENCY_CODE(p_business_group_id);
637: end if;
638:
639: RETURN l_grade_currency;
640: END get_grade_currency;

Line 659: 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)

655: where paa.pay_basis_id = ppb.pay_basis_id
656: and ppb.input_value_id = piv.input_value_id
657: and piv.element_type_id = pet.element_type_id
658: and paa.assignment_id = p_assignment_id
659: 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)
660: 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)
661: 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);
662: begin
663: open csr_currency;

Line 660: 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)

656: and ppb.input_value_id = piv.input_value_id
657: and piv.element_type_id = pet.element_type_id
658: and paa.assignment_id = p_assignment_id
659: 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)
660: 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)
661: 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);
662: begin
663: open csr_currency;
664: fetch csr_currency into l_currency;

Line 661: 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);

657: and piv.element_type_id = pet.element_type_id
658: and paa.assignment_id = p_assignment_id
659: 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)
660: 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)
661: 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);
662: begin
663: open csr_currency;
664: fetch csr_currency into l_currency;
665: close csr_currency;