APPS.PAY_US_MARK_W2C_PAPER dependencies on PER_ALL_PEOPLE_F

Line 424: from per_all_people_f ppf,

420: cursor ee_details (cp_person_id in number,
421: cp_end_date in date) is
422: select ppf.full_name, ppf.national_identifier, ppf.employee_number,
423: paf.assignment_number
424: from per_all_people_f ppf,
425: per_all_assignments_f paf
426: where ppf.person_id = cp_person_id
427: and paf.person_id = ppf.person_id
428: and cp_end_date between ppf.effective_start_date

Line 450: lv_full_name per_all_people_f.full_name%type;

446:
447:
448:
449: ln_w2c_asg_action NUMBER := 0;
450: lv_full_name per_all_people_f.full_name%type;
451: lv_national_identifier per_all_people_f.national_identifier%type;
452: lv_employee_number per_all_people_f.employee_number%type;
453: lv_assignment_number per_all_assignments_f.assignment_number%type;
454: lv_gre_name hr_organization_units.name%type;

Line 451: lv_national_identifier per_all_people_f.national_identifier%type;

447:
448:
449: ln_w2c_asg_action NUMBER := 0;
450: lv_full_name per_all_people_f.full_name%type;
451: lv_national_identifier per_all_people_f.national_identifier%type;
452: lv_employee_number per_all_people_f.employee_number%type;
453: lv_assignment_number per_all_assignments_f.assignment_number%type;
454: lv_gre_name hr_organization_units.name%type;
455: lv_year varchar2(4) ;

Line 452: lv_employee_number per_all_people_f.employee_number%type;

448:
449: ln_w2c_asg_action NUMBER := 0;
450: lv_full_name per_all_people_f.full_name%type;
451: lv_national_identifier per_all_people_f.national_identifier%type;
452: lv_employee_number per_all_people_f.employee_number%type;
453: lv_assignment_number per_all_assignments_f.assignment_number%type;
454: lv_gre_name hr_organization_units.name%type;
455: lv_year varchar2(4) ;
456: lv_creation_date varchar2(20) ;