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 798: , per_addresses addr

794: addr.region_1 ,
795: addr.region_2 ,
796: 'Y' valid_address
797: from per_all_assignments_f assign
798: , per_addresses addr
799: , per_all_people_f ppf
800: , fnd_territories_tl fttl
801: , fnd_territories ftt
802: , hr_lookups hrt

Line 843: , per_addresses ADDR

839: addr.region_1 ,
840: addr.region_2 ,
841: 'Y' valid_address
842: FROM per_all_assignments_f ASSIGN
843: , per_addresses ADDR
844: , per_all_people_f PPF
845: , fnd_territories_tl fttl
846: , fnd_territories ftt
847: , hr_lookups hrt

Line 884: FROM per_addresses ADDR

880: fttl.territory_short_name,
881: addr.region_1 ,
882: addr.region_2 ,
883: 'Y' valid_address
884: FROM per_addresses ADDR
885: , per_all_people_f PPF
886: , fnd_territories_tl fttl
887: , fnd_territories ftt
888: , hr_lookups hrt

Line 925: FROM per_addresses addr

921: fttl.territory_short_name,
922: addr.region_1 ,
923: addr.region_2 ,
924: 'Y' valid_address
925: FROM per_addresses addr
926: , per_all_people_f ppf
927: , fnd_territories_tl fttl
928: , fnd_territories ftt
929: , hr_lookups hrt

Line 960: l_address_line_1 per_addresses.address_line1%type;

956: l_valid_address varchar2(3) := 'N';
957: l_emp_number per_all_people_f.employee_number%type;
958: l_full_name per_all_people_f.full_name%TYPE;
959: /*
960: l_address_line_1 per_addresses.address_line1%type;
961: l_address_line_2 per_addresses.address_line2%type;
962: l_address_line_3 per_addresses.address_line3%type;
963: l_city per_addresses.town_or_city%type;
964: l_region_1 per_addresses.region_1%TYPE;

Line 961: l_address_line_2 per_addresses.address_line2%type;

957: l_emp_number per_all_people_f.employee_number%type;
958: l_full_name per_all_people_f.full_name%TYPE;
959: /*
960: l_address_line_1 per_addresses.address_line1%type;
961: l_address_line_2 per_addresses.address_line2%type;
962: l_address_line_3 per_addresses.address_line3%type;
963: l_city per_addresses.town_or_city%type;
964: l_region_1 per_addresses.region_1%TYPE;
965: l_region_2 per_addresses.region_2%TYPE;

Line 962: l_address_line_3 per_addresses.address_line3%type;

958: l_full_name per_all_people_f.full_name%TYPE;
959: /*
960: l_address_line_1 per_addresses.address_line1%type;
961: l_address_line_2 per_addresses.address_line2%type;
962: l_address_line_3 per_addresses.address_line3%type;
963: l_city per_addresses.town_or_city%type;
964: l_region_1 per_addresses.region_1%TYPE;
965: l_region_2 per_addresses.region_2%TYPE;
966: l_postal_code per_addresses.postal_code%TYPE;

Line 963: l_city per_addresses.town_or_city%type;

959: /*
960: l_address_line_1 per_addresses.address_line1%type;
961: l_address_line_2 per_addresses.address_line2%type;
962: l_address_line_3 per_addresses.address_line3%type;
963: l_city per_addresses.town_or_city%type;
964: l_region_1 per_addresses.region_1%TYPE;
965: l_region_2 per_addresses.region_2%TYPE;
966: l_postal_code per_addresses.postal_code%TYPE;
967: l_country per_addresses.country%type;

Line 964: l_region_1 per_addresses.region_1%TYPE;

960: l_address_line_1 per_addresses.address_line1%type;
961: l_address_line_2 per_addresses.address_line2%type;
962: l_address_line_3 per_addresses.address_line3%type;
963: l_city per_addresses.town_or_city%type;
964: l_region_1 per_addresses.region_1%TYPE;
965: l_region_2 per_addresses.region_2%TYPE;
966: l_postal_code per_addresses.postal_code%TYPE;
967: l_country per_addresses.country%type;
968: */

Line 965: l_region_2 per_addresses.region_2%TYPE;

961: l_address_line_2 per_addresses.address_line2%type;
962: l_address_line_3 per_addresses.address_line3%type;
963: l_city per_addresses.town_or_city%type;
964: l_region_1 per_addresses.region_1%TYPE;
965: l_region_2 per_addresses.region_2%TYPE;
966: l_postal_code per_addresses.postal_code%TYPE;
967: l_country per_addresses.country%type;
968: */
969: l_too_many_adr_token3 varchar2(50):='More than one address found';

Line 966: l_postal_code per_addresses.postal_code%TYPE;

962: l_address_line_3 per_addresses.address_line3%type;
963: l_city per_addresses.town_or_city%type;
964: l_region_1 per_addresses.region_1%TYPE;
965: l_region_2 per_addresses.region_2%TYPE;
966: l_postal_code per_addresses.postal_code%TYPE;
967: l_country per_addresses.country%type;
968: */
969: l_too_many_adr_token3 varchar2(50):='More than one address found';
970: l_token2 varchar2(50);

Line 967: l_country per_addresses.country%type;

963: l_city per_addresses.town_or_city%type;
964: l_region_1 per_addresses.region_1%TYPE;
965: l_region_2 per_addresses.region_2%TYPE;
966: l_postal_code per_addresses.postal_code%TYPE;
967: l_country per_addresses.country%type;
968: */
969: l_too_many_adr_token3 varchar2(50):='More than one address found';
970: l_token2 varchar2(50);
971: l_effective_date date;