APPS.PAY_KW_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 893: ,hr_organization_units hou

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

Line 916: hr_organization_units hoa

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

Line 935: FROM hr_organization_units

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

Line 985: l_organization hr_organization_units.name%TYPE;

981: l_position per_all_positions.name%TYPE;
982: l_grade per_grades.name%TYPE;
983: l_job per_jobs.name%TYPE;
984: l_currency hr_organization_information.org_information10%TYPE;
985: l_organization hr_organization_units.name%TYPE;
986: l_pay_location hr_locations_all.address_line_1%TYPE;
987: l_city VARCHAR2(80);
988: l_country VARCHAR2(80);
989: l_emp_city VARCHAR2(80);

Line 997: l_employer_name hr_organization_units.name%TYPE;

993: l_action_info_id NUMBER;
994: l_ovn NUMBER;
995: l_person_id NUMBER;
996: l_bg_id NUMBER;
997: l_employer_name hr_organization_units.name%TYPE;
998: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
999: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1000: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1001: l_defined_balance_id NUMBER;

Line 1096: FROM hr_organization_units

1092:
1093:
1094: IF(rec_person_details.org_id IS NOT NULL) THEN
1095: SELECT name INTO l_organization
1096: FROM hr_organization_units
1097: WHERE organization_id = rec_person_details.org_id;
1098: ELSE l_organization := NULL;
1099: END IF;
1100:

Line 1104: FROM hr_organization_units

1100:
1101:
1102: IF(rec_employer_address.org_id IS NOT NULL) THEN
1103: SELECT name INTO l_employer_name
1104: FROM hr_organization_units
1105: WHERE organization_id = rec_employer_address.org_id;
1106: ELSE l_employer_name := NULL;
1107: END IF;
1108: