APPS.PAY_KW_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_information1 balance_type_id
184: ,org_information2 balance_dim_id
185: ,org_information3 narrative
186: FROM hr_organization_information
187: WHERE organization_id = p_bus_grp_id
188: AND org_information_context = 'KW_PAYSLIP_BALANCES';
189:
190:

Line 208: FROM hr_organization_information hoi

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

Line 941: FROM hr_organization_information

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

Line 948: FROM hr_organization_information

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

Line 984: l_currency hr_organization_information.org_information10%TYPE;

980: l_nationality per_all_people_f.nationality%TYPE;
981: l_position per_all_positions.name%TYPE;
982: l_grade per_grades.name%TYPE;
983: l_job per_jobs.name%TYPE;
984: l_currency hr_organization_information.org_information10%TYPE;
985: l_organization hr_organization_units.name%TYPE;
986: l_pay_location hr_locations_all.address_line_1%TYPE;
987: l_city VARCHAR2(80);
988: l_country VARCHAR2(80);

Line 998: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

994: l_ovn NUMBER;
995: l_person_id NUMBER;
996: l_bg_id NUMBER;
997: l_employer_name hr_organization_units.name%TYPE;
998: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
999: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1000: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1001: l_defined_balance_id NUMBER;
1002: l_balance_value NUMBER;

Line 1754: FROM hr_organization_information hoi

1750: ,hoi.org_information3 element_narrative
1751: ,pec.classification_name
1752: ,piv.uom
1753: ,piv.name input_value
1754: FROM hr_organization_information hoi
1755: ,pay_element_classifications pec
1756: ,pay_element_types_f pet
1757: ,pay_input_values_f piv
1758: WHERE hoi.organization_id = p_bus_grp_id

Line 1917: FROM hr_organization_information

1913: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
1914: SELECT org_information1 balance_type_id
1915: ,org_information2 balance_dim_id
1916: ,org_information3 narrative
1917: FROM hr_organization_information
1918: WHERE organization_id = p_bus_grp_id
1919: AND org_information_context = 'KW_PAYSLIP_BALANCES';
1920:
1921: /* Cursor to retrieve Tax Unit Id for setting context */