APPS.PAY_AE_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 896: ,hr_organization_units hou

892: ,hla.address_line_2 AL2
893: ,hla.address_line_3 AL3
894: ,hla.postal_code postal_code
895: FROM hr_locations_all hla
896: ,hr_organization_units hou
897: ,per_all_assignments_f paa
898: ,hr_soft_coding_keyflex hscl
899: WHERE hscl.segment1 = hou.organization_id
900: AND hscl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 919: hr_organization_units hoa

915: ,hla.region_3 R3
916: ,hla.country country
917: ,hla.postal_code postal_code
918: FROM hr_locations_all hla,
919: hr_organization_units hoa
920: WHERE hla.location_id = hoa.location_id
921: AND hoa.organization_id = p_organization_id
922: AND p_effective_date BETWEEN hoa.date_from
923: AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 938: FROM hr_organization_units

934:
935: /* Cursor to retrieve Business Group Id */
936: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS
937: SELECT business_group_id
938: FROM hr_organization_units
939: WHERE organization_id = p_organization_id;
940:
941: /* Cursor to retrieve Currency */
942: CURSOR csr_currency(p_bg_id NUMBER) IS

Line 996: l_organization hr_organization_units.name%TYPE;

992: l_position per_all_positions.name%TYPE;
993: l_grade per_grades.name%TYPE;
994: l_job per_jobs.name%TYPE;
995: l_currency hr_organization_information.org_information10%TYPE;
996: l_organization hr_organization_units.name%TYPE;
997: l_pay_location hr_locations_all.address_line_1%TYPE;
998: l_city VARCHAR2(80);
999: l_country VARCHAR2(80);
1000: l_emp_city VARCHAR2(80);

Line 1008: l_employer_name hr_organization_units.name%TYPE;

1004: l_action_info_id NUMBER;
1005: l_ovn NUMBER;
1006: l_person_id NUMBER;
1007: l_bg_id NUMBER;
1008: l_employer_name hr_organization_units.name%TYPE;
1009: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1010: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1011: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1012: l_defined_balance_id NUMBER;

Line 1112: FROM hr_organization_units

1108:
1109:
1110: IF(rec_person_details.org_id IS NOT NULL) THEN
1111: SELECT name INTO l_organization
1112: FROM hr_organization_units
1113: WHERE organization_id = rec_person_details.org_id;
1114: ELSE l_organization := NULL;
1115: END IF;
1116:

Line 1120: FROM hr_organization_units

1116:
1117:
1118: IF(rec_employer_address.org_id IS NOT NULL) THEN
1119: SELECT name INTO l_employer_name
1120: FROM hr_organization_units
1121: WHERE organization_id = rec_employer_address.org_id;
1122: ELSE l_employer_name := NULL;
1123: END IF;
1124: