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_SE_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 763: ,hr_organization_units hou

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
767: SELECT hla.style style

Line 774: hr_organization_units hoa

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
778: AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 782: FROM hr_organization_units

778: AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));
779: /* Cursor to retrieve Business Group Id */
780: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS
781: SELECT business_group_id
782: FROM hr_organization_units
783: WHERE organization_id = p_organization_id;
784: /* Cursor to retrieve Currency */
785: CURSOR csr_currency(p_bg_id NUMBER) IS
786: SELECT org_information10

Line 793: FROM HR_ORGANIZATION_UNITS o1

789: AND org_information_context = 'Business Group Information';
790: l_bg_id NUMBER;
791: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
792: SELECT hoi3.organization_id
793: FROM HR_ORGANIZATION_UNITS o1
794: , HR_ORGANIZATION_INFORMATION hoi1
795: , HR_ORGANIZATION_INFORMATION hoi2
796: , HR_ORGANIZATION_INFORMATION hoi3
797: WHERE o1.business_group_id =l_bg_id

Line 858: l_organization hr_organization_units.name%TYPE;

854: l_position per_all_positions.name%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);

Line 869: l_employer_name hr_organization_units.name%TYPE;

865: l_org_country VARCHAR2(30);
866: l_action_info_id NUMBER;
867: l_ovn NUMBER;
868: l_person_id NUMBER;
869: l_employer_name hr_organization_units.name%TYPE;
870: l_local_unit_id hr_organization_units.organization_id%TYPE;
871: l_legal_employer_id hr_organization_units.organization_id%TYPE;
872: l_job PER_JOBS.NAME%TYPE;
873: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

Line 870: l_local_unit_id hr_organization_units.organization_id%TYPE;

866: l_action_info_id NUMBER;
867: l_ovn NUMBER;
868: l_person_id NUMBER;
869: l_employer_name hr_organization_units.name%TYPE;
870: l_local_unit_id hr_organization_units.organization_id%TYPE;
871: l_legal_employer_id hr_organization_units.organization_id%TYPE;
872: l_job PER_JOBS.NAME%TYPE;
873: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
874: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;

Line 871: l_legal_employer_id hr_organization_units.organization_id%TYPE;

867: l_ovn NUMBER;
868: l_person_id NUMBER;
869: l_employer_name hr_organization_units.name%TYPE;
870: l_local_unit_id hr_organization_units.organization_id%TYPE;
871: l_legal_employer_id hr_organization_units.organization_id%TYPE;
872: l_job PER_JOBS.NAME%TYPE;
873: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
874: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
875: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;

Line 958: FROM hr_organization_units

954: ELSE
955: l_job := NULL;
956: END IF;
957: SELECT name INTO l_organization
958: FROM hr_organization_units
959: WHERE organization_id = rec_person_details.org_id;
960:
961: SELECT name INTO l_employer_name
962: FROM hr_organization_units

Line 962: FROM hr_organization_units

958: FROM hr_organization_units
959: WHERE organization_id = rec_person_details.org_id;
960:
961: SELECT name INTO l_employer_name
962: FROM hr_organization_units
963: WHERE organization_id = l_legal_employer_id;
964: --fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');
965: IF rec_primary_address.style = 'SE' THEN
966: l_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_primary_address.postal_code);

Line 3764: FROM HR_ORGANIZATION_UNITS o1

3760:
3761:
3762: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS
3763: SELECT hoi3.organization_id
3764: FROM HR_ORGANIZATION_UNITS o1
3765: , HR_ORGANIZATION_INFORMATION hoi1
3766: , HR_ORGANIZATION_INFORMATION hoi2
3767: , HR_ORGANIZATION_INFORMATION hoi3
3768: WHERE o1.business_group_id =p_business_group_id

Line 3787: ,hr_organization_units hou

3783: ,hla.address_line_2 AL2
3784: ,hla.address_line_3 AL3
3785: ,hla.postal_code postal_code
3786: FROM hr_locations_all hla
3787: ,hr_organization_units hou
3788: WHERE hou.organization_id = p_organization_id
3789: AND hou.location_id = hla.location_id;
3790:
3791: CURSOR csr_effective_date (p_payroll_action_id pay_action_information.action_information1%TYPE ) IS