APPS.PAY_ES_TWR_CALC_PKG dependencies on PER_ADDRESSES

Line 594: FROM per_addresses pa

590: ,peffective_date IN DATE) RETURN VARCHAR2 IS
591: --
592: CURSOR cur_emp_address_chk IS
593: SELECT pa.Region_2
594: FROM per_addresses pa
595: ,per_All_assignments_f paaf
596: WHERE paaf.assignment_id = passignment_id
597: AND paaf.person_id = pa.person_id
598: AND pa.style IN('ES','ES_GLB')

Line 617: l_region per_addresses.Region_2%type;

613: AND peffective_date BETWEEN paaf.effective_start_date
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: --