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_ALIEN_EXPAT_TAXATION_PKG dependencies on HR_LOCATIONS

Line 1408: from hr_locations hrlock,

1404: NVL(hrlock.telephone_number_1 , ' ' ) telephone_number_1,
1405: NVL(hrlock.telephone_number_2 , ' ' ) telephone_number_2,
1406: NVL(hrlock.telephone_number_3 , ' ' ) telephone_number_3,
1407: NVL(hrlock.postal_code , ' ' ) postal_code
1408: from hr_locations hrlock,
1409: hr_soft_coding_keyflex hrsckf,
1410: per_all_assignments_f assign
1411: where p_effective_date between assign.effective_start_date
1412: and assign.effective_end_date

Line 1510: l_value hr_locations.telephone_number_1%type;

1506: ( p_tele in varchar2 --
1507: ) return varchar2 -- Return Formated value
1508: is
1509:
1510: l_value hr_locations.telephone_number_1%type;
1511: l_len number := 0;
1512: l_sep_pos number := 0;
1513: l_pre hr_locations.telephone_number_1%type;
1514: l_char varchar2(1);

Line 1513: l_pre hr_locations.telephone_number_1%type;

1509:
1510: l_value hr_locations.telephone_number_1%type;
1511: l_len number := 0;
1512: l_sep_pos number := 0;
1513: l_pre hr_locations.telephone_number_1%type;
1514: l_char varchar2(1);
1515:
1516: begin
1517: -- Strip the blanks

Line 1930: l_county hr_locations.loc_information19%type ;

1926: l_suffix per_people_f.suffix%type ;
1927: l_person_id per_people_f.person_id%type ;
1928: l_marital_status per_people_f.marital_status%type ;
1929: l_assignment_id per_assignments_f.assignment_id%type ;
1930: l_county hr_locations.loc_information19%type ;
1931: l_state hr_locations.loc_information18%type ;
1932: l_city hr_locations.loc_information17%type ;
1933: l_address_line1 hr_locations.address_line_1%type ;
1934: l_address_line2 hr_locations.address_line_2%type ;

Line 1931: l_state hr_locations.loc_information18%type ;

1927: l_person_id per_people_f.person_id%type ;
1928: l_marital_status per_people_f.marital_status%type ;
1929: l_assignment_id per_assignments_f.assignment_id%type ;
1930: l_county hr_locations.loc_information19%type ;
1931: l_state hr_locations.loc_information18%type ;
1932: l_city hr_locations.loc_information17%type ;
1933: l_address_line1 hr_locations.address_line_1%type ;
1934: l_address_line2 hr_locations.address_line_2%type ;
1935: l_address_line3 hr_locations.address_line_3%type ;

Line 1932: l_city hr_locations.loc_information17%type ;

1928: l_marital_status per_people_f.marital_status%type ;
1929: l_assignment_id per_assignments_f.assignment_id%type ;
1930: l_county hr_locations.loc_information19%type ;
1931: l_state hr_locations.loc_information18%type ;
1932: l_city hr_locations.loc_information17%type ;
1933: l_address_line1 hr_locations.address_line_1%type ;
1934: l_address_line2 hr_locations.address_line_2%type ;
1935: l_address_line3 hr_locations.address_line_3%type ;
1936: l_telephone_number_1 hr_locations.telephone_number_1%type ;

Line 1933: l_address_line1 hr_locations.address_line_1%type ;

1929: l_assignment_id per_assignments_f.assignment_id%type ;
1930: l_county hr_locations.loc_information19%type ;
1931: l_state hr_locations.loc_information18%type ;
1932: l_city hr_locations.loc_information17%type ;
1933: l_address_line1 hr_locations.address_line_1%type ;
1934: l_address_line2 hr_locations.address_line_2%type ;
1935: l_address_line3 hr_locations.address_line_3%type ;
1936: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1937: l_telephone_number_2 hr_locations.telephone_number_2%type ;

Line 1934: l_address_line2 hr_locations.address_line_2%type ;

1930: l_county hr_locations.loc_information19%type ;
1931: l_state hr_locations.loc_information18%type ;
1932: l_city hr_locations.loc_information17%type ;
1933: l_address_line1 hr_locations.address_line_1%type ;
1934: l_address_line2 hr_locations.address_line_2%type ;
1935: l_address_line3 hr_locations.address_line_3%type ;
1936: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1937: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1938: l_telephone_number_3 hr_locations.telephone_number_3%type ;

Line 1935: l_address_line3 hr_locations.address_line_3%type ;

1931: l_state hr_locations.loc_information18%type ;
1932: l_city hr_locations.loc_information17%type ;
1933: l_address_line1 hr_locations.address_line_1%type ;
1934: l_address_line2 hr_locations.address_line_2%type ;
1935: l_address_line3 hr_locations.address_line_3%type ;
1936: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1937: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1938: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1939: l_postal_code hr_locations.postal_code%type ;

Line 1936: l_telephone_number_1 hr_locations.telephone_number_1%type ;

1932: l_city hr_locations.loc_information17%type ;
1933: l_address_line1 hr_locations.address_line_1%type ;
1934: l_address_line2 hr_locations.address_line_2%type ;
1935: l_address_line3 hr_locations.address_line_3%type ;
1936: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1937: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1938: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1939: l_postal_code hr_locations.postal_code%type ;
1940: l_process_event_id pay_process_events.process_event_id%type ;

Line 1937: l_telephone_number_2 hr_locations.telephone_number_2%type ;

1933: l_address_line1 hr_locations.address_line_1%type ;
1934: l_address_line2 hr_locations.address_line_2%type ;
1935: l_address_line3 hr_locations.address_line_3%type ;
1936: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1937: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1938: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1939: l_postal_code hr_locations.postal_code%type ;
1940: l_process_event_id pay_process_events.process_event_id%type ;
1941: l_object_version_number pay_process_events.object_version_number%type;

Line 1938: l_telephone_number_3 hr_locations.telephone_number_3%type ;

1934: l_address_line2 hr_locations.address_line_2%type ;
1935: l_address_line3 hr_locations.address_line_3%type ;
1936: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1937: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1938: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1939: l_postal_code hr_locations.postal_code%type ;
1940: l_process_event_id pay_process_events.process_event_id%type ;
1941: l_object_version_number pay_process_events.object_version_number%type;
1942: l_out_mesg out_mesg_type ;

Line 1939: l_postal_code hr_locations.postal_code%type ;

1935: l_address_line3 hr_locations.address_line_3%type ;
1936: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1937: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1938: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1939: l_postal_code hr_locations.postal_code%type ;
1940: l_process_event_id pay_process_events.process_event_id%type ;
1941: l_object_version_number pay_process_events.object_version_number%type;
1942: l_out_mesg out_mesg_type ;
1943:

Line 3321: from hr_locations hrlock

3317: cursor c_work_state_cur(p_assign_id in number) is
3318: select nvl(hrlock.loc_information17
3319: ,hrlock.region_2) state
3320:
3321: from hr_locations hrlock
3322: ,hr_soft_coding_keyflex hrsckf
3323: ,per_all_assignments_f paf
3324:
3325: where paf.effective_start_date <=