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

Line 724: ,hr_organization_units hou

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

Line 735: hr_organization_units hoa

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

Line 743: FROM hr_organization_units

739: AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));
740: /* Cursor to retrieve Business Group Id */
741: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS
742: SELECT business_group_id
743: FROM hr_organization_units
744: WHERE organization_id = p_organization_id;
745: /* Cursor to retrieve Currency */
746: CURSOR csr_currency(p_bg_id NUMBER) IS
747: SELECT org_information10

Line 754: FROM HR_ORGANIZATION_UNITS o1

750: AND org_information_context = 'Business Group Information';
751: l_bg_id NUMBER;
752: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
753: SELECT hoi3.organization_id
754: FROM HR_ORGANIZATION_UNITS o1
755: , HR_ORGANIZATION_INFORMATION hoi1
756: , HR_ORGANIZATION_INFORMATION hoi2
757: , HR_ORGANIZATION_INFORMATION hoi3
758: WHERE o1.business_group_id =l_bg_id

Line 819: l_organization hr_organization_units.name%TYPE;

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

Line 830: l_employer_name hr_organization_units.name%TYPE;

826: l_org_country VARCHAR2(30);
827: l_action_info_id NUMBER;
828: l_ovn NUMBER;
829: l_person_id NUMBER;
830: l_employer_name hr_organization_units.name%TYPE;
831: l_local_unit_id hr_organization_units.organization_id%TYPE;
832: l_legal_employer_id hr_organization_units.organization_id%TYPE;
833: l_job PER_JOBS.NAME%TYPE;
834: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

Line 831: l_local_unit_id hr_organization_units.organization_id%TYPE;

827: l_action_info_id NUMBER;
828: l_ovn NUMBER;
829: l_person_id NUMBER;
830: l_employer_name hr_organization_units.name%TYPE;
831: l_local_unit_id hr_organization_units.organization_id%TYPE;
832: l_legal_employer_id hr_organization_units.organization_id%TYPE;
833: l_job PER_JOBS.NAME%TYPE;
834: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
835: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;

Line 832: l_legal_employer_id hr_organization_units.organization_id%TYPE;

828: l_ovn NUMBER;
829: l_person_id NUMBER;
830: l_employer_name hr_organization_units.name%TYPE;
831: l_local_unit_id hr_organization_units.organization_id%TYPE;
832: l_legal_employer_id hr_organization_units.organization_id%TYPE;
833: l_job PER_JOBS.NAME%TYPE;
834: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
835: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
836: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;

Line 919: FROM hr_organization_units

915: ELSE
916: l_job := NULL;
917: END IF;
918: SELECT name INTO l_organization
919: FROM hr_organization_units
920: WHERE organization_id = rec_person_details.org_id;
921:
922: SELECT name INTO l_employer_name
923: FROM hr_organization_units

Line 923: FROM hr_organization_units

919: FROM hr_organization_units
920: WHERE organization_id = rec_person_details.org_id;
921:
922: SELECT name INTO l_employer_name
923: FROM hr_organization_units
924: WHERE organization_id = l_legal_employer_id;
925: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
926: IF rec_primary_address.style = 'FI' THEN
927: l_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_primary_address.postal_code);

Line 2918: FROM HR_ORGANIZATION_UNITS o1

2914:
2915:
2916: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS
2917: SELECT hoi3.organization_id
2918: FROM HR_ORGANIZATION_UNITS o1
2919: , HR_ORGANIZATION_INFORMATION hoi1
2920: , HR_ORGANIZATION_INFORMATION hoi2
2921: , HR_ORGANIZATION_INFORMATION hoi3
2922: WHERE o1.business_group_id =p_business_group_id

Line 2941: ,hr_organization_units hou

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:
2945: CURSOR csr_effective_date (p_payroll_action_id pay_action_information.action_information1%TYPE ) IS