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 750: l_addr1 per_addresses.address_line1%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;
752: l_addr3 per_addresses.address_line3%TYPE;
753: l_country per_addresses.country%TYPE;
754: l_city per_addresses.town_or_city%TYPE;

Line 751: l_addr2 per_addresses.address_line2%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;
752: l_addr3 per_addresses.address_line3%TYPE;
753: l_country per_addresses.country%TYPE;
754: l_city per_addresses.town_or_city%TYPE;
755: l_state per_addresses.region_2%TYPE;

Line 752: l_addr3 per_addresses.address_line3%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;
752: l_addr3 per_addresses.address_line3%TYPE;
753: l_country per_addresses.country%TYPE;
754: l_city per_addresses.town_or_city%TYPE;
755: l_state per_addresses.region_2%TYPE;
756: l_state1 per_addresses.region_2%TYPE;

Line 753: l_country per_addresses.country%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;
752: l_addr3 per_addresses.address_line3%TYPE;
753: l_country per_addresses.country%TYPE;
754: l_city per_addresses.town_or_city%TYPE;
755: l_state per_addresses.region_2%TYPE;
756: l_state1 per_addresses.region_2%TYPE;
757: l_postal_code per_addresses.postal_code%TYPE;

Line 754: l_city per_addresses.town_or_city%TYPE;

750: l_addr1 per_addresses.address_line1%TYPE;
751: l_addr2 per_addresses.address_line2%TYPE;
752: l_addr3 per_addresses.address_line3%TYPE;
753: l_country per_addresses.country%TYPE;
754: l_city per_addresses.town_or_city%TYPE;
755: l_state per_addresses.region_2%TYPE;
756: l_state1 per_addresses.region_2%TYPE;
757: l_postal_code per_addresses.postal_code%TYPE;
758: l_postal_code1 per_addresses.postal_code%TYPE;

Line 755: l_state per_addresses.region_2%TYPE;

751: l_addr2 per_addresses.address_line2%TYPE;
752: l_addr3 per_addresses.address_line3%TYPE;
753: l_country per_addresses.country%TYPE;
754: l_city per_addresses.town_or_city%TYPE;
755: l_state per_addresses.region_2%TYPE;
756: l_state1 per_addresses.region_2%TYPE;
757: l_postal_code per_addresses.postal_code%TYPE;
758: l_postal_code1 per_addresses.postal_code%TYPE;
759: l_plan_no varchar2(6);

Line 756: l_state1 per_addresses.region_2%TYPE;

752: l_addr3 per_addresses.address_line3%TYPE;
753: l_country per_addresses.country%TYPE;
754: l_city per_addresses.town_or_city%TYPE;
755: l_state per_addresses.region_2%TYPE;
756: l_state1 per_addresses.region_2%TYPE;
757: l_postal_code per_addresses.postal_code%TYPE;
758: l_postal_code1 per_addresses.postal_code%TYPE;
759: l_plan_no varchar2(6);
760: l_plan_no1 varchar2(6);

Line 757: l_postal_code per_addresses.postal_code%TYPE;

753: l_country per_addresses.country%TYPE;
754: l_city per_addresses.town_or_city%TYPE;
755: l_state per_addresses.region_2%TYPE;
756: l_state1 per_addresses.region_2%TYPE;
757: l_postal_code per_addresses.postal_code%TYPE;
758: l_postal_code1 per_addresses.postal_code%TYPE;
759: l_plan_no varchar2(6);
760: l_plan_no1 varchar2(6);
761: l_pay_date date;

Line 758: l_postal_code1 per_addresses.postal_code%TYPE;

754: l_city per_addresses.town_or_city%TYPE;
755: l_state per_addresses.region_2%TYPE;
756: l_state1 per_addresses.region_2%TYPE;
757: l_postal_code per_addresses.postal_code%TYPE;
758: l_postal_code1 per_addresses.postal_code%TYPE;
759: l_plan_no varchar2(6);
760: l_plan_no1 varchar2(6);
761: l_pay_date date;
762: l_tax_unit_id number;

Line 796: , per_addresses padd

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
800: and padd.primary_flag = 'Y'