DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 3049: pay_us_emp_city_tax_rules_f pcty,

3045:
3046: cursor c_get_city is
3047: select distinct pcty.jurisdiction_code pcty
3048: from pay_us_city_tax_info_f cti,
3049: pay_us_emp_city_tax_rules_f pcty,
3050: per_all_assignments_f paf1
3051: where paf1.person_id = l_person_id
3052: and paf1.effective_end_date >= l_year_start
3053: and paf1.effective_start_date <= l_year_end

Line 3143: from pay_us_emp_city_tax_rules_f pcty,

3139: cursor c_get_cty_sd is
3140: select distinct pcty.state_code || '-'|| pcty.school_district_code,
3141: county_code,
3142: city_code
3143: from pay_us_emp_city_tax_rules_f pcty,
3144: per_all_assignments_f paf1
3145: where paf1.person_id = l_person_id
3146: and paf1.effective_end_date >= l_year_start
3147: and paf1.effective_start_date <= l_year_end