APPS.HR_US_FF_UDF1 dependencies on HR_ORGANIZATION_INFORMATION

Line 203: hr_organization_information hoi,

199: hr_utility.trace('BEGIN -> hr_us_ff_udf1.get_tax_jurisdiction ');
200: select nvl(hoi.org_information16,'N')
201: into l_return_value
202: from per_assignments_f paf,
203: hr_organization_information hoi,
204: hr_soft_coding_keyflex hsk
205: where paf.assignment_id = p_assignment_id
206: and p_date_earned between paf.effective_start_date
207: and paf.effective_end_date

Line 5082: FROM hr_organization_information hoi,

5078: --Threshold hours at state level
5079: CURSOR csr_state_rules(p_tax_unit_id IN NUMBER
5080: ,p_state_code IN VARCHAR2) IS
5081: SELECT NVL(org_information2,0)
5082: FROM hr_organization_information hoi,
5083: pay_us_states pus
5084: WHERE hoi.organization_id = p_tax_unit_id
5085: AND hoi.org_information_context = 'State Tax Rules 2'
5086: AND hoi.org_information1 = pus.state_abbrev

Line 5093: FROM hr_organization_information

5089: --Threshold hours at Local level
5090: CURSOR csr_local_rules(p_tax_unit_id IN NUMBER
5091: ,p_jurisdiction_code IN VARCHAR2) IS
5092: SELECT NVL(org_information4,0)
5093: FROM hr_organization_information
5094: WHERE organization_id = p_tax_unit_id
5095: AND org_information_context = 'Local Tax Rules'
5096: AND org_information1 = p_jurisdiction_code;
5097: