APPS.PAY_DK_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 894: ,hr_organization_units hou

890: ,hla.address_line_2 AL2
891: ,hla.address_line_3 AL3
892: ,hla.postal_code postal_code
893: FROM hr_locations_all hla
894: ,hr_organization_units hou
895: WHERE hou.organization_id = p_organization_id
896: AND hou.location_id = hla.location_id;
897: -------------
898: CURSOR csr_organization_address(p_organization_id NUMBER) IS

Line 906: hr_organization_units hoa

902: ,hla.address_line_3 AL3
903: ,hla.country country
904: ,hla.postal_code postal_code
905: FROM hr_locations_all hla,
906: hr_organization_units hoa
907: WHERE hla.location_id = hoa.location_id
908: AND hoa.organization_id = p_organization_id
909: AND p_effective_date BETWEEN hoa.date_from AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));
910:

Line 915: FROM hr_organization_units

911: --------------
912: /* Cursor to retrieve Business Group Id */
913: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS
914: SELECT business_group_id
915: FROM hr_organization_units
916: WHERE organization_id = p_organization_id;
917: --------------
918: /* Cursor to retrieve Currency */
919: CURSOR csr_currency(p_bg_id NUMBER) IS

Line 932: FROM HR_ORGANIZATION_UNITS o1

928:
929: /*
930: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
931: SELECT hoi3.organization_id
932: FROM HR_ORGANIZATION_UNITS o1
933: , HR_ORGANIZATION_INFORMATION hoi1
934: , HR_ORGANIZATION_INFORMATION hoi2
935: , HR_ORGANIZATION_INFORMATION hoi3
936: WHERE o1.business_group_id =l_bg_id

Line 1036: FROM hr_organization_units

1032: /* Cursor added to fetch the organization name */
1033:
1034: CURSOR csr_org_name (org_id NUMBER) IS
1035: SELECT name
1036: FROM hr_organization_units
1037: WHERE organization_id = org_id ;
1038:
1039: -------------
1040: rec_person_details csr_person_details%ROWTYPE;

Line 1049: l_organization hr_organization_units.name%TYPE;

1045: l_position per_all_positions.name%TYPE;
1046: l_hire_date per_periods_of_service.date_start%TYPE;
1047: l_grade per_grades.name%TYPE;
1048: l_currency hr_organization_information.org_information10%TYPE;
1049: l_organization hr_organization_units.name%TYPE;
1050: l_pay_location hr_locations_all.address_line_1%TYPE;
1051: l_postal_code VARCHAR2(80);
1052: l_country VARCHAR2(30);
1053: l_emp_postal_code VARCHAR2(80);

Line 1060: l_employer_name hr_organization_units.name%TYPE;

1056: l_org_country VARCHAR2(30);
1057: l_action_info_id NUMBER;
1058: l_ovn NUMBER;
1059: l_person_id NUMBER;
1060: l_employer_name hr_organization_units.name%TYPE;
1061: l_local_unit_id hr_organization_units.organization_id%TYPE;
1062: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1063: l_job PER_JOBS.NAME%TYPE;
1064: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

Line 1061: l_local_unit_id hr_organization_units.organization_id%TYPE;

1057: l_action_info_id NUMBER;
1058: l_ovn NUMBER;
1059: l_person_id NUMBER;
1060: l_employer_name hr_organization_units.name%TYPE;
1061: l_local_unit_id hr_organization_units.organization_id%TYPE;
1062: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1063: l_job PER_JOBS.NAME%TYPE;
1064: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1065: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;

Line 1062: l_legal_employer_id hr_organization_units.organization_id%TYPE;

1058: l_ovn NUMBER;
1059: l_person_id NUMBER;
1060: l_employer_name hr_organization_units.name%TYPE;
1061: l_local_unit_id hr_organization_units.organization_id%TYPE;
1062: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1063: l_job PER_JOBS.NAME%TYPE;
1064: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1065: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1066: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;

Line 1197: FROM hr_organization_units

1193:
1194: /*
1195: -- HR ORG at asg level Name
1196: SELECT name INTO l_organization
1197: FROM hr_organization_units
1198: WHERE organization_id = rec_person_details.org_id;
1199:
1200: -- Legal Employer Name
1201: SELECT name INTO l_employer_name

Line 1202: FROM hr_organization_units

1198: WHERE organization_id = rec_person_details.org_id;
1199:
1200: -- Legal Employer Name
1201: SELECT name INTO l_employer_name
1202: FROM hr_organization_units
1203: WHERE organization_id = l_legal_employer_id;
1204: */
1205:
1206: -- HR ORG at asg level Name

Line 3281: , hr_organization_units hou

3277: SELECT hou.name
3278: FROM
3279: pay_run_result_values rrv
3280: , pay_input_values_f iv
3281: , hr_organization_units hou
3282: WHERE rrv.run_result_id = p_run_result_id
3283: AND rrv.input_value_id = iv.input_value_id
3284: AND iv.name = 'Third Party Payee'
3285: AND p_effective_date between