APPS.PAY_ES_TWR_CALC_PKG dependencies on HR_LOCATIONS

Line 608: FROM hr_locations pa

604: AND paaf.effective_end_date;
605: --
606: CURSOR cur_emp_loc_chk IS
607: SELECT pa.Region_2
608: FROM hr_locations pa
609: ,per_All_assignments_f paaf
610: WHERE paaf.assignment_id = passignment_id
611: AND paaf.location_id = pa.location_id
612: AND pa.style IN ('ES','ES_GLB')

Line 618: l_region1 hr_locations.Region_2%type;

614: AND paaf.effective_end_date
615: AND pa.Region_2 IN (51,52);
616: --
617: l_region per_addresses.Region_2%type;
618: l_region1 hr_locations.Region_2%type;
619: --
620: BEGIN
621: --
622: OPEN cur_emp_address_chk;