DBA Data[Home] [Help]

APPS.PAY_US_SQWL_UDF dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 567: pay_us_emp_state_tax_rules_f pest,

563: p_quarter_end_date DATE) IS
564: select distinct pest.state_code,pus.state_abbrev
565: from per_all_assignments_f paaf,
566: hr_soft_coding_keyflex hsck,
567: pay_us_emp_state_tax_rules_f pest,
568: pay_us_states pus
569: where paaf.person_id = p_person_id
570: and paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
571: and paaf.effective_end_date >= p_year_start_date

Line 625: pay_us_emp_state_tax_rules_f pest,

621:
622: select distinct pest.state_code,pus.state_abbrev
623: from per_all_assignments_f paaf,
624: hr_soft_coding_keyflex hsck,
625: pay_us_emp_state_tax_rules_f pest,
626: pay_us_states pus
627: where paaf.person_id = p_person_id
628: and paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
629: and paaf.effective_end_date >= p_year_start_date