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

Line 482: CURSOR csr_asg_empr_location(c_location_id hr_locations.location_id%type)

478: skip_assignment Exception;
479: l_flag VARCHAR2(2);
480:
481: /* 10277535 start */
482: CURSOR csr_asg_empr_location(c_location_id hr_locations.location_id%type)
483: IS
484: SELECT NVL (TRIM (RPAD (hl.ADDRESS_LINE_1, 30)), ' ') address_line1,
485: NVL (TRIM (RPAD (hl.ADDRESS_LINE_2, 30)), ' ') address_line2,
486: NVL (TRIM (RPAD (hl.ADDRESS_LINE_3, 30)), ' ') address_line3,

Line 488: FROM hr_locations hl

484: SELECT NVL (TRIM (RPAD (hl.ADDRESS_LINE_1, 30)), ' ') address_line1,
485: NVL (TRIM (RPAD (hl.ADDRESS_LINE_2, 30)), ' ') address_line2,
486: NVL (TRIM (RPAD (hl.ADDRESS_LINE_3, 30)), ' ') address_line3,
487: NVL (TRIM (RPAD (hl.LOCATION_CODE, 30)), ' ') Location_name
488: FROM hr_locations hl
489: WHERE hl.location_id =c_location_id;
490: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
491: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
492: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;

Line 491: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;

487: NVL (TRIM (RPAD (hl.LOCATION_CODE, 30)), ' ') Location_name
488: FROM hr_locations hl
489: WHERE hl.location_id =c_location_id;
490: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
491: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
492: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;
493: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;
494: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;
495:

Line 492: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;

488: FROM hr_locations hl
489: WHERE hl.location_id =c_location_id;
490: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
491: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
492: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;
493: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;
494: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;
495:
496:

Line 493: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;

489: WHERE hl.location_id =c_location_id;
490: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
491: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
492: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;
493: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;
494: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;
495:
496:
497: /* 10277535 end */

Line 494: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;

490: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
491: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
492: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;
493: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;
494: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;
495:
496:
497: /* 10277535 end */
498: