APPS.HR_US_FF_UDF1 dependencies on PER_ASSIGNMENTS_F

Line 243: from per_assignments_f paf,

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

Line 373: per_assignments_f paf,

369: NVL(add_information20, postal_code)
370: )
371:
372: FROM per_addresses pad,
373: per_assignments_f paf,
374: pay_assignment_actions paa,
375: pay_payroll_actions ppa
376:
377: WHERE pad.primary_flag = 'Y'

Line 459: per_assignments_f paf,

455: NVL(add_information20, postal_code)
456: )
457: INTO l_home_juris
458: FROM per_addresses pad,
459: per_assignments_f paf,
460: fnd_sessions fs
461: WHERE pad.primary_flag = 'Y'
462: AND pad.person_id = paf.person_id
463: AND fs.effective_date BETWEEN pad.date_from

Line 5385: per_assignments_f paf

5381: pay_element_types_f pet,
5382: pay_input_values_f piv1,
5383: pay_input_values_f piv2,
5384: pay_element_type_extra_info extra,
5385: per_assignments_f paf
5386: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'
5387: AND extra.eei_information1 = 'Y'
5388: AND extra.element_type_id = pet.element_type_id
5389: AND pet.element_type_id = pel.element_type_id

Line 5711: per_assignments_f paf

5707: FROM pay_us_counties puc,
5708: pay_us_states pus,
5709: pay_us_city_names pucty,
5710: per_addresses pa,
5711: per_assignments_f paf
5712: WHERE paf.assignment_id = p_assignment_id
5713: AND paf.person_id = pa.person_id
5714: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date
5715: AND paf.primary_flag = 'Y'

Line 5736: per_assignments_f paf

5732: FROM pay_us_counties puc,
5733: pay_us_states pus,
5734: pay_us_city_names pucty,
5735: per_addresses pa,
5736: per_assignments_f paf
5737: WHERE paf.assignment_id = p_assignment_id
5738: AND paf.person_id = pa.person_id
5739: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date
5740: AND paf.primary_flag = 'Y'

Line 5799: per_assignments_f paf

5795: FROM pay_us_counties puc,
5796: pay_us_states pus,
5797: pay_us_city_names pucty,
5798: hr_locations hl,
5799: per_assignments_f paf
5800: WHERE paf.assignment_id = p_assignment_id
5801: AND TO_DATE('01-01-'||TO_CHAR(p_date_earned,'YYYY'), 'DD-MM-YYYY') BETWEEN
5802: paf.effective_start_date AND paf.effective_end_date
5803: AND paf.location_id = hl.location_id

Line 5822: per_assignments_f paf

5818: FROM pay_us_counties puc,
5819: pay_us_states pus,
5820: pay_us_city_names pucty,
5821: hr_locations hl,
5822: per_assignments_f paf
5823: WHERE paf.assignment_id = p_assignment_id
5824: AND TO_DATE('01-01-'||TO_CHAR(p_date_earned,'YYYY'), 'DD-MM-YYYY') BETWEEN
5825: paf.effective_start_date AND paf.effective_end_date
5826: AND paf.location_id = hl.location_id