APPS.GHR_CPDF_DYNRPT dependencies on PER_ALL_PEOPLE_F

Line 172: FROM per_all_people_f per

168: ,p_effective_date IN DATE
169: ,p_sex OUT NOCOPY VARCHAR2) IS
170: CURSOR cur_per_sex IS
171: SELECT per.sex
172: FROM per_all_people_f per
173: WHERE per.person_id = p_person_id
174: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date;
175: BEGIN
176: FOR cur_per_sex_rec IN cur_per_sex LOOP

Line 1200: CURSOR cur_per_details(p_person_id per_all_people_f.person_id%type)

1196: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
1197: -- End Bug 4542476
1198:
1199:
1200: CURSOR cur_per_details(p_person_id per_all_people_f.person_id%type)
1201: IS
1202: SELECT title,last_name
1203: FROM per_all_people_f
1204: WHERE person_id = p_person_id;

Line 1203: FROM per_all_people_f

1199:
1200: CURSOR cur_per_details(p_person_id per_all_people_f.person_id%type)
1201: IS
1202: SELECT title,last_name
1203: FROM per_all_people_f
1204: WHERE person_id = p_person_id;
1205:
1206: CURSOR cur_scd_dates(p_pa_request_id ghr_pa_requests.pa_request_id%type)
1207: IS

Line 1218: l_last_name per_all_people_f.last_name%type;

1214: l_mesgbuff1 VARCHAR2(4000);
1215: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
1216: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;
1217: ll_per_ei_data per_people_extra_info%rowtype;
1218: l_last_name per_all_people_f.last_name%type;
1219: l_suffix per_all_people_f.title%type;
1220:
1221: -- For Dual Actions PRD is becoming null so preserving it using a local variable.
1222: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;

Line 1219: l_suffix per_all_people_f.title%type;

1215: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
1216: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;
1217: ll_per_ei_data per_people_extra_info%rowtype;
1218: l_last_name per_all_people_f.last_name%type;
1219: l_suffix per_all_people_f.title%type;
1220:
1221: -- For Dual Actions PRD is becoming null so preserving it using a local variable.
1222: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1223: