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

Line 132: FROM hr_organization_information

128: ,p_sql OUT NOCOPY VARCHAR2)
129: IS
130: CURSOR csr_get_message(p_bus_grp_id NUMBER) IS
131: SELECT org_information6 message
132: FROM hr_organization_information
133: WHERE organization_id = p_bus_grp_id
134: AND org_information_context = 'Business Group:Payslip Info'
135: AND org_information1 = 'MESG';
136: -----------------------------------------------------------------

Line 144: FROM hr_organization_information

140: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
141: SELECT org_information4 balance_type_id
142: ,org_information5 balance_dim_id
143: ,org_information7 narrative
144: FROM hr_organization_information
145: WHERE organization_id = p_bus_grp_id
146: AND org_information_context = 'Business Group:Payslip Info'
147: AND org_information1 = 'BALANCE';
148: /* Cursor to fetch defined balance id */

Line 186: FROM hr_organization_information hoi

182: ,code.org_information2||','||hoi.org_information7 element_narrative
183: ,pec.classification_name
184: ,piv.uom
185: --,code.org_information2 element_code
186: FROM hr_organization_information hoi
187: ,hr_organization_information code
188: ,pay_element_classifications pec
189: ,pay_element_types_f pet
190: ,pay_input_values_f piv

Line 187: ,hr_organization_information code

183: ,pec.classification_name
184: ,piv.uom
185: --,code.org_information2 element_code
186: FROM hr_organization_information hoi
187: ,hr_organization_information code
188: ,pay_element_classifications pec
189: ,pay_element_types_f pet
190: ,pay_input_values_f piv
191: WHERE hoi.organization_id = p_bus_grp_id

Line 787: FROM hr_organization_information

783: WHERE organization_id = p_organization_id;
784: /* Cursor to retrieve Currency */
785: CURSOR csr_currency(p_bg_id NUMBER) IS
786: SELECT org_information10
787: FROM hr_organization_information
788: WHERE organization_id = p_bg_id
789: AND org_information_context = 'Business Group Information';
790: l_bg_id NUMBER;
791: CURSOR csr_legal_employer (p_organization_id NUMBER) IS

Line 794: , HR_ORGANIZATION_INFORMATION hoi1

790: l_bg_id NUMBER;
791: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
792: SELECT hoi3.organization_id
793: FROM HR_ORGANIZATION_UNITS o1
794: , HR_ORGANIZATION_INFORMATION hoi1
795: , HR_ORGANIZATION_INFORMATION hoi2
796: , HR_ORGANIZATION_INFORMATION hoi3
797: WHERE o1.business_group_id =l_bg_id
798: AND hoi1.organization_id = o1.organization_id

Line 795: , HR_ORGANIZATION_INFORMATION hoi2

791: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
792: SELECT hoi3.organization_id
793: FROM HR_ORGANIZATION_UNITS o1
794: , HR_ORGANIZATION_INFORMATION hoi1
795: , HR_ORGANIZATION_INFORMATION hoi2
796: , HR_ORGANIZATION_INFORMATION hoi3
797: WHERE o1.business_group_id =l_bg_id
798: AND hoi1.organization_id = o1.organization_id
799: AND hoi1.organization_id = p_organization_id

Line 796: , HR_ORGANIZATION_INFORMATION hoi3

792: SELECT hoi3.organization_id
793: FROM HR_ORGANIZATION_UNITS o1
794: , HR_ORGANIZATION_INFORMATION hoi1
795: , HR_ORGANIZATION_INFORMATION hoi2
796: , HR_ORGANIZATION_INFORMATION hoi3
797: WHERE o1.business_group_id =l_bg_id
798: AND hoi1.organization_id = o1.organization_id
799: AND hoi1.organization_id = p_organization_id
800: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 857: l_currency hr_organization_information.org_information10%TYPE;

853: l_nationality per_all_people_f.nationality%TYPE;
854: l_position per_all_positions.name%TYPE;
855: l_hire_date per_periods_of_service.date_start%TYPE;
856: l_grade per_grades.name%TYPE;
857: l_currency hr_organization_information.org_information10%TYPE;
858: l_organization hr_organization_units.name%TYPE;
859: l_pay_location hr_locations_all.address_line_1%TYPE;
860: l_postal_code VARCHAR2(80);
861: l_country VARCHAR2(30);

Line 873: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

869: l_employer_name hr_organization_units.name%TYPE;
870: l_local_unit_id hr_organization_units.organization_id%TYPE;
871: l_legal_employer_id hr_organization_units.organization_id%TYPE;
872: l_job PER_JOBS.NAME%TYPE;
873: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
874: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
875: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
876: l_defined_balance_id NUMBER;
877: l_balance_value NUMBER;

Line 1144: ,hr_organization_information code

1140: FROM pay_element_types_f et
1141: , pay_element_types_f_tl pettl
1142: , pay_input_values_f iv
1143: , pay_element_classifications classification
1144: ,hr_organization_information code
1145: WHERE et.element_type_id = iv.element_type_id
1146: AND et.element_type_id = pettl.element_type_id
1147: AND pettl.language = USERENV('LANG')
1148: AND iv.name = 'Pay Value'

Line 1205: ,hr_organization_information code

1201: FROM pay_element_types_f et
1202: , pay_element_types_f_tl pettl
1203: , pay_input_values_f iv
1204: , pay_element_classifications classification
1205: ,hr_organization_information code
1206: WHERE et.element_type_id = iv.element_type_id
1207: AND et.element_type_id = pettl.element_type_id
1208: AND pettl.language = USERENV('LANG')
1209: AND iv.name = 'Pay Value'

Line 1599: FROM hr_organization_information hoi

1595: ,hoi.org_information3 input_value_id
1596: ,hoi.org_information7 element_narrative
1597: ,pec.classification_name
1598: ,piv.uom
1599: FROM hr_organization_information hoi
1600: ,pay_element_classifications pec
1601: ,pay_element_types_f pet
1602: ,pay_input_values_f piv
1603: WHERE hoi.organization_id = p_bus_grp_id

Line 1617: FROM hr_organization_information hoi

1613: ,hoi.org_information7 element_narrative
1614: ,pec.classification_name
1615: ,piv.uom
1616: ,code.org_information2 element_code
1617: FROM hr_organization_information hoi
1618: ,pay_element_classifications pec
1619: ,pay_element_types_f pet
1620: ,pay_input_values_f piv
1621: ,hr_organization_information code

Line 1621: ,hr_organization_information code

1617: FROM hr_organization_information hoi
1618: ,pay_element_classifications pec
1619: ,pay_element_types_f pet
1620: ,pay_input_values_f piv
1621: ,hr_organization_information code
1622: WHERE hoi.organization_id = p_bus_grp_id
1623: AND hoi.org_information_context = 'Business Group:Payslip Info'
1624: AND hoi.org_information1 = 'ELEMENT'
1625: AND hoi.org_information2 = pet.element_type_id

Line 1674: from hr_organization_information code

1670: -----------------------------------------------------------------------------
1671: -- Cursor to pick up segment from SE_SOE_ELEMENT_ADD_DETAILS context Org Developer DF
1672: CURSOR csr_group_by( p_ele_type_id NUMBER ) IS
1673: select ORG_INFORMATION3,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
1674: from hr_organization_information code
1675: where code.organization_id = g_business_group_id
1676: and code.org_information_context ='SE_SOE_ELEMENT_ADD_DETAILS'
1677: and code.org_information1 =p_ele_type_id;
1678:

Line 2257: FROM hr_organization_information

2253: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
2254: SELECT org_information4 balance_type_id
2255: ,org_information5 balance_dim_id
2256: ,org_information7 narrative
2257: FROM hr_organization_information
2258: WHERE organization_id = p_bus_grp_id
2259: AND org_information_context = 'Business Group:Payslip Info'
2260: AND org_information1 = 'BALANCE';
2261: /* Cursor to retrieve Tax Unit Id for setting context */

Line 2802: ,hr_organization_information code

2798: FROM pay_element_types_f et
2799: , pay_element_types_f_tl pettl
2800: , pay_input_values_f iv
2801: , pay_element_classifications classification
2802: ,hr_organization_information code
2803: WHERE et.element_type_id = iv.element_type_id
2804: AND et.element_type_id = pettl.element_type_id
2805: AND pettl.language = USERENV('LANG')
2806: AND iv.name = 'Pay Value'

Line 2865: ,hr_organization_information code

2861: FROM pay_element_types_f et
2862: , pay_element_types_f_tl pettl
2863: , pay_input_values_f iv
2864: , pay_element_classifications classification
2865: ,hr_organization_information code
2866: WHERE et.element_type_id = iv.element_type_id
2867: AND et.element_type_id = pettl.element_type_id
2868: AND pettl.language = USERENV('LANG')
2869: AND iv.name = 'Pay Value'

Line 2927: from hr_organization_information code

2923: -----------------------------------------------------------------------------
2924: -- Cursor to pick up segment from SE_SOE_ELEMENT_ADD_DETAILS context Org Developer DF
2925: CURSOR csr_group_by( p_ele_type_id NUMBER ) IS
2926: select ORG_INFORMATION3,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
2927: from hr_organization_information code
2928: where code.organization_id = g_business_group_id
2929: and code.org_information_context ='SE_SOE_ELEMENT_ADD_DETAILS'
2930: and code.org_information1 =p_ele_type_id;
2931: -----------------------------------------------------------------------------

Line 3790: , HR_ORGANIZATION_INFORMATION hoi1

3786:
3787: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS
3788: SELECT hoi3.organization_id
3789: FROM HR_ORGANIZATION_UNITS o1
3790: , HR_ORGANIZATION_INFORMATION hoi1
3791: , HR_ORGANIZATION_INFORMATION hoi2
3792: , HR_ORGANIZATION_INFORMATION hoi3
3793: WHERE o1.business_group_id =p_business_group_id
3794: AND hoi1.organization_id = o1.organization_id

Line 3791: , HR_ORGANIZATION_INFORMATION hoi2

3787: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS
3788: SELECT hoi3.organization_id
3789: FROM HR_ORGANIZATION_UNITS o1
3790: , HR_ORGANIZATION_INFORMATION hoi1
3791: , HR_ORGANIZATION_INFORMATION hoi2
3792: , HR_ORGANIZATION_INFORMATION hoi3
3793: WHERE o1.business_group_id =p_business_group_id
3794: AND hoi1.organization_id = o1.organization_id
3795: AND hoi1.organization_id = p_organization_id

Line 3792: , HR_ORGANIZATION_INFORMATION hoi3

3788: SELECT hoi3.organization_id
3789: FROM HR_ORGANIZATION_UNITS o1
3790: , HR_ORGANIZATION_INFORMATION hoi1
3791: , HR_ORGANIZATION_INFORMATION hoi2
3792: , HR_ORGANIZATION_INFORMATION hoi3
3793: WHERE o1.business_group_id =p_business_group_id
3794: AND hoi1.organization_id = o1.organization_id
3795: AND hoi1.organization_id = p_organization_id
3796: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'