[Home] [Help]
123: -- Cursor to select the person's sex which is required for CPDF Edits
124:
125: cursor c_person_sex is
126: select per.sex
127: from per_all_people_f per
128: where per.person_id = P_pa_request_rec.person_id
129: and g_effective_date
130: between per.effective_start_date
131: and per.effective_end_date;
168:
169: cursor c_person_type is
170: select ppt.system_person_type
171: from per_person_types ppt,
172: per_all_people_f ppf
173: where ppf.person_id = p_pa_request_rec.person_id
174: and ppt.person_type_id = ppf.person_type_id
175: and p_pa_request_rec.effective_date
176: between ppf.effective_start_date
821:
822: cursor c_person_type is
823: select ppt.system_person_type
824: from per_person_types ppt,
825: per_all_people_f ppf
826: where ppf.person_id = p_pa_request_rec.person_id
827: and ppt.person_type_id = ppf.person_type_id
828: and g_effective_date
829: between ppf.effective_start_date
1756:
1757: cursor c_person_type is
1758: select ppt.system_person_type
1759: from per_person_types ppt,
1760: per_all_people_f ppf
1761: where ppf.person_id = p_pa_request_rec.person_id
1762: and ppt.person_type_id = ppf.person_type_id
1763: and g_effective_date
1764: between ppf.effective_start_date
2681: --Bug # 12562230
2682: cursor get_business_group
2683: is
2684: SELECT per.business_group_id
2685: FROM per_all_people_f per
2686: WHERE per.person_id = p_pa_request_rec.person_id
2687: and p_pa_request_rec.effective_date between per.effective_start_date and per.effective_end_date;
2688:
2689: cursor get_enrollment_option (p_business_group_id in NUMBER)
2701:
2702:
2703:
2704: shadow_ei_rec ghr_pa_request_ei_shadow%rowtype;
2705: l_curr_bg per_all_people_f.business_group_id%type;
2706: l_prev_enrollment pay_element_entry_values_f.screen_entry_value%type;
2707:
2708: BEGIN
2709: -- bug# 9680314