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 1142: ,hr_organization_information code

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

Line 1203: ,hr_organization_information code

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

Line 1597: FROM hr_organization_information hoi

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

Line 1615: FROM hr_organization_information hoi

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

Line 1619: ,hr_organization_information code

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

Line 1672: from hr_organization_information code

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

Line 2245: FROM hr_organization_information

2241: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
2242: SELECT org_information4 balance_type_id
2243: ,org_information5 balance_dim_id
2244: ,org_information7 narrative
2245: FROM hr_organization_information
2246: WHERE organization_id = p_bus_grp_id
2247: AND org_information_context = 'Business Group:Payslip Info'
2248: AND org_information1 = 'BALANCE';
2249: /* Cursor to retrieve Tax Unit Id for setting context */

Line 2790: ,hr_organization_information code

2786: FROM pay_element_types_f et
2787: , pay_element_types_f_tl pettl
2788: , pay_input_values_f iv
2789: , pay_element_classifications classification
2790: ,hr_organization_information code
2791: WHERE et.element_type_id = iv.element_type_id
2792: AND et.element_type_id = pettl.element_type_id
2793: AND pettl.language = USERENV('LANG')
2794: AND iv.name = 'Pay Value'

Line 2853: ,hr_organization_information code

2849: FROM pay_element_types_f et
2850: , pay_element_types_f_tl pettl
2851: , pay_input_values_f iv
2852: , pay_element_classifications classification
2853: ,hr_organization_information code
2854: WHERE et.element_type_id = iv.element_type_id
2855: AND et.element_type_id = pettl.element_type_id
2856: AND pettl.language = USERENV('LANG')
2857: AND iv.name = 'Pay Value'

Line 2915: from hr_organization_information code

2911: -----------------------------------------------------------------------------
2912: -- Cursor to pick up segment from SE_SOE_ELEMENT_ADD_DETAILS context Org Developer DF
2913: CURSOR csr_group_by( p_ele_type_id NUMBER ) IS
2914: select ORG_INFORMATION3,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
2915: from hr_organization_information code
2916: where code.organization_id = g_business_group_id
2917: and code.org_information_context ='SE_SOE_ELEMENT_ADD_DETAILS'
2918: and code.org_information1 =p_ele_type_id;
2919: -----------------------------------------------------------------------------

Line 3765: , HR_ORGANIZATION_INFORMATION hoi1

3761:
3762: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS
3763: SELECT hoi3.organization_id
3764: FROM HR_ORGANIZATION_UNITS o1
3765: , HR_ORGANIZATION_INFORMATION hoi1
3766: , HR_ORGANIZATION_INFORMATION hoi2
3767: , HR_ORGANIZATION_INFORMATION hoi3
3768: WHERE o1.business_group_id =p_business_group_id
3769: AND hoi1.organization_id = o1.organization_id

Line 3766: , HR_ORGANIZATION_INFORMATION hoi2

3762: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS
3763: SELECT hoi3.organization_id
3764: FROM HR_ORGANIZATION_UNITS o1
3765: , HR_ORGANIZATION_INFORMATION hoi1
3766: , HR_ORGANIZATION_INFORMATION hoi2
3767: , HR_ORGANIZATION_INFORMATION hoi3
3768: WHERE o1.business_group_id =p_business_group_id
3769: AND hoi1.organization_id = o1.organization_id
3770: AND hoi1.organization_id = p_organization_id

Line 3767: , HR_ORGANIZATION_INFORMATION hoi3

3763: SELECT hoi3.organization_id
3764: FROM HR_ORGANIZATION_UNITS o1
3765: , HR_ORGANIZATION_INFORMATION hoi1
3766: , HR_ORGANIZATION_INFORMATION hoi2
3767: , HR_ORGANIZATION_INFORMATION hoi3
3768: WHERE o1.business_group_id =p_business_group_id
3769: AND hoi1.organization_id = o1.organization_id
3770: AND hoi1.organization_id = p_organization_id
3771: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'