[Home] [Help]
327: NVL(add_information18, town_or_city),
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:
413: NVL(add_information18, town_or_city),
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
1500: l_res_county,
1501: l_res_city,
1502: l_res_zip,
1503: l_wah
1504: FROM per_addresses ADDR
1505: ,per_all_assignments_f ASSIGN
1506: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1507: AND ASSIGN.effective_end_date
1508: and ASSIGN.assignment_id = l_assignment_id
2695: NVL(addr.add_information19,addr.region_1) county,
2696: NVL(addr.add_information18,addr.town_or_city) city,
2697: NVL(addr.add_information20,addr.postal_code) zip,
2698: NVL(assign.work_at_home,'N')
2699: FROM per_addresses addr
2700: ,per_all_assignments_f assign
2701: WHERE p_date_earned BETWEEN assign.effective_start_date
2702: AND assign.effective_end_date
2703: AND assign.assignment_id = p_assignment_id
5519: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
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
5544: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
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