APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 762: FROM hr_locations_all hla

758: ,hla.address_line_1 AL1
759: ,hla.address_line_2 AL2
760: ,hla.address_line_3 AL3
761: ,hla.postal_code postal_code
762: FROM hr_locations_all hla
763: ,hr_organization_units hou
764: WHERE hou.organization_id = p_organization_id
765: AND hou.location_id = hla.location_id;
766: CURSOR csr_organization_address(p_organization_id NUMBER) IS

Line 773: FROM hr_locations_all hla,

769: ,hla.address_line_2 AL2
770: ,hla.address_line_3 AL3
771: ,hla.country country
772: ,hla.postal_code postal_code
773: FROM hr_locations_all hla,
774: hr_organization_units hoa
775: WHERE hla.location_id = hoa.location_id
776: AND hoa.organization_id = p_organization_id
777: AND p_effective_date BETWEEN hoa.date_from

Line 831: FROM hr_locations_all

827: AND effective_end_date;
828: /* Cursor to pick up Payroll Location */
829: CURSOR csr_pay_location(p_location_id NUMBER) IS
830: SELECT location_code location
831: FROM hr_locations_all
832: WHERE location_id = p_location_id;
833: /* Cursor to pick Hire Date*/
834: CURSOR csr_hire_date (p_assignment_id NUMBER) IS
835: SELECT trunc(date_start) date_start

Line 859: l_pay_location hr_locations_all.address_line_1%TYPE;

855: l_hire_date per_periods_of_service.date_start%TYPE;
856: l_grade per_grades.name%TYPE;
857: l_currency hr_organization_information.org_information10%TYPE;
858: l_organization hr_organization_units.name%TYPE;
859: l_pay_location hr_locations_all.address_line_1%TYPE;
860: l_postal_code VARCHAR2(80);
861: l_country VARCHAR2(30);
862: l_emp_postal_code VARCHAR2(80);
863: l_emp_country VARCHAR2(30);

Line 3811: FROM hr_locations_all hla

3807: ,hla.address_line_1 AL1
3808: ,hla.address_line_2 AL2
3809: ,hla.address_line_3 AL3
3810: ,hla.postal_code postal_code
3811: FROM hr_locations_all hla
3812: ,hr_organization_units hou
3813: WHERE hou.organization_id = p_organization_id
3814: AND hou.location_id = hla.location_id;
3815: