APPS.PAY_US_MARK_W2C_PAPER dependencies on PER_ALL_PEOPLE_F

Line 422: from per_all_people_f ppf,

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

Line 448: lv_full_name per_all_people_f.full_name%type;

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

Line 449: lv_national_identifier per_all_people_f.national_identifier%type;

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

Line 450: lv_employee_number per_all_people_f.employee_number%type;

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