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_ASSIGNMENTS_F

Line 574: from per_all_assignments_f

570: l_effective_date Date;
571:
572: Cursor c_get_person_id is
573: Select person_id,payroll_id
574: from per_all_assignments_f
575: where assignment_id = p_asg_id
576: and trunc(p_effective_date) between effective_start_date and effective_end_date;
577:
578: Cursor c_get_prtt_enrt_rslt_id is

Line 678: from per_all_assignments_f

674: l_effective_date Date;
675:
676: Cursor c_get_person_id is
677: Select person_id
678: from per_all_assignments_f
679: where assignment_id = p_asg_id
680: and trunc(p_effective_date) between effective_start_date and effective_end_date;
681:
682: Cursor c_get_tsp_percentage is

Line 1127: l_payroll_id per_all_assignments_f.payroll_id%type;

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;
1131: l_tsp_pgm_id ben_pgm_f.pgm_id%type;

Line 1153: from per_all_assignments_f

1149:
1150: -- Get person id
1151: Cursor c_get_person_id is
1152: Select person_id,payroll_id
1153: from per_all_assignments_f
1154: where assignment_id = p_asg_id
1155: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1156:
1157: -- get end date and check date of last pay period of current year that has pay date in this year.

Line 1491: from per_all_assignments_f

1487: v_coe_date Date;
1488:
1489: Cursor c_get_person_id is
1490: Select person_id
1491: from per_all_assignments_f
1492: where assignment_id = p_asg_id
1493: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1494:
1495: Cursor c_get_ler_name is

Line 1617: from per_all_assignments_f

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
1618: where assignment_id = p_asg_id
1619: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1620:
1621: cursor c_get_agency_date is

Line 1655: from per_all_assignments_f

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
1656: where assignment_id = p_asg_id
1657: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1658:
1659: cursor c_get_emp_date is

Line 1694: from per_all_assignments_f

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
1695: where assignment_id = p_asg_id
1696: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1697:
1698: cursor c_get_coe_date is

Line 1732: v_payroll_id per_all_assignments_f.payroll_id%type;

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);
1736:

Line 1740: from per_all_assignments_f

1736:
1737: -- get person id
1738: Cursor c_get_person_id is
1739: Select person_id,payroll_id
1740: from per_all_assignments_f
1741: where assignment_id = p_asg_id
1742: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1743:
1744: -- get hire date

Line 1759: from per_all_assignments_f

1755:
1756: --check if this person exists in database
1757: Cursor c_chk_if_rehire is
1758: select 'Y'
1759: from per_all_assignments_f
1760: where person_id = v_person_id
1761: and (p_effective_date - 30) between effective_start_date and effective_end_date
1762: and assignment_type <> 'B';
1763: /*

Line 1875: from per_all_assignments_f

1871: l_end_date date;
1872:
1873: Cursor c_get_person_id is
1874: Select person_id,payroll_id
1875: from per_all_assignments_f
1876: where assignment_id = p_asg_id
1877: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1878:
1879: Cursor c_get_prtt_enrt_rslt_id is

Line 2149: from per_all_assignments_f

2145: ,p_option_id in Number) RETURN VARCHAR2 IS
2146:
2147: Cursor c_get_person_id is
2148: Select person_id,payroll_id
2149: from per_all_assignments_f
2150: where assignment_id = p_asg_id
2151: and trunc(p_effective_date) between effective_start_date and effective_end_date;
2152:
2153: Cursor c_get_enrt_cvg_info(p_person_id in number) is

Line 2176: l_person_id per_all_assignments_f.person_id%type;

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;
2180: l_ler_name ben_ler_f.name%type;

Line 2177: l_payroll_id per_all_assignments_f.payroll_id%type;

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;
2180: l_ler_name ben_ler_f.name%type;
2181: l_ler_id ben_ler_f.ler_id%type;

Line 2257: v_payroll_id per_all_assignments_f.payroll_id%type;

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:
2261:

Line 2266: from per_all_assignments_f

2262:
2263: -- get person id
2264: Cursor c_get_person_id is
2265: Select person_id,payroll_id
2266: from per_all_assignments_f
2267: where assignment_id = p_asg_id
2268: and trunc(p_effective_date) between effective_start_date and effective_end_date;
2269:
2270: