APPS.HR_US_FF_UDF1 dependencies on PER_ASSIGNMENTS_F

Line 202: from per_assignments_f paf,

198: BEGIN
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

Line 332: per_assignments_f paf,

328: NVL(add_information20, postal_code)
329: )
330:
331: FROM per_addresses pad,
332: per_assignments_f paf,
333: pay_assignment_actions paa,
334: pay_payroll_actions ppa
335:
336: WHERE pad.primary_flag = 'Y'

Line 418: per_assignments_f paf,

414: NVL(add_information20, postal_code)
415: )
416: INTO l_home_juris
417: FROM per_addresses pad,
418: per_assignments_f paf,
419: fnd_sessions fs
420: WHERE pad.primary_flag = 'Y'
421: AND pad.person_id = paf.person_id
422: AND fs.effective_date BETWEEN pad.date_from

Line 5198: per_assignments_f paf

5194: pay_element_types_f pet,
5195: pay_input_values_f piv1,
5196: pay_input_values_f piv2,
5197: pay_element_type_extra_info extra,
5198: per_assignments_f paf
5199: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'
5200: AND extra.eei_information1 = 'Y'
5201: AND extra.element_type_id = pet.element_type_id
5202: AND pet.element_type_id = pel.element_type_id

Line 5524: per_assignments_f paf

5520: FROM pay_us_counties puc,
5521: pay_us_states pus,
5522: pay_us_city_names pucty,
5523: per_addresses pa,
5524: per_assignments_f paf
5525: WHERE paf.assignment_id = p_assignment_id
5526: AND paf.person_id = pa.person_id
5527: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date
5528: AND paf.primary_flag = 'Y'

Line 5549: per_assignments_f paf

5545: FROM pay_us_counties puc,
5546: pay_us_states pus,
5547: pay_us_city_names pucty,
5548: per_addresses pa,
5549: per_assignments_f paf
5550: WHERE paf.assignment_id = p_assignment_id
5551: AND paf.person_id = pa.person_id
5552: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date
5553: AND paf.primary_flag = 'Y'

Line 5612: per_assignments_f paf

5608: FROM pay_us_counties puc,
5609: pay_us_states pus,
5610: pay_us_city_names pucty,
5611: hr_locations hl,
5612: per_assignments_f paf
5613: WHERE paf.assignment_id = p_assignment_id
5614: AND TO_DATE('01-01-'||TO_CHAR(p_date_earned,'YYYY'), 'DD-MM-YYYY') BETWEEN
5615: paf.effective_start_date AND paf.effective_end_date
5616: AND paf.location_id = hl.location_id

Line 5635: per_assignments_f paf

5631: FROM pay_us_counties puc,
5632: pay_us_states pus,
5633: pay_us_city_names pucty,
5634: hr_locations hl,
5635: per_assignments_f paf
5636: WHERE paf.assignment_id = p_assignment_id
5637: AND TO_DATE('01-01-'||TO_CHAR(p_date_earned,'YYYY'), 'DD-MM-YYYY') BETWEEN
5638: paf.effective_start_date AND paf.effective_end_date
5639: AND paf.location_id = hl.location_id