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 PER_ALL_PEOPLE_F

Line 129: from per_all_people_f per,

125: select asg.person_id,
126: asg.location_id
127: into v_person_id,
128: v_location_id
129: from per_all_people_f per,
130: per_assignments_f asg
131: where asg.assignment_id = p_asg_id
132: and asg.business_group_id = p_business_group_id
133: and p_effective_date between asg.effective_start_date and asg.effective_end_date

Line 565: l_person_id per_all_people_f.person_id%type;

561:
562:
563: l_proc_name varchar2(100);
564: l_result Varchar2(1);
565: l_person_id per_all_people_f.person_id%type;
566: l_tsp_amount Number;
567: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;
568: l_payroll_id pay_payrolls_f.payroll_id%type;
569: l_enrt_cvg_strt_dt Date;

Line 669: l_person_id per_all_people_f.person_id%type;

665: Return Varchar2 is
666:
667: l_proc_name varchar2(100);
668: l_result Varchar2(1);
669: l_person_id per_all_people_f.person_id%type;
670: l_tsp_percentage Number;
671: l_enrt_cvg_strt_dt Date;
672: l_emp_csrs Varchar2(1);
673: Nothing_to_do Exception;

Line 1126: l_person_id per_all_people_f.person_id%type;

1122:
1123: l_proc_name varchar2(100);
1124: l_eligible varchar2(1);
1125: l_ee_50 varchar2(1);
1126: l_person_id per_all_people_f.person_id%type;
1127: l_payroll_id per_all_assignments_f.payroll_id%type;
1128: l_pgm_year_end_dt Date;
1129: --l_date_of_birth Date;
1130: l_tspc_rate_start_dt Date;

Line 1168: from per_all_people_f

1164: /*
1165: -- get date of birth of an employee
1166: Cursor c_get_dob is
1167: Select date_of_birth
1168: from per_all_people_f
1169: where person_id = l_person_id
1170: and trunc(l_current_check_date) between effective_start_date and effective_end_date;
1171:
1172: Cursor c_get_pgm_yr is

Line 1486: v_person_id per_all_people_f.person_id%type;

1482: v_eligible VARCHAR2(1);
1483: v_ler_name ben_ler_f.name%type;
1484: v_opt_name ben_opt_f.name%type;
1485: v_pl_name ben_pl_f.name%type;
1486: v_person_id per_all_people_f.person_id%type;
1487: v_coe_date Date;
1488:
1489: Cursor c_get_person_id is
1490: Select person_id

Line 1613: v_person_id per_all_people_f.person_id%type;

1609: Return Date is
1610:
1611: l_proc_name VARCHAR2(100);
1612: v_agency_date Date;
1613: v_person_id per_all_people_f.person_id%type;
1614:
1615: Cursor c_get_person_id is
1616: Select person_id
1617: from per_all_assignments_f

Line 1651: v_person_id per_all_people_f.person_id%type;

1647: Return Date is
1648:
1649: l_proc_name VARCHAR2(100);
1650: v_emp_date Date;
1651: v_person_id per_all_people_f.person_id%type;
1652:
1653: Cursor c_get_person_id is
1654: Select person_id
1655: from per_all_assignments_f

Line 1690: v_person_id per_all_people_f.person_id%type;

1686: Return Date is
1687:
1688: l_proc_name VARCHAR2(100);
1689: v_coe_date Date;
1690: v_person_id per_all_people_f.person_id%type;
1691:
1692: Cursor c_get_person_id is
1693: Select person_id
1694: from per_all_assignments_f

Line 1731: v_person_id per_all_people_f.person_id%type;

1727: l_proc_name varchar2(100);
1728: v_latest_hire_date Date;
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);

Line 1747: from per_all_people_f per, per_periods_of_service pps

1743:
1744: -- get hire date
1745: Cursor c_get_hire_date is
1746: select decode(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,null) hire_date
1747: from per_all_people_f per, per_periods_of_service pps
1748: where per.person_id = v_person_id
1749: and per.person_id = pps.person_id
1750: and PER.EMPLOYEE_NUMBER IS NOT NULL
1751: and PPS.DATE_START = (SELECT MAX(PPS1.DATE_START)

Line 1862: l_person_id per_all_people_f.person_id%type;

1858: RETURN varchar2 is
1859:
1860: l_proc_name varchar2(100);
1861: l_result Varchar2(1);
1862: l_person_id per_all_people_f.person_id%type;
1863: l_tsp_cu_amount Number;
1864: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;
1865: l_payroll_id pay_payrolls_f.payroll_id%type;
1866: l_rt_strt_dt Date;

Line 2011: from per_all_people_f

2007: order by start_date ;
2008:
2009: Cursor c_get_dob is
2010: Select date_of_birth
2011: from per_all_people_f
2012: where person_id = p_person_id
2013: and trunc(l_current_check_date) between effective_start_date and effective_end_date;
2014:
2015: Begin

Line 2256: v_person_id per_all_people_f.person_id%type;

2252: l_proc_name varchar2(100);
2253: v_cvg_rate_st_date Date;
2254: v_hire_date Date;
2255: v_period_st_date Date;
2256: v_person_id per_all_people_f.person_id%type;
2257: v_payroll_id per_all_assignments_f.payroll_id%type;
2258: v_ler_name ben_ler_f.name%type;
2259: v_effective_st_dt Date;
2260:

Line 2288: from per_all_people_f per, per_periods_of_service pps

2284:
2285: -- get hire date
2286: Cursor c_get_hire_date is
2287: select decode(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,null) hire_date
2288: from per_all_people_f per, per_periods_of_service pps
2289: where per.person_id = v_person_id
2290: and per.person_id = pps.person_id
2291: and PER.EMPLOYEE_NUMBER IS NOT NULL
2292: and PPS.DATE_START = (SELECT MAX(PPS1.DATE_START)