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 1404: from hr_locations hrlock,

1400: NVL(hrlock.telephone_number_1 , ' ' ) telephone_number_1,
1401: NVL(hrlock.telephone_number_2 , ' ' ) telephone_number_2,
1402: NVL(hrlock.telephone_number_3 , ' ' ) telephone_number_3,
1403: NVL(hrlock.postal_code , ' ' ) postal_code
1404: from hr_locations hrlock,
1405: hr_soft_coding_keyflex hrsckf,
1406: per_all_assignments_f assign
1407: where p_effective_date between assign.effective_start_date
1408: and assign.effective_end_date

Line 1506: l_value hr_locations.telephone_number_1%type;

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

Line 1509: l_pre hr_locations.telephone_number_1%type;

1505:
1506: l_value hr_locations.telephone_number_1%type;
1507: l_len number := 0;
1508: l_sep_pos number := 0;
1509: l_pre hr_locations.telephone_number_1%type;
1510: l_char varchar2(1);
1511:
1512: begin
1513: -- Strip the blanks

Line 1926: l_county hr_locations.loc_information19%type ;

1922: l_suffix per_people_f.suffix%type ;
1923: l_person_id per_people_f.person_id%type ;
1924: l_marital_status per_people_f.marital_status%type ;
1925: l_assignment_id per_assignments_f.assignment_id%type ;
1926: l_county hr_locations.loc_information19%type ;
1927: l_state hr_locations.loc_information18%type ;
1928: l_city hr_locations.loc_information17%type ;
1929: l_address_line1 hr_locations.address_line_1%type ;
1930: l_address_line2 hr_locations.address_line_2%type ;

Line 1927: l_state hr_locations.loc_information18%type ;

1923: l_person_id per_people_f.person_id%type ;
1924: l_marital_status per_people_f.marital_status%type ;
1925: l_assignment_id per_assignments_f.assignment_id%type ;
1926: l_county hr_locations.loc_information19%type ;
1927: l_state hr_locations.loc_information18%type ;
1928: l_city hr_locations.loc_information17%type ;
1929: l_address_line1 hr_locations.address_line_1%type ;
1930: l_address_line2 hr_locations.address_line_2%type ;
1931: l_address_line3 hr_locations.address_line_3%type ;

Line 1928: l_city hr_locations.loc_information17%type ;

1924: l_marital_status per_people_f.marital_status%type ;
1925: l_assignment_id per_assignments_f.assignment_id%type ;
1926: l_county hr_locations.loc_information19%type ;
1927: l_state hr_locations.loc_information18%type ;
1928: l_city hr_locations.loc_information17%type ;
1929: l_address_line1 hr_locations.address_line_1%type ;
1930: l_address_line2 hr_locations.address_line_2%type ;
1931: l_address_line3 hr_locations.address_line_3%type ;
1932: l_telephone_number_1 hr_locations.telephone_number_1%type ;

Line 1929: l_address_line1 hr_locations.address_line_1%type ;

1925: l_assignment_id per_assignments_f.assignment_id%type ;
1926: l_county hr_locations.loc_information19%type ;
1927: l_state hr_locations.loc_information18%type ;
1928: l_city hr_locations.loc_information17%type ;
1929: l_address_line1 hr_locations.address_line_1%type ;
1930: l_address_line2 hr_locations.address_line_2%type ;
1931: l_address_line3 hr_locations.address_line_3%type ;
1932: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1933: l_telephone_number_2 hr_locations.telephone_number_2%type ;

Line 1930: l_address_line2 hr_locations.address_line_2%type ;

1926: l_county hr_locations.loc_information19%type ;
1927: l_state hr_locations.loc_information18%type ;
1928: l_city hr_locations.loc_information17%type ;
1929: l_address_line1 hr_locations.address_line_1%type ;
1930: l_address_line2 hr_locations.address_line_2%type ;
1931: l_address_line3 hr_locations.address_line_3%type ;
1932: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1933: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1934: l_telephone_number_3 hr_locations.telephone_number_3%type ;

Line 1931: l_address_line3 hr_locations.address_line_3%type ;

1927: l_state hr_locations.loc_information18%type ;
1928: l_city hr_locations.loc_information17%type ;
1929: l_address_line1 hr_locations.address_line_1%type ;
1930: l_address_line2 hr_locations.address_line_2%type ;
1931: l_address_line3 hr_locations.address_line_3%type ;
1932: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1933: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1934: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1935: l_postal_code hr_locations.postal_code%type ;

Line 1932: l_telephone_number_1 hr_locations.telephone_number_1%type ;

1928: l_city hr_locations.loc_information17%type ;
1929: l_address_line1 hr_locations.address_line_1%type ;
1930: l_address_line2 hr_locations.address_line_2%type ;
1931: l_address_line3 hr_locations.address_line_3%type ;
1932: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1933: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1934: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1935: l_postal_code hr_locations.postal_code%type ;
1936: l_process_event_id pay_process_events.process_event_id%type ;

Line 1933: l_telephone_number_2 hr_locations.telephone_number_2%type ;

1929: l_address_line1 hr_locations.address_line_1%type ;
1930: l_address_line2 hr_locations.address_line_2%type ;
1931: l_address_line3 hr_locations.address_line_3%type ;
1932: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1933: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1934: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1935: l_postal_code hr_locations.postal_code%type ;
1936: l_process_event_id pay_process_events.process_event_id%type ;
1937: l_object_version_number pay_process_events.object_version_number%type;

Line 1934: l_telephone_number_3 hr_locations.telephone_number_3%type ;

1930: l_address_line2 hr_locations.address_line_2%type ;
1931: l_address_line3 hr_locations.address_line_3%type ;
1932: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1933: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1934: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1935: l_postal_code hr_locations.postal_code%type ;
1936: l_process_event_id pay_process_events.process_event_id%type ;
1937: l_object_version_number pay_process_events.object_version_number%type;
1938: l_out_mesg out_mesg_type ;

Line 1935: l_postal_code hr_locations.postal_code%type ;

1931: l_address_line3 hr_locations.address_line_3%type ;
1932: l_telephone_number_1 hr_locations.telephone_number_1%type ;
1933: l_telephone_number_2 hr_locations.telephone_number_2%type ;
1934: l_telephone_number_3 hr_locations.telephone_number_3%type ;
1935: l_postal_code hr_locations.postal_code%type ;
1936: l_process_event_id pay_process_events.process_event_id%type ;
1937: l_object_version_number pay_process_events.object_version_number%type;
1938: l_out_mesg out_mesg_type ;
1939:

Line 3315: from hr_locations hrlock

3311: cursor c_work_state_cur(p_assign_id in number) is
3312: select nvl(hrlock.loc_information17
3313: ,hrlock.region_2) state
3314:
3315: from hr_locations hrlock
3316: ,hr_soft_coding_keyflex hrsckf
3317: ,per_all_assignments_f paf
3318:
3319: where paf.effective_start_date <=