DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on PAY_US_STATES

Line 3235: pay_us_states pus

3231: from pay_element_entries_f pee,
3232: per_all_assignments_f paf,
3233: per_all_people_f ppf,
3234: per_addresses pa,
3235: pay_us_states pus
3236: where pee.element_entry_id = p_element_entry_id
3237: and pee.assignment_id = paf.assignment_id
3238: and paf.person_id = ppf.person_id
3239: and ppf.person_id = pa.person_id

Line 3248: pay_us_states pus

3244: select filing_status_code
3245: from pay_us_emp_state_tax_rules_f pestr,
3246: per_all_assignments_f paf,
3247: hr_locations hl,
3248: pay_us_states pus
3249: where pestr.assignment_id = p_assignment_id
3250: and pestr.assignment_id = paf.assignment_id
3251: and paf.location_id = hl.location_id
3252: and pus.state_abbrev = nvl(loc_information17,region_2) ;