APPS.GHR_ELT_TO_BEN_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 265: (table_name = 'PER_PEOPLE_EXTRA_INFO' and information5 = 'GHR_US_PER_GROUP1') OR

261: SELECT *
262: FROM ghr_pa_history
263: WHERE person_id = p_person_id
264: AND (
265: (table_name = 'PER_PEOPLE_EXTRA_INFO' and information5 = 'GHR_US_PER_GROUP1') OR
266: (table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
267: AND information4 IN (SELECT b.input_value_id
268: FROM pay_element_types_f a,pay_input_values_f b
269: WHERE a.element_type_id = b.element_type_id

Line 349: IF p_pa_history_rec.table_name = 'PER_PEOPLE_EXTRA_INFO' AND p_pa_history_rec.information5 = 'GHR_US_PER_GROUP1' THEN

345:
346: BEGIN
347: hr_utility.set_location('Entering build_benefits_rec',0);
348: l_benefits_eit_rec := p_benefits_eit_rec;
349: IF p_pa_history_rec.table_name = 'PER_PEOPLE_EXTRA_INFO' AND p_pa_history_rec.information5 = 'GHR_US_PER_GROUP1' THEN
350: hr_utility.set_location('Assigning values for FEHB Person EIT',5);
351: p_benefits_eit_rec.FEHB_Date_Eligibility_expires := p_pa_history_rec.information19;
352: p_benefits_eit_rec.FEHB_Date_temp_eligibility := p_pa_history_rec.information20;
353: p_benefits_eit_rec.FEHB_Date_dependent_cert_expir := p_pa_history_rec.information21;

Line 400: l_information_type per_people_extra_info.information_type%type;

396: PROCEDURE insert_benefits_eit_rec(p_person_id IN NUMBER,
397: p_benefits_eit_rec IN ghr_api.per_benefit_info_type,
398: p_effective_date IN DATE) IS
399:
400: l_information_type per_people_extra_info.information_type%type;
401: l_person_extra_info_id NUMBER;
402: l_object_version_number NUMBER;
403:
404: CURSOR c_person_extra_info(p_person_id NUMBER) IS

Line 407: FROM per_people_extra_info

403:
404: CURSOR c_person_extra_info(p_person_id NUMBER) IS
405: SELECT person_extra_info_id,
406: object_version_number
407: FROM per_people_extra_info
408: WHERE person_id = p_person_id
409: AND information_type = 'GHR_US_PER_BENEFIT_INFO';
410:
411:

Line 2068: l_agncy_contrib_elig_date per_people_extra_info.pei_information14%type;

2064:
2065: l_assignment_id pay_element_entries_f.assignment_id%type;
2066: l_position_id per_all_assignments_f.position_id%type;
2067: l_person_id per_all_assignments_f.person_id%type;
2068: l_agncy_contrib_elig_date per_people_extra_info.pei_information14%type;
2069: l_effective_start_date per_all_people_f.effective_start_date%type;
2070: l_effective_end_date per_all_people_f.effective_end_date%type;
2071: l_retirement_plan pay_element_entry_values_f.screen_entry_value%type;
2072: l_agency_effective_date date;

Line 2112: from per_all_people_f ppf, per_all_assignments_f paf, per_people_extra_info ppei

2108: CURSOR c_tsp_agncy_date IS
2109: select paf.position_id,ppf.person_id,paf.assignment_id,
2110: ppei.pei_information14 ,ppf.effective_start_date, ppf.effective_end_date,ppf.national_identifier,
2111: ppf.full_name,ppf.employee_number
2112: from per_all_people_f ppf, per_all_assignments_f paf, per_people_extra_info ppei
2113: where ppf.person_id=paf.person_id
2114: and ppf.person_id=ppei.person_id
2115: and ppei.information_type='GHR_US_PER_BENEFIT_INFO'
2116: and paf.primary_flag='Y'

Line 2233: l_peopleei_data per_people_extra_info%rowtype;

2229:
2230: l_session_var ghr_history_api.g_session_var_type;
2231: l_sess_date DATE;
2232: l_session_id number;
2233: l_peopleei_data per_people_extra_info%rowtype;
2234:
2235: cursor get_sess_date is
2236: select trunc(effective_date)
2237: from fnd_sessions

Line 2242: from per_people_extra_info

2238: where session_id = l_session_id;
2239:
2240: cursor c_peopleei_getovn(cp_people_ei_id number) is
2241: select object_version_number
2242: from per_people_extra_info
2243: where person_extra_info_id = cp_people_ei_id;
2244:
2245: BEGIN
2246: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');