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_ASSIGNMENTS_F

Line 1811: p_org_id in per_all_assignments_f.organization_id%type,

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

Line 1818: FROM per_all_assignments_f asn

1814: is
1815: --
1816: cursor get_org_id is
1817: SELECT organization_id
1818: FROM per_all_assignments_f asn
1819: WHERE asn.person_id = p_person_id
1820: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
1821: AND asn.primary_flag = 'Y'
1822: AND p_effective_date between effective_start_date

Line 1825: l_org_id per_all_assignments_f.organization_id%type;

1821: AND asn.primary_flag = 'Y'
1822: AND p_effective_date between effective_start_date
1823: and effective_end_date;
1824: --
1825: l_org_id per_all_assignments_f.organization_id%type;
1826: --
1827: l_proc varchar2(72);
1828: --
1829: Begin

Line 1881: p_loc_id in per_all_assignments_f.location_id%type,

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

Line 1888: FROM per_all_assignments_f asn

1884: is
1885: --
1886: cursor get_loc_id is
1887: SELECT location_id
1888: FROM per_all_assignments_f asn
1889: WHERE asn.person_id = p_person_id
1890: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
1891: AND asn.primary_flag = 'Y'
1892: AND p_effective_date between effective_start_date

Line 1895: l_loc_id per_all_assignments_f.location_id%type;

1891: AND asn.primary_flag = 'Y'
1892: AND p_effective_date between effective_start_date
1893: and effective_end_date;
1894: --
1895: l_loc_id per_all_assignments_f.location_id%type;
1896: --
1897: l_proc varchar2(72);
1898: --
1899: Begin

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 2160: p_ee_status in per_all_assignments_f.assignment_status_type_id%type,

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

Line 2167: FROM per_all_assignments_f asn

2163: is
2164: --
2165: cursor get_ee_status is
2166: SELECT assignment_status_type_id
2167: FROM per_all_assignments_f asn
2168: WHERE asn.person_id = p_person_id
2169: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
2170: AND asn.primary_flag = 'Y'
2171: AND p_effective_date between effective_start_date and effective_end_date;

Line 2173: l_ee_status per_all_assignments_f.assignment_status_type_id%type;

2169: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
2170: AND asn.primary_flag = 'Y'
2171: AND p_effective_date between effective_start_date and effective_end_date;
2172: --
2173: l_ee_status per_all_assignments_f.assignment_status_type_id%type;
2174: --
2175: l_proc varchar2(72);
2176: --
2177: Begin

Line 2228: p_payroll_id in per_all_assignments_f.payroll_id%type,

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

Line 2235: FROM per_all_assignments_f asn

2231: is
2232: --
2233: cursor c_pay is
2234: SELECT payroll_id
2235: FROM per_all_assignments_f asn
2236: WHERE asn.person_id = p_person_id
2237: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
2238: AND asn.primary_flag = 'Y'
2239: AND p_effective_date between effective_start_date and effective_end_date;

Line 2241: l_payroll_id per_all_assignments_f.payroll_id%type;

2237: and asn.assignment_id = ben_ext_person.g_assignment_id --1969853
2238: AND asn.primary_flag = 'Y'
2239: AND p_effective_date between effective_start_date and effective_end_date;
2240: --
2241: l_payroll_id per_all_assignments_f.payroll_id%type;
2242: --
2243: l_proc varchar2(72);
2244: --
2245: Begin

Line 2302: FROM per_all_assignments_f asg

2298: is
2299: --
2300: cursor c_asg is
2301: SELECT asg.assignment_id, asg.business_group_id
2302: FROM per_all_assignments_f asg
2303: WHERE asg.person_id = p_person_id
2304: and asg.assignment_id = ben_ext_person.g_assignment_id --1969853
2305: AND (asg.primary_flag = 'Y' or asg.assignment_type = 'A' ) -- if the asg type is A dont validate the primary flag
2306: AND p_effective_date between asg.effective_start_date

Line 6056: FROM per_all_assignments_f asg

6052: is
6053: --
6054: cursor c_asg is
6055: SELECT asg.assignment_id, asg.business_group_id
6056: FROM per_all_assignments_f asg
6057: WHERE asg.person_id = p_person_id
6058: and asg.assignment_id = ben_ext_person.g_assignment_id --1969853
6059: AND asg.primary_flag = 'Y'
6060: AND p_effective_date between asg.effective_start_date

Line 6158: p_org_id in per_all_assignments_f.organization_id%type default null,

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,
6162: p_bnft_grp in per_all_people_f.benefit_group_id%type default null,

Line 6159: p_loc_id in per_all_assignments_f.location_id%type default null,

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

Line 6163: p_ee_status in per_all_assignments_f.assignment_status_type_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,
6167: p_effective_date in date,

Line 6164: p_payroll_id in per_all_assignments_f.payroll_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,
6167: p_effective_date in date,
6168: --RCHASE