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_ADDRESSES

Line 755: l_addr1 per_addresses.address_line1%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;
756: l_addr2 per_addresses.address_line2%TYPE;
757: l_addr3 per_addresses.address_line3%TYPE;
758: l_country per_addresses.country%TYPE;
759: l_city per_addresses.town_or_city%TYPE;

Line 756: l_addr2 per_addresses.address_line2%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;
756: l_addr2 per_addresses.address_line2%TYPE;
757: l_addr3 per_addresses.address_line3%TYPE;
758: l_country per_addresses.country%TYPE;
759: l_city per_addresses.town_or_city%TYPE;
760: l_state per_addresses.region_2%TYPE;

Line 757: l_addr3 per_addresses.address_line3%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;
756: l_addr2 per_addresses.address_line2%TYPE;
757: l_addr3 per_addresses.address_line3%TYPE;
758: l_country per_addresses.country%TYPE;
759: l_city per_addresses.town_or_city%TYPE;
760: l_state per_addresses.region_2%TYPE;
761: l_state1 per_addresses.region_2%TYPE;

Line 758: l_country per_addresses.country%TYPE;

754: l_loc_id per_all_assignments_f.location_id%TYPE;
755: l_addr1 per_addresses.address_line1%TYPE;
756: l_addr2 per_addresses.address_line2%TYPE;
757: l_addr3 per_addresses.address_line3%TYPE;
758: l_country per_addresses.country%TYPE;
759: l_city per_addresses.town_or_city%TYPE;
760: l_state per_addresses.region_2%TYPE;
761: l_state1 per_addresses.region_2%TYPE;
762: l_postal_code per_addresses.postal_code%TYPE;

Line 759: l_city per_addresses.town_or_city%TYPE;

755: l_addr1 per_addresses.address_line1%TYPE;
756: l_addr2 per_addresses.address_line2%TYPE;
757: l_addr3 per_addresses.address_line3%TYPE;
758: l_country per_addresses.country%TYPE;
759: l_city per_addresses.town_or_city%TYPE;
760: l_state per_addresses.region_2%TYPE;
761: l_state1 per_addresses.region_2%TYPE;
762: l_postal_code per_addresses.postal_code%TYPE;
763: l_postal_code1 per_addresses.postal_code%TYPE;

Line 760: l_state per_addresses.region_2%TYPE;

756: l_addr2 per_addresses.address_line2%TYPE;
757: l_addr3 per_addresses.address_line3%TYPE;
758: l_country per_addresses.country%TYPE;
759: l_city per_addresses.town_or_city%TYPE;
760: l_state per_addresses.region_2%TYPE;
761: l_state1 per_addresses.region_2%TYPE;
762: l_postal_code per_addresses.postal_code%TYPE;
763: l_postal_code1 per_addresses.postal_code%TYPE;
764: l_day_phone per_addresses.telephone_number_1%TYPE;

Line 761: l_state1 per_addresses.region_2%TYPE;

757: l_addr3 per_addresses.address_line3%TYPE;
758: l_country per_addresses.country%TYPE;
759: l_city per_addresses.town_or_city%TYPE;
760: l_state per_addresses.region_2%TYPE;
761: l_state1 per_addresses.region_2%TYPE;
762: l_postal_code per_addresses.postal_code%TYPE;
763: l_postal_code1 per_addresses.postal_code%TYPE;
764: l_day_phone per_addresses.telephone_number_1%TYPE;
765: l_evening_phone per_addresses.telephone_number_2%TYPE;

Line 762: l_postal_code per_addresses.postal_code%TYPE;

758: l_country per_addresses.country%TYPE;
759: l_city per_addresses.town_or_city%TYPE;
760: l_state per_addresses.region_2%TYPE;
761: l_state1 per_addresses.region_2%TYPE;
762: l_postal_code per_addresses.postal_code%TYPE;
763: l_postal_code1 per_addresses.postal_code%TYPE;
764: l_day_phone per_addresses.telephone_number_1%TYPE;
765: l_evening_phone per_addresses.telephone_number_2%TYPE;
766: l_hire_date per_periods_of_service.date_start%TYPE;

Line 763: l_postal_code1 per_addresses.postal_code%TYPE;

759: l_city per_addresses.town_or_city%TYPE;
760: l_state per_addresses.region_2%TYPE;
761: l_state1 per_addresses.region_2%TYPE;
762: l_postal_code per_addresses.postal_code%TYPE;
763: l_postal_code1 per_addresses.postal_code%TYPE;
764: l_day_phone per_addresses.telephone_number_1%TYPE;
765: l_evening_phone per_addresses.telephone_number_2%TYPE;
766: l_hire_date per_periods_of_service.date_start%TYPE;
767: l_term_date per_periods_of_service.actual_termination_date%TYPE;

Line 764: l_day_phone per_addresses.telephone_number_1%TYPE;

760: l_state per_addresses.region_2%TYPE;
761: l_state1 per_addresses.region_2%TYPE;
762: l_postal_code per_addresses.postal_code%TYPE;
763: l_postal_code1 per_addresses.postal_code%TYPE;
764: l_day_phone per_addresses.telephone_number_1%TYPE;
765: l_evening_phone per_addresses.telephone_number_2%TYPE;
766: l_hire_date per_periods_of_service.date_start%TYPE;
767: l_term_date per_periods_of_service.actual_termination_date%TYPE;
768: l_adj_date per_periods_of_service.adjusted_svc_date%TYPE;

Line 765: l_evening_phone per_addresses.telephone_number_2%TYPE;

761: l_state1 per_addresses.region_2%TYPE;
762: l_postal_code per_addresses.postal_code%TYPE;
763: l_postal_code1 per_addresses.postal_code%TYPE;
764: l_day_phone per_addresses.telephone_number_1%TYPE;
765: l_evening_phone per_addresses.telephone_number_2%TYPE;
766: l_hire_date per_periods_of_service.date_start%TYPE;
767: l_term_date per_periods_of_service.actual_termination_date%TYPE;
768: l_adj_date per_periods_of_service.adjusted_svc_date%TYPE;
769: l_plan_no varchar2(6);

Line 816: , per_addresses padd

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
820: and padd.person_id = papf.person_id