APPS.PAY_SA_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 143: FROM hr_organization_information

139: IS
140:
141: CURSOR csr_get_message(p_bus_grp_id NUMBER) IS
142: SELECT org_information6 message
143: FROM hr_organization_information
144: WHERE organization_id = p_bus_grp_id
145: AND org_information_context = 'Business Group:Payslip Info'
146: AND org_information1 = 'MESG';
147:

Line 156: FROM hr_organization_information

152: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
153: SELECT org_information1 balance_type_id
154: ,org_information2 balance_dim_id
155: ,org_information3 narrative
156: FROM hr_organization_information
157: WHERE organization_id = p_bus_grp_id
158: AND org_information_context = 'SA_PAYSLIP_BALANCES';
159:
160:

Line 201: FROM hr_organization_information hoi

197: ,hoi.org_information2 input_value_id
198: ,hoi.org_information3 element_narrative
199: ,pec.classification_name
200: ,piv.uom
201: FROM hr_organization_information hoi
202: ,pay_element_classifications pec
203: ,pay_element_types_f pet
204: ,pay_input_values_f piv
205: WHERE hoi.organization_id = p_bus_grp_id

Line 927: FROM hr_organization_information

923:
924: /* Cursor to retrieve Currency */
925: CURSOR csr_currency(p_bg_id NUMBER) IS
926: SELECT org_information10
927: FROM hr_organization_information
928: WHERE organization_id = p_bg_id
929: AND org_information_context = 'Business Group Information';
930:
931: /* Cursor to retrieve Organization Structure Version Id */

Line 934: FROM hr_organization_information

930:
931: /* Cursor to retrieve Organization Structure Version Id */
932: CURSOR csr_org_structure(p_bg_id NUMBER) IS
933: SELECT org_information1
934: FROM hr_organization_information
935: WHERE organization_id = p_bg_id
936: AND org_information_context = 'SA_HR_BG_INFO';
937:
938: /* Cursor to retrieve Grade of Employee */

Line 1003: l_currency hr_organization_information.org_information10%TYPE;

999: l_nationality per_all_people_f.nationality%TYPE;
1000: /*l_position per_all_positions.name%TYPE; */
1001: l_position hr_all_positions_f.name%TYPE; -- modified for bug 10255223
1002: l_grade per_grades.name%TYPE;
1003: l_currency hr_organization_information.org_information10%TYPE;
1004: l_organization hr_organization_units.name%TYPE;
1005: l_pay_location hr_locations_all.address_line_1%TYPE;
1006: l_city VARCHAR2(80);
1007: l_country VARCHAR2(80);

Line 1017: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

1013: l_ovn NUMBER;
1014: l_person_id NUMBER;
1015: l_bg_id NUMBER;
1016: l_employer_name hr_organization_units.name%TYPE;
1017: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1018: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1019: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1020: l_defined_balance_id NUMBER;
1021: l_balance_value NUMBER;

Line 2038: FROM hr_organization_information hoi

2034: ,hoi.org_information2 input_value_id
2035: ,hoi.org_information3 element_narrative
2036: ,pec.classification_name
2037: ,piv.uom
2038: FROM hr_organization_information hoi
2039: ,pay_element_classifications pec
2040: ,pay_element_types_f pet
2041: ,pay_input_values_f piv
2042: WHERE hoi.organization_id = p_bus_grp_id

Line 2202: FROM hr_organization_information

2198: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
2199: SELECT org_information1 balance_type_id
2200: ,org_information2 balance_dim_id
2201: ,org_information3 narrative
2202: FROM hr_organization_information
2203: WHERE organization_id = p_bus_grp_id
2204: AND org_information_context = 'SA_PAYSLIP_BALANCES';
2205:
2206: /* Cursor to retrieve Tax Unit Id for setting context */