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: ,hoi.org_information7 element_narrative
215: ,pec.classification_name
216: ,piv.uom
217: FROM hr_organization_information hoi
218: ,pay_element_classifications pec
219: ,pay_element_types_f pet
220: ,pay_input_values_f piv
221: WHERE hoi.organization_id = p_bus_grp_id

Line 921: FROM hr_organization_information

917: --------------
918: /* Cursor to retrieve Currency */
919: CURSOR csr_currency(p_bg_id NUMBER) IS
920: SELECT org_information10
921: FROM hr_organization_information
922: WHERE organization_id = p_bg_id
923: AND org_information_context = 'Business Group Information';
924:
925: --------------

Line 933: , HR_ORGANIZATION_INFORMATION hoi1

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

Line 934: , HR_ORGANIZATION_INFORMATION hoi2

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

Line 935: , HR_ORGANIZATION_INFORMATION hoi3

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
937: AND hoi1.organization_id = o1.organization_id
938: AND hoi1.organization_id = p_organization_id
939: AND hoi1.org_information1 = 'DK_LOCAL_UNIT'

Line 1015: FROM hr_organization_information hoi

1011: /*Cursor to pick Legal Employer Phone Numbers*/
1012:
1013: CURSOR csr_le_phone (l_legal_employer_id NUMBER) IS
1014: SELECT org_information3 le_phone_num
1015: FROM hr_organization_information hoi
1016: WHERE organization_id = l_legal_employer_id
1017: AND org_information_context = 'ORG_CONTACT_DETAILS'
1018: AND org_information1 = 'PHONE' ;
1019:

Line 1026: FROM hr_organization_information hoi

1022: /*Cursor to pick Legal Employer CVR Number */
1023:
1024: CURSOR csr_le_cvr (l_legal_employer_id NUMBER) IS
1025: SELECT ORG_INFORMATION1
1026: FROM hr_organization_information hoi
1027: WHERE organization_id = l_legal_employer_id
1028: AND org_information_context = 'DK_LEGAL_ENTITY_DETAILS' ;
1029:
1030: --------------

Line 1048: l_currency hr_organization_information.org_information10%TYPE;

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

Line 1064: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

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;
1067: l_defined_balance_id NUMBER;
1068: l_balance_value NUMBER;

Line 2000: FROM hr_organization_information hoi

1996: ,hoi.org_information3 input_value_id
1997: ,hoi.org_information7 element_narrative
1998: ,pec.classification_name
1999: ,piv.uom
2000: FROM hr_organization_information hoi
2001: ,pay_element_classifications pec
2002: ,pay_element_types_f pet
2003: ,pay_input_values_f piv
2004: WHERE hoi.organization_id = p_bus_grp_id

Line 2160: FROM hr_organization_information

2156: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
2157: SELECT org_information4 balance_type_id
2158: ,org_information5 balance_dim_id
2159: ,org_information7 narrative
2160: FROM hr_organization_information
2161: WHERE organization_id = p_bus_grp_id
2162: AND org_information_context = 'Business Group:Payslip Info'
2163: AND org_information1 = 'BALANCE';
2164: