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.PAY_US_GET_ITEM_DATA_PKG dependencies on PER_ADDRESSES

Line 51: address to set the per_addresses.region_2 as the state for

47: missing fnd_territories in sql and joining
48: directly to fnd_territories_tl. added where condition
49: for checking user language.
50: 05-JAN-04 ppanda 115.10 3141296 When Country code is not for the address code assumes its a US
51: address to set the per_addresses.region_2 as the state for
52: the employee address
53:
54: 03-NOV-04 asasthan 115.11 2694998 Formatting of contact name.
55: 03-NOV-04 asasthan 115.13 2694998 Removed more characters

Line 681: , per_addresses addr

677: addr.region_1 ,
678: addr.region_2 ,
679: 'Y' valid_address
680: from per_all_assignments_f assign
681: , per_addresses addr
682: , per_all_people_f ppf
683: , fnd_territories_tl fttl
684: , fnd_territories ftt
685: , hr_lookups hrt

Line 726: , per_addresses ADDR

722: addr.region_1 ,
723: addr.region_2 ,
724: 'Y' valid_address
725: FROM per_all_assignments_f ASSIGN
726: , per_addresses ADDR
727: , per_all_people_f PPF
728: , fnd_territories_tl fttl
729: , fnd_territories ftt
730: , hr_lookups hrt

Line 767: FROM per_addresses ADDR

763: fttl.territory_short_name,
764: addr.region_1 ,
765: addr.region_2 ,
766: 'Y' valid_address
767: FROM per_addresses ADDR
768: , per_all_people_f PPF
769: , fnd_territories_tl fttl
770: , fnd_territories ftt
771: , hr_lookups hrt

Line 808: FROM per_addresses addr

804: fttl.territory_short_name,
805: addr.region_1 ,
806: addr.region_2 ,
807: 'Y' valid_address
808: FROM per_addresses addr
809: , per_all_people_f ppf
810: , fnd_territories_tl fttl
811: , fnd_territories ftt
812: , hr_lookups hrt

Line 843: l_address_line_1 per_addresses.address_line1%type;

839: l_valid_address varchar2(3) := 'N';
840: l_emp_number per_all_people_f.employee_number%type;
841: l_full_name per_all_people_f.full_name%TYPE;
842: /*
843: l_address_line_1 per_addresses.address_line1%type;
844: l_address_line_2 per_addresses.address_line2%type;
845: l_address_line_3 per_addresses.address_line3%type;
846: l_city per_addresses.town_or_city%type;
847: l_region_1 per_addresses.region_1%TYPE;

Line 844: l_address_line_2 per_addresses.address_line2%type;

840: l_emp_number per_all_people_f.employee_number%type;
841: l_full_name per_all_people_f.full_name%TYPE;
842: /*
843: l_address_line_1 per_addresses.address_line1%type;
844: l_address_line_2 per_addresses.address_line2%type;
845: l_address_line_3 per_addresses.address_line3%type;
846: l_city per_addresses.town_or_city%type;
847: l_region_1 per_addresses.region_1%TYPE;
848: l_region_2 per_addresses.region_2%TYPE;

Line 845: l_address_line_3 per_addresses.address_line3%type;

841: l_full_name per_all_people_f.full_name%TYPE;
842: /*
843: l_address_line_1 per_addresses.address_line1%type;
844: l_address_line_2 per_addresses.address_line2%type;
845: l_address_line_3 per_addresses.address_line3%type;
846: l_city per_addresses.town_or_city%type;
847: l_region_1 per_addresses.region_1%TYPE;
848: l_region_2 per_addresses.region_2%TYPE;
849: l_postal_code per_addresses.postal_code%TYPE;

Line 846: l_city per_addresses.town_or_city%type;

842: /*
843: l_address_line_1 per_addresses.address_line1%type;
844: l_address_line_2 per_addresses.address_line2%type;
845: l_address_line_3 per_addresses.address_line3%type;
846: l_city per_addresses.town_or_city%type;
847: l_region_1 per_addresses.region_1%TYPE;
848: l_region_2 per_addresses.region_2%TYPE;
849: l_postal_code per_addresses.postal_code%TYPE;
850: l_country per_addresses.country%type;

Line 847: l_region_1 per_addresses.region_1%TYPE;

843: l_address_line_1 per_addresses.address_line1%type;
844: l_address_line_2 per_addresses.address_line2%type;
845: l_address_line_3 per_addresses.address_line3%type;
846: l_city per_addresses.town_or_city%type;
847: l_region_1 per_addresses.region_1%TYPE;
848: l_region_2 per_addresses.region_2%TYPE;
849: l_postal_code per_addresses.postal_code%TYPE;
850: l_country per_addresses.country%type;
851: */

Line 848: l_region_2 per_addresses.region_2%TYPE;

844: l_address_line_2 per_addresses.address_line2%type;
845: l_address_line_3 per_addresses.address_line3%type;
846: l_city per_addresses.town_or_city%type;
847: l_region_1 per_addresses.region_1%TYPE;
848: l_region_2 per_addresses.region_2%TYPE;
849: l_postal_code per_addresses.postal_code%TYPE;
850: l_country per_addresses.country%type;
851: */
852: l_too_many_adr_token3 varchar2(50):='More than one address found';

Line 849: l_postal_code per_addresses.postal_code%TYPE;

845: l_address_line_3 per_addresses.address_line3%type;
846: l_city per_addresses.town_or_city%type;
847: l_region_1 per_addresses.region_1%TYPE;
848: l_region_2 per_addresses.region_2%TYPE;
849: l_postal_code per_addresses.postal_code%TYPE;
850: l_country per_addresses.country%type;
851: */
852: l_too_many_adr_token3 varchar2(50):='More than one address found';
853: l_token2 varchar2(50);

Line 850: l_country per_addresses.country%type;

846: l_city per_addresses.town_or_city%type;
847: l_region_1 per_addresses.region_1%TYPE;
848: l_region_2 per_addresses.region_2%TYPE;
849: l_postal_code per_addresses.postal_code%TYPE;
850: l_country per_addresses.country%type;
851: */
852: l_too_many_adr_token3 varchar2(50):='More than one address found';
853: l_token2 varchar2(50);
854: l_effective_date date;