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.

[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 903: ,hr_organization_units hou

899: ,hla.address_line_2 AL2
900: ,hla.address_line_3 AL3
901: ,hla.postal_code postal_code
902: FROM hr_locations_all hla
903: ,hr_organization_units hou
904: WHERE hou.organization_id = p_organization_id
905: AND hou.location_id = hla.location_id;
906: -------------
907: CURSOR csr_organization_address(p_organization_id NUMBER) IS

Line 915: hr_organization_units hoa

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

Line 924: FROM hr_organization_units

920: --------------
921: /* Cursor to retrieve Business Group Id */
922: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS
923: SELECT business_group_id
924: FROM hr_organization_units
925: WHERE organization_id = p_organization_id;
926: --------------
927: /* Cursor to retrieve Currency */
928: CURSOR csr_currency(p_bg_id NUMBER) IS

Line 941: FROM HR_ORGANIZATION_UNITS o1

937:
938: /*
939: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
940: SELECT hoi3.organization_id
941: FROM HR_ORGANIZATION_UNITS o1
942: , HR_ORGANIZATION_INFORMATION hoi1
943: , HR_ORGANIZATION_INFORMATION hoi2
944: , HR_ORGANIZATION_INFORMATION hoi3
945: WHERE o1.business_group_id =l_bg_id

Line 1045: FROM hr_organization_units

1041: /* Cursor added to fetch the organization name */
1042:
1043: CURSOR csr_org_name (org_id NUMBER) IS
1044: SELECT name
1045: FROM hr_organization_units
1046: WHERE organization_id = org_id ;
1047:
1048: -------------
1049: rec_person_details csr_person_details%ROWTYPE;

Line 1058: l_organization hr_organization_units.name%TYPE;

1054: l_position per_all_positions.name%TYPE;
1055: l_hire_date per_periods_of_service.date_start%TYPE;
1056: l_grade per_grades.name%TYPE;
1057: l_currency hr_organization_information.org_information10%TYPE;
1058: l_organization hr_organization_units.name%TYPE;
1059: l_pay_location hr_locations_all.address_line_1%TYPE;
1060: l_postal_code VARCHAR2(80);
1061: l_country VARCHAR2(30);
1062: l_emp_postal_code VARCHAR2(80);

Line 1069: l_employer_name hr_organization_units.name%TYPE;

1065: l_org_country VARCHAR2(30);
1066: l_action_info_id NUMBER;
1067: l_ovn NUMBER;
1068: l_person_id NUMBER;
1069: l_employer_name hr_organization_units.name%TYPE;
1070: l_local_unit_id hr_organization_units.organization_id%TYPE;
1071: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1072: l_job PER_JOBS.NAME%TYPE;
1073: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

Line 1070: l_local_unit_id hr_organization_units.organization_id%TYPE;

1066: l_action_info_id NUMBER;
1067: l_ovn NUMBER;
1068: l_person_id NUMBER;
1069: l_employer_name hr_organization_units.name%TYPE;
1070: l_local_unit_id hr_organization_units.organization_id%TYPE;
1071: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1072: l_job PER_JOBS.NAME%TYPE;
1073: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1074: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;

Line 1071: l_legal_employer_id hr_organization_units.organization_id%TYPE;

1067: l_ovn NUMBER;
1068: l_person_id NUMBER;
1069: l_employer_name hr_organization_units.name%TYPE;
1070: l_local_unit_id hr_organization_units.organization_id%TYPE;
1071: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1072: l_job PER_JOBS.NAME%TYPE;
1073: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1074: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1075: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;

Line 1207: FROM hr_organization_units

1203:
1204: /*
1205: -- HR ORG at asg level Name
1206: SELECT name INTO l_organization
1207: FROM hr_organization_units
1208: WHERE organization_id = rec_person_details.org_id;
1209:
1210: -- Legal Employer Name
1211: SELECT name INTO l_employer_name

Line 1212: FROM hr_organization_units

1208: WHERE organization_id = rec_person_details.org_id;
1209:
1210: -- Legal Employer Name
1211: SELECT name INTO l_employer_name
1212: FROM hr_organization_units
1213: WHERE organization_id = l_legal_employer_id;
1214: */
1215:
1216: -- HR ORG at asg level Name

Line 3754: , hr_organization_units hou

3750: SELECT hou.name
3751: FROM
3752: pay_run_result_values rrv
3753: , pay_input_values_f iv
3754: , hr_organization_units hou
3755: WHERE rrv.run_result_id = p_run_result_id
3756: AND rrv.input_value_id = iv.input_value_id
3757: AND iv.name = 'Third Party Payee'
3758: AND p_effective_date between