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_gender per_all_people_f.sex%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_gender per_all_people_f.sex%TYPE;
746: l_gender1 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_gender per_all_people_f.sex%TYPE;
746: l_gender1 per_all_people_f.sex%TYPE;
747: l_dob per_all_people_f.date_of_birth%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_gender per_all_people_f.sex%TYPE;
746: l_gender1 per_all_people_f.sex%TYPE;
747: l_dob per_all_people_f.date_of_birth%TYPE;
748: l_asg_id per_all_assignments_f.assignment_id%TYPE;

Line 745: l_gender per_all_people_f.sex%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_gender per_all_people_f.sex%TYPE;
746: l_gender1 per_all_people_f.sex%TYPE;
747: l_dob per_all_people_f.date_of_birth%TYPE;
748: l_asg_id per_all_assignments_f.assignment_id%TYPE;
749: l_asg_no per_all_assignments_f.assignment_number%TYPE;

Line 746: l_gender1 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_gender per_all_people_f.sex%TYPE;
746: l_gender1 per_all_people_f.sex%TYPE;
747: l_dob per_all_people_f.date_of_birth%TYPE;
748: l_asg_id per_all_assignments_f.assignment_id%TYPE;
749: l_asg_no per_all_assignments_f.assignment_number%TYPE;
750: l_addr1 per_addresses.address_line1%TYPE;

Line 747: l_dob per_all_people_f.date_of_birth%TYPE;

743: l_middle_name per_all_people_f.middle_names%TYPE;
744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_gender per_all_people_f.sex%TYPE;
746: l_gender1 per_all_people_f.sex%TYPE;
747: l_dob per_all_people_f.date_of_birth%TYPE;
748: l_asg_id per_all_assignments_f.assignment_id%TYPE;
749: l_asg_no per_all_assignments_f.assignment_number%TYPE;
750: l_addr1 per_addresses.address_line1%TYPE;
751: l_addr2 per_addresses.address_line2%TYPE;

Line 795: , per_all_people_f papf

791: padd.region_2 state,
792: padd.postal_code postal_code,
793: paf.assignment_number
794: from per_all_assignments_f paf
795: , per_all_people_f papf
796: , per_addresses padd
797: where paf.assignment_id = p_asg_id
798: and paf.person_id = papf.person_id
799: and padd.person_id = papf.person_id