APPS.PAY_SA_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 878: ,hr_organization_units hou

874: ,hla.address_line_2 AL2
875: ,hla.address_line_3 AL3
876: ,hla.postal_code postal_code
877: FROM hr_locations_all hla
878: ,hr_organization_units hou
879: ,per_all_assignments_f paa
880: ,hr_soft_coding_keyflex hscl
881: WHERE hscl.segment1 = hou.organization_id
882: AND hscl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 901: hr_organization_units hoa

897: ,hla.region_3 R3
898: ,hla.country country
899: ,hla.postal_code postal_code
900: FROM hr_locations_all hla,
901: hr_organization_units hoa
902: WHERE hla.location_id = hoa.location_id
903: AND hoa.organization_id = p_organization_id
904: AND p_effective_date BETWEEN hoa.date_from
905: AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 920: FROM hr_organization_units

916:
917: /* Cursor to retrieve Business Group Id */
918: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS
919: SELECT business_group_id
920: FROM hr_organization_units
921: WHERE organization_id = p_organization_id;
922:
923: /* Cursor to retrieve Currency */
924: CURSOR csr_currency(p_bg_id NUMBER) IS

Line 991: l_organization hr_organization_units.name%TYPE;

987: l_nationality per_all_people_f.nationality%TYPE;
988: l_position per_all_positions.name%TYPE;
989: l_grade per_grades.name%TYPE;
990: l_currency hr_organization_information.org_information10%TYPE;
991: l_organization hr_organization_units.name%TYPE;
992: l_pay_location hr_locations_all.address_line_1%TYPE;
993: l_city VARCHAR2(80);
994: l_country VARCHAR2(80);
995: l_emp_city VARCHAR2(80);

Line 1003: l_employer_name hr_organization_units.name%TYPE;

999: l_action_info_id NUMBER;
1000: l_ovn NUMBER;
1001: l_person_id NUMBER;
1002: l_bg_id NUMBER;
1003: l_employer_name hr_organization_units.name%TYPE;
1004: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1005: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1006: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1007: l_defined_balance_id NUMBER;

Line 1100: FROM hr_organization_units

1096: END IF;
1097:
1098:
1099: SELECT name INTO l_organization
1100: FROM hr_organization_units
1101: WHERE organization_id = rec_person_details.org_id;
1102:
1103: SELECT name INTO l_employer_name
1104: FROM hr_organization_units

Line 1104: FROM hr_organization_units

1100: FROM hr_organization_units
1101: WHERE organization_id = rec_person_details.org_id;
1102:
1103: SELECT name INTO l_employer_name
1104: FROM hr_organization_units
1105: WHERE organization_id = rec_employer_address.org_id;
1106:
1107: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1108: l_city := null;