[Home] [Help]
368: NVL(add_information18, town_or_city),
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:
454: NVL(add_information18, town_or_city),
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
1541: l_res_county,
1542: l_res_city,
1543: l_res_zip,
1544: l_wah
1545: FROM per_addresses ADDR
1546: ,per_all_assignments_f ASSIGN
1547: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1548: AND ASSIGN.effective_end_date
1549: and ASSIGN.assignment_id = l_assignment_id
2794: NVL(addr.add_information19,addr.region_1) county,
2795: NVL(addr.add_information18,addr.town_or_city) city,
2796: NVL(addr.add_information20,addr.postal_code) zip,
2797: NVL(assign.work_at_home,'N')
2798: FROM per_addresses addr
2799: ,per_all_assignments_f assign
2800: WHERE p_date_earned BETWEEN assign.effective_start_date
2801: AND assign.effective_end_date
2802: AND assign.assignment_id = p_assignment_id
5706: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
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
5731: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
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