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.BEN_EXT_EVALUATE_INCLUSION dependencies on PER_ALL_PEOPLE_F

Line 1688: (p_person_id in per_all_people_f.person_id%type,

1684: ------------------------< chk_person_id_incl >-------------------------------
1685: -----------------------------------------------------------------------------
1686: --
1687: Procedure chk_person_id_incl
1688: (p_person_id in per_all_people_f.person_id%type,
1689: p_excld_flag in varchar2)
1690: is
1691: --
1692: --

Line 1738: (p_person_id in per_all_people_f.person_id%type,

1734: ------------------------< chk_postal_code_incl >-----------------------------
1735: -----------------------------------------------------------------------------
1736: --
1737: Procedure chk_postal_code_incl
1738: (p_person_id in per_all_people_f.person_id%type,
1739: p_postal_code in per_addresses.postal_code%type,
1740: p_effective_date in date,
1741: p_excld_flag in varchar2)
1742: is

Line 1810: (p_person_id in per_all_people_f.person_id%type,

1806: -----------------------------< chk_org_id_incl >-----------------------------
1807: -----------------------------------------------------------------------------
1808: --
1809: Procedure chk_org_id_incl
1810: (p_person_id in per_all_people_f.person_id%type,
1811: p_org_id in per_all_assignments_f.organization_id%type,
1812: p_effective_date in date,
1813: p_excld_flag in varchar2)
1814: is

Line 1880: (p_person_id in per_all_people_f.person_id%type,

1876: -----------------------------< chk_loc_id_incl >-----------------------------
1877: -----------------------------------------------------------------------------
1878: --
1879: Procedure chk_loc_id_incl
1880: (p_person_id in per_all_people_f.person_id%type,
1881: p_loc_id in per_all_assignments_f.location_id%type,
1882: p_effective_date in date,
1883: p_excld_flag in varchar2)
1884: is

Line 1949: (p_person_id in per_all_people_f.person_id%type,

1945: --------------------------------< chk_gre_incl >-----------------------------
1946: -----------------------------------------------------------------------------
1947: --
1948: Procedure chk_gre_incl
1949: (p_person_id in per_all_people_f.person_id%type,
1950: p_gre in hr_soft_coding_keyflex.segment1%type,
1951: p_effective_date in date,
1952: p_excld_flag in varchar2)
1953: is

Line 2021: (p_person_id in per_all_people_f.person_id%type,

2017: ------------------------------< chk_state_incl >-----------------------------
2018: -----------------------------------------------------------------------------
2019: --
2020: Procedure chk_state_incl
2021: (p_person_id in per_all_people_f.person_id%type,
2022: p_state in per_addresses.region_2%type,
2023: p_effective_date in date,
2024: p_excld_flag in varchar2)
2025: is

Line 2029: FROM per_all_people_f per, per_addresses addr

2025: is
2026: --
2027: cursor get_state is
2028: SELECT addr.region_2
2029: FROM per_all_people_f per, per_addresses addr
2030: WHERE per.person_id = addr.person_id
2031: AND per.person_id = p_person_id
2032: AND addr.primary_flag = 'Y'
2033: AND p_effective_date between per.effective_start_date

Line 2092: (p_person_id in per_all_people_f.person_id%type,

2088: ------------------------------< chk_bnft_grp_incl >--------------------------
2089: -----------------------------------------------------------------------------
2090: --
2091: Procedure chk_bnft_grp_incl
2092: (p_person_id in per_all_people_f.person_id%type,
2093: p_bnft_grp in per_all_people_f.benefit_group_id%type,
2094: p_effective_date in date,
2095: p_excld_flag in varchar2)
2096: is

Line 2093: p_bnft_grp in per_all_people_f.benefit_group_id%type,

2089: -----------------------------------------------------------------------------
2090: --
2091: Procedure chk_bnft_grp_incl
2092: (p_person_id in per_all_people_f.person_id%type,
2093: p_bnft_grp in per_all_people_f.benefit_group_id%type,
2094: p_effective_date in date,
2095: p_excld_flag in varchar2)
2096: is
2097: --

Line 2100: FROM per_all_people_f per

2096: is
2097: --
2098: cursor get_bnft_grp is
2099: SELECT benefit_group_id
2100: FROM per_all_people_f per
2101: WHERE per.person_id = p_person_id
2102: AND p_effective_date between per.effective_start_date
2103: and per.effective_end_date;
2104: --

Line 2105: l_bnft_grp per_all_people_f.benefit_group_id%type;

2101: WHERE per.person_id = p_person_id
2102: AND p_effective_date between per.effective_start_date
2103: and per.effective_end_date;
2104: --
2105: l_bnft_grp per_all_people_f.benefit_group_id%type;
2106: --
2107: l_proc varchar2(72);
2108: --
2109: Begin

Line 2159: (p_person_id in per_all_people_f.person_id%type,

2155: ------------------------------< chk_ee_status_incl >-------------------------
2156: -----------------------------------------------------------------------------
2157: --
2158: Procedure chk_ee_status_incl
2159: (p_person_id in per_all_people_f.person_id%type,
2160: p_ee_status in per_all_assignments_f.assignment_status_type_id%type,
2161: p_effective_date in date,
2162: p_excld_flag in varchar2)
2163: is

Line 2227: (p_person_id in per_all_people_f.person_id%type,

2223: ------------------------------< chk_payroll_id_incl >-------------------------
2224: -----------------------------------------------------------------------------
2225: --
2226: Procedure chk_payroll_id_incl
2227: (p_person_id in per_all_people_f.person_id%type,
2228: p_payroll_id in per_all_assignments_f.payroll_id%type,
2229: p_effective_date in date,
2230: p_excld_flag in varchar2)
2231: is

Line 2295: (p_person_id in per_all_people_f.person_id%type,

2291: ------------------------------< chk_person_rule_incl >-----------------------
2292: -----------------------------------------------------------------------------
2293: --
2294: Procedure chk_person_rule_incl
2295: (p_person_id in per_all_people_f.person_id%type,
2296: p_effective_date in date,
2297: p_excld_flag in varchar2)
2298: is
2299: --

Line 2377: (p_person_id in per_all_people_f.person_id%type,

2373: ------------------------------< chk_per_ler_incl >---------------------------
2374: -----------------------------------------------------------------------------
2375: --
2376: Procedure chk_per_ler_incl
2377: (p_person_id in per_all_people_f.person_id%type,
2378: p_effective_date in date,
2379: p_excld_flag in varchar2)
2380: is
2381: --

Line 2441: (p_person_id in per_all_people_f.person_id%type,

2437: -------------------------< chk_person_type_incl >-----------------------
2438: -----------------------------------------------------------------------------
2439: --
2440: Procedure chk_person_type_incl
2441: (p_person_id in per_all_people_f.person_id%type,
2442: p_effective_date in date,
2443: p_excld_flag in varchar2)
2444: is
2445: --

Line 2508: (p_person_id per_all_people_f.person_id%type,

2504: --
2505: --The following procedure checks combination criteria inclusion
2506: --
2507: Procedure chk_cmbn_incl
2508: (p_person_id per_all_people_f.person_id%type,
2509: p_chg_evt_cd varchar2,
2510: p_chg_evt_source varchar2,
2511: p_effective_date date,
2512: p_actl_date date)

Line 6156: (p_person_id in per_all_people_f.person_id%type,

6152: --
6153: -- The following procedure evaluates person inclusion criteria
6154: --
6155: Procedure evaluate_person_incl
6156: (p_person_id in per_all_people_f.person_id%type,
6157: p_postal_code in per_addresses.postal_code%type default null,
6158: p_org_id in per_all_assignments_f.organization_id%type default null,
6159: p_loc_id in per_all_assignments_f.location_id%type default null,
6160: p_gre in hr_soft_coding_keyflex.segment1%type default null,

Line 6162: p_bnft_grp in per_all_people_f.benefit_group_id%type default null,

6158: p_org_id in per_all_assignments_f.organization_id%type default null,
6159: p_loc_id in per_all_assignments_f.location_id%type default null,
6160: p_gre in hr_soft_coding_keyflex.segment1%type default null,
6161: p_state in per_addresses.region_2%type default null,
6162: p_bnft_grp in per_all_people_f.benefit_group_id%type default null,
6163: p_ee_status in per_all_assignments_f.assignment_status_type_id%type default null,
6164: p_payroll_id in per_all_assignments_f.payroll_id%type default null,
6165: p_chg_evt_cd in varchar2 default null,
6166: p_chg_evt_source in varchar2 default null,