APPS.HR_US_FF_UDF1 dependencies on HR_ORGANIZATION_INFORMATION

Line 244: hr_organization_information hoi,

240: hr_utility.trace('BEGIN -> hr_us_ff_udf1.get_tax_jurisdiction ');
241: select nvl(hoi.org_information16,'N')
242: into l_return_value
243: from per_assignments_f paf,
244: hr_organization_information hoi,
245: hr_soft_coding_keyflex hsk
246: where paf.assignment_id = p_assignment_id
247: and p_date_earned between paf.effective_start_date
248: and paf.effective_end_date

Line 5269: FROM hr_organization_information hoi,

5265: --Threshold hours at state level
5266: CURSOR csr_state_rules(p_tax_unit_id IN NUMBER
5267: ,p_state_code IN VARCHAR2) IS
5268: SELECT NVL(org_information2,0)
5269: FROM hr_organization_information hoi,
5270: pay_us_states pus
5271: WHERE hoi.organization_id = p_tax_unit_id
5272: AND hoi.org_information_context = 'State Tax Rules 2'
5273: AND hoi.org_information1 = pus.state_abbrev

Line 5280: FROM hr_organization_information

5276: --Threshold hours at Local level
5277: CURSOR csr_local_rules(p_tax_unit_id IN NUMBER
5278: ,p_jurisdiction_code IN VARCHAR2) IS
5279: SELECT NVL(org_information4,0)
5280: FROM hr_organization_information
5281: WHERE organization_id = p_tax_unit_id
5282: AND org_information_context = 'Local Tax Rules'
5283: AND org_information1 = p_jurisdiction_code;
5284: