APPS.PAY_IP_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 195: ,hr_organization_information hoi

191: CURSOR c_get_employer_information(p_org_id IN NUMBER) IS
192: SELECT hou.name
193: ,hou.location_id
194: FROM hr_organization_units hou
195: ,hr_organization_information hoi
196: WHERE hou.organization_id = p_org_id
197: AND hoi.organization_id = hou.organization_id
198: AND hoi.org_information1 = 'HR_LEGAL';
199:

Line 204: ,hr_organization_information hoi

200: CURSOR c_get_org_info(cp_assignment_action_id IN NUMBER) IS
201: SELECT DISTINCT hou.name
202: ,hou.location_id
203: FROM hr_organization_units hou
204: ,hr_organization_information hoi
205: ,per_all_assignments_f paaf
206: ,pay_assignment_actions paa
207: WHERE paa.assignment_action_id = cp_assignment_action_id
208: AND paa.assignment_id = paaf.assignment_id

Line 249: hr_organization_information

245:
246: CURSOR c_get_userdefined_proc(cp_business_group_id IN NUMBER,
247: cp_legislation_code IN VARCHAR2) is
248: SELECT nvl(ORG_INFORMATION2,NULL) FROM
249: hr_organization_information
250: WHERE organization_id = cp_business_group_id
251: AND ORG_INFORMATION_CONTEXT = cp_legislation_code||'_REPORTING_PREFERENCES';
252:
253: CURSOR c_get_legislation_code (cp_business_group IN NUMBER) IS

Line 255: FROM hr_organization_information

251: AND ORG_INFORMATION_CONTEXT = cp_legislation_code||'_REPORTING_PREFERENCES';
252:
253: CURSOR c_get_legislation_code (cp_business_group IN NUMBER) IS
254: SELECT org_information9
255: FROM hr_organization_information
256: WHERE org_information_context = 'Business Group Information'
257: AND organization_id = cp_business_group;
258:
259: CURSOR c_get_employer_info(cp_payroll_action_id IN NUMBER) IS

Line 261: FROM hr_organization_information hoi, pay_payroll_actions ppa

257: AND organization_id = cp_business_group;
258:
259: CURSOR c_get_employer_info(cp_payroll_action_id IN NUMBER) IS
260: SELECT ppa.business_group_id, hoi.org_information9
261: FROM hr_organization_information hoi, pay_payroll_actions ppa
262: WHERE hoi.org_information_context = 'Business Group Information'
263: AND hoi.organization_id = ppa.business_group_id
264: AND ppa.payroll_action_id = cp_payroll_action_id;
265: