APPS.BEN_EXT_EVALUATE_INCLUSION dependencies on HR_SOFT_CODING_KEYFLEX

Line 1950: p_gre in hr_soft_coding_keyflex.segment1%type,

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

Line 1957: FROM per_all_assignments_f asn, hr_soft_coding_keyflex flex

1953: is
1954: --
1955: cursor get_gre is
1956: SELECT flex.segment1
1957: FROM per_all_assignments_f asn, hr_soft_coding_keyflex flex
1958: WHERE asn.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1959: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
1960: AND asn.person_id = p_person_id
1961: AND asn.primary_flag = 'Y'

Line 1967: l_gre hr_soft_coding_keyflex.segment1%type;

1963: and asn.effective_end_date
1964: AND p_effective_date between nvl(flex.start_date_active, p_effective_date)
1965: and nvl(flex.end_date_active, p_effective_date);
1966: --
1967: l_gre hr_soft_coding_keyflex.segment1%type;
1968: --
1969: l_proc varchar2(72);
1970: --
1971: Begin

Line 6160: p_gre in hr_soft_coding_keyflex.segment1%type default null,

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