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_ADDRESSES

Line 1739: p_postal_code in per_addresses.postal_code%type,

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

Line 1746: FROM per_addresses addr

1742: is
1743: --
1744: cursor get_postal_code is
1745: SELECT postal_code
1746: FROM per_addresses addr
1747: WHERE addr.person_id = p_person_id
1748: AND primary_flag = 'Y'
1749: AND p_effective_date between date_from
1750: and nvl(date_to, p_effective_date);

Line 1752: l_postal_code per_addresses.postal_code%type;

1748: AND primary_flag = 'Y'
1749: AND p_effective_date between date_from
1750: and nvl(date_to, p_effective_date);
1751: --
1752: l_postal_code per_addresses.postal_code%type;
1753: --
1754: l_proc varchar2(72);
1755: --
1756: Begin

Line 2022: p_state in per_addresses.region_2%type,

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

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 2038: l_state per_addresses.region_2%type;

2034: and per.effective_end_date
2035: AND p_effective_date between addr.date_from
2036: and nvl(addr.date_to, p_effective_date);
2037: --
2038: l_state per_addresses.region_2%type;
2039: --
2040: l_proc varchar2(72);
2041: --
2042: Begin

Line 6157: p_postal_code in per_addresses.postal_code%type default null,

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,
6161: p_state in per_addresses.region_2%type default null,

Line 6161: p_state in per_addresses.region_2%type default null,

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,
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,