APPS.PAY_AE_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 149: FROM hr_organization_information

145: ----------------------------------------------------
146:
147: CURSOR csr_get_message(p_bus_grp_id NUMBER) IS
148: SELECT org_information6 message
149: FROM hr_organization_information
150: WHERE organization_id = p_bus_grp_id
151: AND org_information_context = 'Business Group:Payslip Info'
152: AND org_information1 = 'MESG';
153:

Line 186: FROM hr_organization_information

182: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
183: SELECT org_information4 balance_type_id
184: ,org_information5 balance_dim_id
185: ,org_information7 narrative
186: FROM hr_organization_information
187: WHERE organization_id = p_bus_grp_id
188: AND org_information_context = 'Business Group:Payslip Info'
189: AND org_information1 = 'BALANCE';
190:

Line 209: FROM hr_organization_information hoi

205: ,hoi.org_information3 input_value_id
206: ,hoi.org_information7 element_narrative
207: ,pec.classification_name
208: ,piv.uom
209: FROM hr_organization_information hoi
210: ,pay_element_classifications pec
211: ,pay_element_types_f pet
212: ,pay_input_values_f piv
213: WHERE hoi.organization_id = p_bus_grp_id

Line 944: FROM hr_organization_information

940:
941: /* Cursor to retrieve Currency */
942: CURSOR csr_currency(p_bg_id NUMBER) IS
943: SELECT org_information10
944: FROM hr_organization_information
945: WHERE organization_id = p_bg_id
946: AND org_information_context = 'Business Group Information';
947:
948: /* Cursor to retrieve Organization Structure Version Id */

Line 951: FROM hr_organization_information

947:
948: /* Cursor to retrieve Organization Structure Version Id */
949: CURSOR csr_org_structure(p_bg_id NUMBER) IS
950: SELECT org_information1
951: FROM hr_organization_information
952: WHERE organization_id = p_bg_id
953: AND org_information_context = 'AE_HR_BG_INFO';
954:
955: /* Cursor to retrieve Grade of Employee */

Line 995: l_currency hr_organization_information.org_information10%TYPE;

991: l_nationality VARCHAR2(80); --per_all_people_f.nationality%TYPE;
992: l_position per_all_positions.name%TYPE;
993: l_grade per_grades.name%TYPE;
994: l_job per_jobs.name%TYPE;
995: l_currency hr_organization_information.org_information10%TYPE;
996: l_organization hr_organization_units.name%TYPE;
997: l_pay_location hr_locations_all.address_line_1%TYPE;
998: l_city VARCHAR2(80);
999: l_country VARCHAR2(80);

Line 1009: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

1005: l_ovn NUMBER;
1006: l_person_id NUMBER;
1007: l_bg_id NUMBER;
1008: l_employer_name hr_organization_units.name%TYPE;
1009: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1010: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1011: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1012: l_defined_balance_id NUMBER;
1013: l_balance_value NUMBER;

Line 2017: FROM hr_organization_information hoi

2013: ,hoi.org_information7 element_narrative
2014: ,pec.classification_name
2015: ,piv.uom
2016: ,piv.name input_value
2017: FROM hr_organization_information hoi
2018: ,pay_element_classifications pec
2019: ,pay_element_types_f pet
2020: ,pay_input_values_f piv
2021: WHERE hoi.organization_id = p_bus_grp_id

Line 2179: FROM hr_organization_information

2175: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
2176: SELECT org_information4 balance_type_id
2177: ,org_information5 balance_dim_id
2178: ,org_information7 narrative
2179: FROM hr_organization_information
2180: WHERE organization_id = p_bus_grp_id
2181: AND org_information_context = 'Business Group:Payslip Info'
2182: AND org_information1 = 'BALANCE';
2183: