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 926: FROM hr_organization_information

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

Line 933: FROM hr_organization_information

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

Line 990: l_currency hr_organization_information.org_information10%TYPE;

986: rec_org_address csr_organization_address%ROWTYPE;
987: l_nationality per_all_people_f.nationality%TYPE;
988: l_position per_all_positions.name%TYPE;
989: l_grade per_grades.name%TYPE;
990: l_currency hr_organization_information.org_information10%TYPE;
991: l_organization hr_organization_units.name%TYPE;
992: l_pay_location hr_locations_all.address_line_1%TYPE;
993: l_city VARCHAR2(80);
994: l_country VARCHAR2(80);

Line 1004: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

1000: l_ovn NUMBER;
1001: l_person_id NUMBER;
1002: l_bg_id NUMBER;
1003: l_employer_name hr_organization_units.name%TYPE;
1004: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1005: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1006: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1007: l_defined_balance_id NUMBER;
1008: l_balance_value NUMBER;

Line 1930: FROM hr_organization_information hoi

1926: ,hoi.org_information2 input_value_id
1927: ,hoi.org_information3 element_narrative
1928: ,pec.classification_name
1929: ,piv.uom
1930: FROM hr_organization_information hoi
1931: ,pay_element_classifications pec
1932: ,pay_element_types_f pet
1933: ,pay_input_values_f piv
1934: WHERE hoi.organization_id = p_bus_grp_id

Line 2094: FROM hr_organization_information

2090: CURSOR csr_get_balance(p_bus_grp_id NUMBER) IS
2091: SELECT org_information1 balance_type_id
2092: ,org_information2 balance_dim_id
2093: ,org_information3 narrative
2094: FROM hr_organization_information
2095: WHERE organization_id = p_bus_grp_id
2096: AND org_information_context = 'SA_PAYSLIP_BALANCES';
2097:
2098: /* Cursor to retrieve Tax Unit Id for setting context */