DBA Data[Home] [Help]

APPS.PAY_US_TAX_API dependencies on PAY_US_STATE_TAX_INFO_F

Line 479: pay_us_state_tax_info_f stif, pay_us_states pus,

475: paf.assignment_id,
476: stif.sta_information7,
477: hsck.segment1
478: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
479: pay_us_state_tax_info_f stif, pay_us_states pus,
480: hr_soft_coding_keyflex hsck
481: where paf.person_id = p_person_id
482: and paf.assignment_id = str.assignment_id
483: and paf.assignment_type = 'E'

Line 910: pay_us_state_tax_info_f stif

906: CURSOR c_excess_over_state_for_fed IS
907: select 'x'
908: from per_assignments_f paf,
909: pay_us_emp_state_tax_rules_f str,
910: pay_us_state_tax_info_f stif
911: where paf.person_id = p_person_id
912: and paf.assignment_type = 'E'
913: and str.assignment_id = paf.assignment_id
914: and stif.state_code = str.state_code

Line 953: pay_us_state_tax_info_f stif

949: CURSOR c_future_state_recs_for_fed IS
950: select 'x'
951: from per_assignments_f paf,
952: pay_us_emp_state_tax_rules_f str,
953: pay_us_state_tax_info_f stif
954: where paf.person_id = p_person_id
955: and str.assignment_id = paf.assignment_id
956: and paf.assignment_type = 'E'
957: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'