eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_USTIAA_PKG dependencies on PER_ALL_PEOPLE_F

Line 741: l_last_name per_all_people_f.last_name%TYPE;

737: -- |------------------------< generate_record >-------------------------|
738: -- ---------------------------------------------------------------------
739: PROCEDURE generate_record IS
740: l_proc_name VARCHAR2 (100) := 'pqp_ustiaa_pkg.generate_record';
741: l_last_name per_all_people_f.last_name%TYPE;
742: l_first_name per_all_people_f.first_name%TYPE;
743: l_middle_name per_all_people_f.middle_names%TYPE;
744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_mar_status per_all_people_f.marital_status%TYPE;

Line 742: l_first_name per_all_people_f.first_name%TYPE;

738: -- ---------------------------------------------------------------------
739: PROCEDURE generate_record IS
740: l_proc_name VARCHAR2 (100) := 'pqp_ustiaa_pkg.generate_record';
741: l_last_name per_all_people_f.last_name%TYPE;
742: l_first_name per_all_people_f.first_name%TYPE;
743: l_middle_name per_all_people_f.middle_names%TYPE;
744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_mar_status per_all_people_f.marital_status%TYPE;
746: l_gender per_all_people_f.sex%TYPE;

Line 743: l_middle_name per_all_people_f.middle_names%TYPE;

739: PROCEDURE generate_record IS
740: l_proc_name VARCHAR2 (100) := 'pqp_ustiaa_pkg.generate_record';
741: l_last_name per_all_people_f.last_name%TYPE;
742: l_first_name per_all_people_f.first_name%TYPE;
743: l_middle_name per_all_people_f.middle_names%TYPE;
744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_mar_status per_all_people_f.marital_status%TYPE;
746: l_gender per_all_people_f.sex%TYPE;
747: l_gender1 per_all_people_f.sex%TYPE;

Line 744: l_ssn per_all_people_f.national_identifier%TYPE;

740: l_proc_name VARCHAR2 (100) := 'pqp_ustiaa_pkg.generate_record';
741: l_last_name per_all_people_f.last_name%TYPE;
742: l_first_name per_all_people_f.first_name%TYPE;
743: l_middle_name per_all_people_f.middle_names%TYPE;
744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_mar_status per_all_people_f.marital_status%TYPE;
746: l_gender per_all_people_f.sex%TYPE;
747: l_gender1 per_all_people_f.sex%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;

Line 745: l_mar_status per_all_people_f.marital_status%TYPE;

741: l_last_name per_all_people_f.last_name%TYPE;
742: l_first_name per_all_people_f.first_name%TYPE;
743: l_middle_name per_all_people_f.middle_names%TYPE;
744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_mar_status per_all_people_f.marital_status%TYPE;
746: l_gender per_all_people_f.sex%TYPE;
747: l_gender1 per_all_people_f.sex%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_title per_all_people_f.title%TYPE;

Line 746: l_gender per_all_people_f.sex%TYPE;

742: l_first_name per_all_people_f.first_name%TYPE;
743: l_middle_name per_all_people_f.middle_names%TYPE;
744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_mar_status per_all_people_f.marital_status%TYPE;
746: l_gender per_all_people_f.sex%TYPE;
747: l_gender1 per_all_people_f.sex%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_title per_all_people_f.title%TYPE;
750: l_dob per_all_people_f.date_of_birth%TYPE;

Line 747: l_gender1 per_all_people_f.sex%TYPE;

743: l_middle_name per_all_people_f.middle_names%TYPE;
744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_mar_status per_all_people_f.marital_status%TYPE;
746: l_gender per_all_people_f.sex%TYPE;
747: l_gender1 per_all_people_f.sex%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_title per_all_people_f.title%TYPE;
750: l_dob per_all_people_f.date_of_birth%TYPE;
751: l_email per_all_people_f.email_address%TYPE;

Line 748: l_employee_number per_all_people_f.employee_number%TYPE;

744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_mar_status per_all_people_f.marital_status%TYPE;
746: l_gender per_all_people_f.sex%TYPE;
747: l_gender1 per_all_people_f.sex%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_title per_all_people_f.title%TYPE;
750: l_dob per_all_people_f.date_of_birth%TYPE;
751: l_email per_all_people_f.email_address%TYPE;
752: l_asg_id per_all_assignments_f.assignment_id%TYPE;

Line 749: l_title per_all_people_f.title%TYPE;

745: l_mar_status per_all_people_f.marital_status%TYPE;
746: l_gender per_all_people_f.sex%TYPE;
747: l_gender1 per_all_people_f.sex%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_title per_all_people_f.title%TYPE;
750: l_dob per_all_people_f.date_of_birth%TYPE;
751: l_email per_all_people_f.email_address%TYPE;
752: l_asg_id per_all_assignments_f.assignment_id%TYPE;
753: l_asg_no per_all_assignments_f.assignment_number%TYPE;

Line 750: l_dob per_all_people_f.date_of_birth%TYPE;

746: l_gender per_all_people_f.sex%TYPE;
747: l_gender1 per_all_people_f.sex%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_title per_all_people_f.title%TYPE;
750: l_dob per_all_people_f.date_of_birth%TYPE;
751: l_email per_all_people_f.email_address%TYPE;
752: l_asg_id per_all_assignments_f.assignment_id%TYPE;
753: l_asg_no per_all_assignments_f.assignment_number%TYPE;
754: l_loc_id per_all_assignments_f.location_id%TYPE;

Line 751: l_email per_all_people_f.email_address%TYPE;

747: l_gender1 per_all_people_f.sex%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_title per_all_people_f.title%TYPE;
750: l_dob per_all_people_f.date_of_birth%TYPE;
751: l_email per_all_people_f.email_address%TYPE;
752: l_asg_id per_all_assignments_f.assignment_id%TYPE;
753: l_asg_no per_all_assignments_f.assignment_number%TYPE;
754: l_loc_id per_all_assignments_f.location_id%TYPE;
755: l_addr1 per_addresses.address_line1%TYPE;

Line 815: , per_all_people_f papf

811: ppos.date_start,
812: ppos.actual_termination_date,
813: ppos.adjusted_svc_date
814: from per_all_assignments_f paf
815: , per_all_people_f papf
816: , per_addresses padd
817: , per_periods_of_service ppos
818: where paf.assignment_id = p_asg_id
819: and paf.person_id = papf.person_id