APPS.PAY_SE_FORA dependencies on PER_ALL_PEOPLE_F

Line 247: per_all_people_f WHERE

243: /*CURSOR csr_employee_details(csr_v_person_id number, csr_v_end_date date)
244: IS
245: SELECT national_identifier, last_name || ' ' || first_name name ,DATE_OF_BIRTH
246: FROM
247: per_all_people_f WHERE
248: BUSINESS_GROUP_ID=g_business_group_id
249: AND person_id=csr_v_person_id
250: AND csr_v_end_date
251: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

Line 258: per_all_people_f WHERE

254: /* CURSOR csr_employee_details(csr_v_person_id number, csr_v_start_date date date, csr_v_end_date date)
255: IS
256: SELECT national_identifier, last_name || ' ' || first_name name ,DATE_OF_BIRTH
257: FROM
258: per_all_people_f WHERE
259: BUSINESS_GROUP_ID=g_business_group_id
260: AND person_id=csr_v_person_id
261: /* AND csr_v_end_date
262: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE*/

Line 272: per_all_people_f WHERE

268: CURSOR csr_employee_details(csr_v_person_id number, csr_v_end_date date)
269: IS
270: SELECT national_identifier, last_name || ' ' || first_name name ,DATE_OF_BIRTH
271: FROM
272: per_all_people_f WHERE
273: BUSINESS_GROUP_ID=g_business_group_id
274: AND person_id=csr_v_person_id
275: AND csr_v_end_date
276: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

Line 292: SELECT MAX(effective_start_date) FROM per_all_people_f papf WHERE

288: AND employee_category='WC' ;
289:
290: CURSOR csr_termination(csr_v_person_id number, csr_v_start_date date, csr_v_end_date date)
291: IS
292: SELECT MAX(effective_start_date) FROM per_all_people_f papf WHERE
293: CURRENT_EMPLOYEE_FLAG IS NULL
294: AND person_id=csr_v_person_id--21257
295: AND EFFECTIVE_START_DATE --'31-dec-2000'
296: BETWEEN csr_v_start_date AND csr_v_end_date /*'01-jan-2000' AND csr_v_end_date '31-dec-2000'*/

Line 298: (SELECT 1 FROM per_all_people_f papf1 WHERE

294: AND person_id=csr_v_person_id--21257
295: AND EFFECTIVE_START_DATE --'31-dec-2000'
296: BETWEEN csr_v_start_date AND csr_v_end_date /*'01-jan-2000' AND csr_v_end_date '31-dec-2000'*/
297: AND NOT EXISTS
298: (SELECT 1 FROM per_all_people_f papf1 WHERE
299: CURRENT_EMPLOYEE_FLAG='Y'
300: AND person_id=papf.person_id --21257
301: AND papf1.effective_start_date >papf.effective_start_date
302: );

Line 307: per_all_people_f papf,

303: CURSOR csr_assignment_details(csr_v_local_unit_id number, csr_v_assignment_id NUMBER, csr_v_start_date date, csr_v_end_date date)
304: IS
305: /*SELECT effective_start_date,effective_end_date,pj.JOB_INFORMATION1,employee_category
306: FROM
307: per_all_people_f papf,
308: per_jobs pj
309: WHERE person_id=csr_v_person_id --21257 --21233
310: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
311: csr_v_end_date>=EFFECTIVE_START_DATE

Line 408: per_all_people_f papf,

404: csr_v_end_date date)
405: IS
406: SELECT DISTINCT papf.person_id ,paaf.assignment_id
407: FROM per_all_assignments_f paaf,
408: per_all_people_f papf,
409: hr_soft_coding_keyflex hsck
410: WHERE papf.business_group_id=csr_v_business_group_id -- 3133 --paaf.assignment_id = p_assignment_id
411: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
412: AND papf.person_id=paaf.person_id

Line 541: l_person_number per_all_people_f.national_identifier%TYPE;

537: l_assignment_end_date DATE;
538: l_absence_count NUMBER;
539: l_insurance_number varchar2(10);
540: l_employee_category per_all_assignments_f.employee_category%type;
541: l_person_number per_all_people_f.national_identifier%TYPE;
542: l_person_name VARCHAR2(350);
543: l_white_collar_from DATE;
544: l_terminated VARCHAR2(50);
545: l_painter VARCHAR2(50);

Line 557: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;

553: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
554: L_CFAR_NUMBER NUMBER;
555: l_legal_employer_id NUMBER;
556: l_virtual_date DATE;
557: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;
558: l_twenty_one_years DATE;
559: l_counter NUMBER :=0;
560: l_job_counter NUMBER :=0;
561: l_blue_max_date DATE;