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.

APPS.PAY_DK_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 160: FROM hr_organization_information

156: ----------------------------------------------------
157: -- Cursor to get the messages from Busineess Group:Payslip Info
158: CURSOR csr_get_message(p_bus_grp_id NUMBER) IS
159: SELECT org_information6 message
160: FROM hr_organization_information
161: WHERE organization_id = p_bus_grp_id
162: AND org_information_context = 'Business Group:Payslip Info'
163: AND org_information1 = 'MESG';
164:

Line 174: FROM hr_organization_information

170: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
171: SELECT org_information4 balance_type_id
172: ,org_information5 balance_dim_id
173: ,org_information7 narrative
174: FROM hr_organization_information
175: WHERE organization_id = p_bus_grp_id
176: AND org_information_context = 'Business Group:Payslip Info'
177: AND org_information1 = 'BALANCE';
178:

Line 217: FROM hr_organization_information hoi

213: ,hoi.org_information3 input_value_id
214: ,code.org_information2||','||hoi.org_information7 element_narrative --changes to payslip w.r.t bug - 7229247
215: ,pec.classification_name
216: ,piv.uom
217: FROM hr_organization_information hoi
218: ,hr_organization_information code
219: ,pay_element_classifications pec
220: ,pay_element_types_f pet
221: ,pay_input_values_f piv

Line 218: ,hr_organization_information code

214: ,code.org_information2||','||hoi.org_information7 element_narrative --changes to payslip w.r.t bug - 7229247
215: ,pec.classification_name
216: ,piv.uom
217: FROM hr_organization_information hoi
218: ,hr_organization_information code
219: ,pay_element_classifications pec
220: ,pay_element_types_f pet
221: ,pay_input_values_f piv
222: WHERE hoi.organization_id = p_bus_grp_id

Line 930: FROM hr_organization_information

926: --------------
927: /* Cursor to retrieve Currency */
928: CURSOR csr_currency(p_bg_id NUMBER) IS
929: SELECT org_information10
930: FROM hr_organization_information
931: WHERE organization_id = p_bg_id
932: AND org_information_context = 'Business Group Information';
933:
934: --------------

Line 942: , HR_ORGANIZATION_INFORMATION hoi1

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
946: AND hoi1.organization_id = o1.organization_id

Line 943: , HR_ORGANIZATION_INFORMATION hoi2

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
946: AND hoi1.organization_id = o1.organization_id
947: AND hoi1.organization_id = p_organization_id

Line 944: , HR_ORGANIZATION_INFORMATION hoi3

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
946: AND hoi1.organization_id = o1.organization_id
947: AND hoi1.organization_id = p_organization_id
948: AND hoi1.org_information1 = 'DK_LOCAL_UNIT'

Line 1024: FROM hr_organization_information hoi

1020: /*Cursor to pick Legal Employer Phone Numbers*/
1021:
1022: CURSOR csr_le_phone (l_legal_employer_id NUMBER) IS
1023: SELECT org_information3 le_phone_num
1024: FROM hr_organization_information hoi
1025: WHERE organization_id = l_legal_employer_id
1026: AND org_information_context = 'ORG_CONTACT_DETAILS'
1027: AND org_information1 = 'PHONE' ;
1028:

Line 1035: FROM hr_organization_information hoi

1031: /*Cursor to pick Legal Employer CVR Number */
1032:
1033: CURSOR csr_le_cvr (l_legal_employer_id NUMBER) IS
1034: SELECT ORG_INFORMATION1
1035: FROM hr_organization_information hoi
1036: WHERE organization_id = l_legal_employer_id
1037: AND org_information_context = 'DK_LEGAL_ENTITY_DETAILS' ;
1038:
1039: --------------

Line 1057: l_currency hr_organization_information.org_information10%TYPE;

1053: l_nationality per_all_people_f.nationality%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);

Line 1073: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

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;
1076: l_defined_balance_id NUMBER;
1077: l_balance_value NUMBER;

Line 1429: ,hr_organization_information code

1425: FROM pay_element_types_f et
1426: , pay_element_types_f_tl pettl
1427: , pay_input_values_f iv
1428: , pay_element_classifications classification
1429: ,hr_organization_information code
1430: WHERE et.element_type_id = iv.element_type_id
1431: AND et.element_type_id = pettl.element_type_id
1432: AND pettl.language = USERENV('LANG')
1433: AND iv.name = 'Pay Value'

Line 1460: ,hr_organization_information code

1456: FROM pay_element_types_f et
1457: , pay_element_types_f_tl pettl
1458: , pay_input_values_f iv
1459: , pay_element_classifications classification
1460: ,hr_organization_information code
1461: WHERE et.element_type_id = iv.element_type_id
1462: AND et.element_type_id = pettl.element_type_id
1463: AND pettl.language = USERENV('LANG')
1464: AND iv.name = 'Pay Value'

Line 2028: FROM hr_organization_information hoi

2024: ,hoi.org_information3 input_value_id
2025: ,hoi.org_information7 element_narrative
2026: ,pec.classification_name
2027: ,piv.uom
2028: FROM hr_organization_information hoi
2029: ,pay_element_classifications pec
2030: ,pay_element_types_f pet
2031: ,pay_input_values_f piv
2032: WHERE hoi.organization_id = p_bus_grp_id

Line 2085: from hr_organization_information code

2081: -----------------------------------------------------------------------------
2082: -- Cursor to pick up segment from DK_SOE_ELEMENT_ADD_DETAILS context Org Developer DF
2083: CURSOR csr_group_by( p_ele_type_id NUMBER ) IS
2084: select ORG_INFORMATION3,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
2085: from hr_organization_information code
2086: where code.organization_id = g_business_group_id
2087: and code.org_information_context ='DK_SOE_ELEMENT_ADD_DETAILS'
2088: and code.org_information1 = fnd_number.number_to_canonical(p_ele_type_id);
2089:

Line 2585: FROM hr_organization_information

2581: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
2582: SELECT org_information4 balance_type_id
2583: ,org_information5 balance_dim_id
2584: ,org_information7 narrative
2585: FROM hr_organization_information
2586: WHERE organization_id = p_bus_grp_id
2587: AND org_information_context = 'Business Group:Payslip Info'
2588: AND org_information1 = 'BALANCE';
2589:

Line 3772: from hr_organization_information code

3768: ---------------
3769: -- Cursor to pick up segment from DK_SOE_ELEMENT_ADD_DETAILS context Org Developer DF
3770: CURSOR csr_group_by( p_ele_type_id NUMBER ) IS
3771: select ORG_INFORMATION3,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
3772: from hr_organization_information code
3773: where code.organization_id = g_business_group_id
3774: and code.org_information_context ='DK_SOE_ELEMENT_ADD_DETAILS'
3775: and code.org_information1 =fnd_number.number_to_canonical(p_ele_type_id);
3776: