APPS.PAY_FI_ARCHIVE_PYSA dependencies on HR_LOCATIONS_ALL

Line 723: FROM hr_locations_all hla

719: ,hla.address_line_1 AL1
720: ,hla.address_line_2 AL2
721: ,hla.address_line_3 AL3
722: ,hla.postal_code postal_code
723: FROM hr_locations_all hla
724: ,hr_organization_units hou
725: WHERE hou.organization_id = p_organization_id
726: AND hou.location_id = hla.location_id;
727: CURSOR csr_organization_address(p_organization_id NUMBER) IS

Line 734: FROM hr_locations_all hla,

730: ,hla.address_line_2 AL2
731: ,hla.address_line_3 AL3
732: ,hla.country country
733: ,hla.postal_code postal_code
734: FROM hr_locations_all hla,
735: hr_organization_units hoa
736: WHERE hla.location_id = hoa.location_id
737: AND hoa.organization_id = p_organization_id
738: AND p_effective_date BETWEEN hoa.date_from

Line 792: FROM hr_locations_all

788: AND effective_end_date;
789: /* Cursor to pick up Payroll Location */
790: CURSOR csr_pay_location(p_location_id NUMBER) IS
791: SELECT location_code location
792: FROM hr_locations_all
793: WHERE location_id = p_location_id;
794: /* Cursor to pick Hire Date*/
795: CURSOR csr_hire_date (p_assignment_id NUMBER) IS
796: SELECT trunc(date_start) date_start

Line 820: l_pay_location hr_locations_all.address_line_1%TYPE;

816: l_hire_date per_periods_of_service.date_start%TYPE;
817: l_grade per_grades.name%TYPE;
818: l_currency hr_organization_information.org_information10%TYPE;
819: l_organization hr_organization_units.name%TYPE;
820: l_pay_location hr_locations_all.address_line_1%TYPE;
821: l_postal_code VARCHAR2(80);
822: l_country VARCHAR2(30);
823: l_emp_postal_code VARCHAR2(80);
824: l_emp_country VARCHAR2(30);

Line 2940: FROM hr_locations_all hla

2936: ,hla.address_line_1 AL1
2937: ,hla.address_line_2 AL2
2938: ,hla.address_line_3 AL3
2939: ,hla.postal_code postal_code
2940: FROM hr_locations_all hla
2941: ,hr_organization_units hou
2942: WHERE hou.organization_id = p_organization_id
2943: AND hou.location_id = hla.location_id;
2944: