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.GHR_FORMULA_FUNCTIONS dependencies on GHR_PA_REQUESTS

Line 1729: v_noa_family_code ghr_pa_requests.noa_family_code%type;

1725: v_cvg_rate_date Date;
1726: v_hire_date Date;
1727: v_person_id per_all_people_f.person_id%type;
1728: v_payroll_id per_all_assignments_f.payroll_id%type;
1729: v_noa_family_code ghr_pa_requests.noa_family_code%type;
1730: v_first_noa_code ghr_pa_requests.first_noa_code%type;
1731: v_rehire Varchar2(1);
1732:
1733: -- get person id

Line 1730: v_first_noa_code ghr_pa_requests.first_noa_code%type;

1726: v_hire_date Date;
1727: v_person_id per_all_people_f.person_id%type;
1728: v_payroll_id per_all_assignments_f.payroll_id%type;
1729: v_noa_family_code ghr_pa_requests.noa_family_code%type;
1730: v_first_noa_code ghr_pa_requests.first_noa_code%type;
1731: v_rehire Varchar2(1);
1732:
1733: -- get person id
1734: Cursor c_get_person_id is

Line 1773: from ghr_pa_requests

1769: */
1770: -- get latest rehire or transfer date
1771: Cursor c_get_latest_hire_noac is
1772: select noa_family_code,first_noa_code
1773: from ghr_pa_requests
1774: where person_id = v_person_id
1775: and noa_family_code in ('APP','CONV_APP')
1776: and nvl(effective_date,hr_api.g_date) = trunc(p_effective_date);
1777: