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 1123: l_payroll_id per_all_assignments_f.payroll_id%type;

1119: l_proc_name varchar2(100);
1120: l_eligible varchar2(1);
1121: l_ee_50 varchar2(1);
1122: l_person_id per_all_people_f.person_id%type;
1123: l_payroll_id per_all_assignments_f.payroll_id%type;
1124: l_pgm_year_end_dt Date;
1125: --l_date_of_birth Date;
1126: l_tspc_rate_start_dt Date;
1127: l_tsp_pgm_id ben_pgm_f.pgm_id%type;

Line 1149: from per_all_assignments_f

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

Line 1487: from per_all_assignments_f

1483: v_coe_date Date;
1484:
1485: Cursor c_get_person_id is
1486: Select person_id
1487: from per_all_assignments_f
1488: where assignment_id = p_asg_id
1489: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1490:
1491: Cursor c_get_ler_name is

Line 1613: from per_all_assignments_f

1609: v_person_id per_all_people_f.person_id%type;
1610:
1611: Cursor c_get_person_id is
1612: Select person_id
1613: from per_all_assignments_f
1614: where assignment_id = p_asg_id
1615: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1616:
1617: cursor c_get_agency_date is

Line 1651: from per_all_assignments_f

1647: v_person_id per_all_people_f.person_id%type;
1648:
1649: Cursor c_get_person_id is
1650: Select person_id
1651: from per_all_assignments_f
1652: where assignment_id = p_asg_id
1653: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1654:
1655: cursor c_get_emp_date is

Line 1690: from per_all_assignments_f

1686: v_person_id per_all_people_f.person_id%type;
1687:
1688: Cursor c_get_person_id is
1689: Select person_id
1690: from per_all_assignments_f
1691: where assignment_id = p_asg_id
1692: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1693:
1694: cursor c_get_coe_date is

Line 1728: v_payroll_id per_all_assignments_f.payroll_id%type;

1724: v_latest_hire_date Date;
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:

Line 1736: from per_all_assignments_f

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

Line 1755: from per_all_assignments_f

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

Line 1871: from per_all_assignments_f

1867: l_end_date date;
1868:
1869: Cursor c_get_person_id is
1870: Select person_id,payroll_id
1871: from per_all_assignments_f
1872: where assignment_id = p_asg_id
1873: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1874:
1875: Cursor c_get_prtt_enrt_rslt_id is