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

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

572: l_prev_period_service_id NUMBER;
573: l_prev_asg_action_till_apr NUMBER;
574:
575: /* 10277535 start */
576: CURSOR csr_asg_empr_location(c_location_id hr_locations.location_id%type)
577: IS
578: SELECT NVL (TRIM (RPAD (hl.ADDRESS_LINE_1, 30)), ' ') address_line1,
579: NVL (TRIM (RPAD (hl.ADDRESS_LINE_2, 30)), ' ') address_line2,
580: NVL (TRIM (RPAD (hl.ADDRESS_LINE_3, 30)), ' ') address_line3,

Line 582: FROM hr_locations hl

578: SELECT NVL (TRIM (RPAD (hl.ADDRESS_LINE_1, 30)), ' ') address_line1,
579: NVL (TRIM (RPAD (hl.ADDRESS_LINE_2, 30)), ' ') address_line2,
580: NVL (TRIM (RPAD (hl.ADDRESS_LINE_3, 30)), ' ') address_line3,
581: NVL (TRIM (RPAD (hl.LOCATION_CODE, 30)), ' ') Location_name
582: FROM hr_locations hl
583: WHERE hl.location_id =c_location_id;
584: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
585: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
586: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;

Line 585: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;

581: NVL (TRIM (RPAD (hl.LOCATION_CODE, 30)), ' ') Location_name
582: FROM hr_locations hl
583: WHERE hl.location_id =c_location_id;
584: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
585: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
586: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;
587: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;
588: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;
589:

Line 586: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;

582: FROM hr_locations hl
583: WHERE hl.location_id =c_location_id;
584: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
585: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
586: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;
587: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;
588: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;
589:
590:

Line 587: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;

583: WHERE hl.location_id =c_location_id;
584: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
585: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
586: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;
587: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;
588: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;
589:
590:
591: /* 10277535 end */

Line 588: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;

584: r_asg_empr_location csr_asg_empr_location%ROWTYPE;
585: l_er_address_line1 hr_locations.ADDRESS_LINE_1%TYPE;
586: l_er_address_line2 hr_locations.ADDRESS_LINE_2%TYPE;
587: l_er_address_line3 hr_locations.ADDRESS_LINE_3%TYPE;
588: l_er_loc_name hr_locations.LOCATION_CODE%TYPE;
589:
590:
591: /* 10277535 end */
592: