APPS.GHR_FORMULA_FUNCTIONS dependencies on GHR_PA_REQUESTS

Line 1733: v_noa_family_code ghr_pa_requests.noa_family_code%type;

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

Line 1734: v_first_noa_code ghr_pa_requests.first_noa_code%type;

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

Line 1777: from ghr_pa_requests

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

Line 2175: l_fegli_code ghr_pa_requests.fegli%type;

2171: from ben_ler_f
2172: where ler_id = p_ler_id
2173: and trunc(p_effective_date) between effective_start_date and effective_end_date;
2174:
2175: l_fegli_code ghr_pa_requests.fegli%type;
2176: l_person_id per_all_assignments_f.person_id%type;
2177: l_payroll_id per_all_assignments_f.payroll_id%type;
2178: l_enrt_cvg_st_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type;
2179: l_option_id ben_opt_f.opt_id%type;