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_NO_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 189: FROM hr_organization_information

185: ----------------------------------------------------
186: -- Cursor to get the messages from Busineess Group:Payslip Info
187: CURSOR csr_get_message(p_bus_grp_id NUMBER) IS
188: SELECT org_information6 message
189: FROM hr_organization_information
190: WHERE organization_id = p_bus_grp_id
191: AND org_information_context = 'Business Group:Payslip Info'
192: AND org_information1 = 'MESG';
193:

Line 203: FROM hr_organization_information

199: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
200: SELECT org_information4 balance_type_id
201: ,org_information5 balance_dim_id
202: ,org_information7 narrative
203: FROM hr_organization_information
204: WHERE organization_id = p_bus_grp_id
205: AND org_information_context = 'Business Group:Payslip Info'
206: AND org_information1 = 'BALANCE';
207:

Line 248: FROM hr_organization_information hoi

244: ,hoi.org_information3 input_value_id
245: ,hoi.org_information7 element_narrative
246: ,pec.classification_name ele_class
247: ,piv.uom uom
248: FROM hr_organization_information hoi
249: ,pay_element_classifications pec
250: ,pay_element_types_f pet
251: ,pay_input_values_f piv
252: WHERE hoi.organization_id = p_bus_grp_id

Line 269: FROM hr_organization_information hoi

265: ,pec.classification_name ele_class
266: ,piv.uom uom
267: ,piv.lookup_type lookup_type
268: ,piv.value_set_id value_set_id
269: FROM hr_organization_information hoi
270: ,pay_element_classifications pec
271: ,pay_element_types_f pet
272: ,pay_input_values_f piv
273: WHERE hoi.organization_id = p_bus_grp_id

Line 1345: FROM hr_organization_information

1341: --------------
1342: /* Cursor to retrieve Currency */
1343: CURSOR csr_currency(p_bg_id NUMBER) IS
1344: SELECT org_information10
1345: FROM hr_organization_information
1346: WHERE organization_id = p_bg_id
1347: AND org_information_context = 'Business Group Information';
1348:
1349: --------------

Line 1358: , HR_ORGANIZATION_INFORMATION hoi1

1354:
1355: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
1356: SELECT hoi3.organization_id
1357: FROM HR_ORGANIZATION_UNITS o1
1358: , HR_ORGANIZATION_INFORMATION hoi1
1359: , HR_ORGANIZATION_INFORMATION hoi2
1360: , HR_ORGANIZATION_INFORMATION hoi3
1361: WHERE o1.business_group_id =l_bg_id
1362: AND hoi1.organization_id = o1.organization_id

Line 1359: , HR_ORGANIZATION_INFORMATION hoi2

1355: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
1356: SELECT hoi3.organization_id
1357: FROM HR_ORGANIZATION_UNITS o1
1358: , HR_ORGANIZATION_INFORMATION hoi1
1359: , HR_ORGANIZATION_INFORMATION hoi2
1360: , HR_ORGANIZATION_INFORMATION hoi3
1361: WHERE o1.business_group_id =l_bg_id
1362: AND hoi1.organization_id = o1.organization_id
1363: AND hoi1.organization_id = p_organization_id

Line 1360: , HR_ORGANIZATION_INFORMATION hoi3

1356: SELECT hoi3.organization_id
1357: FROM HR_ORGANIZATION_UNITS o1
1358: , HR_ORGANIZATION_INFORMATION hoi1
1359: , HR_ORGANIZATION_INFORMATION hoi2
1360: , HR_ORGANIZATION_INFORMATION hoi3
1361: WHERE o1.business_group_id =l_bg_id
1362: AND hoi1.organization_id = o1.organization_id
1363: AND hoi1.organization_id = p_organization_id
1364: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 1428: from hr_organization_information

1424:
1425: /* Ccursor to get the Legal Employer Org Number */
1426: CURSOR csr_le_org_num (l_legal_employer_id NUMBER) IS
1427: select ORG_INFORMATION1
1428: from hr_organization_information
1429: where organization_id = l_legal_employer_id
1430: and ORG_INFORMATION_CONTEXT = 'NO_LEGAL_EMPLOYER_DETAILS' ;
1431:
1432:

Line 1468: l_currency hr_organization_information.org_information10%TYPE;

1464: l_nationality per_all_people_f.nationality%TYPE;
1465: l_position per_all_positions.name%TYPE;
1466: l_hire_date per_periods_of_service.date_start%TYPE;
1467: l_grade per_grades.name%TYPE;
1468: l_currency hr_organization_information.org_information10%TYPE;
1469: l_organization hr_organization_units.name%TYPE;
1470: l_pay_location hr_locations_all.address_line_1%TYPE;
1471: l_postal_code VARCHAR2(80);
1472: l_country VARCHAR2(30);

Line 1484: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

1480: l_employer_name hr_organization_units.name%TYPE;
1481: l_local_unit_id hr_organization_units.organization_id%TYPE;
1482: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1483: l_job PER_JOBS.NAME%TYPE;
1484: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1485: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1486: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1487: l_defined_balance_id NUMBER;
1488: l_balance_value NUMBER;

Line 2969: FROM hr_organization_information hoi

2965: ,hoi.org_information3 input_value_id
2966: ,hoi.org_information7 element_narrative
2967: ,pec.classification_name
2968: ,piv.uom
2969: FROM hr_organization_information hoi
2970: ,pay_element_classifications pec
2971: ,pay_element_types_f pet
2972: ,pay_input_values_f piv
2973: WHERE hoi.organization_id = p_bus_grp_id

Line 3375: FROM hr_organization_information

3371: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
3372: SELECT org_information4 balance_type_id
3373: ,org_information5 balance_dim_id
3374: ,org_information7 narrative
3375: FROM hr_organization_information
3376: WHERE organization_id = p_bus_grp_id
3377: AND org_information_context = 'Business Group:Payslip Info'
3378: AND org_information1 = 'BALANCE';
3379: