DBA Data[Home] [Help]

APPS.PAY_US_ITERATIVE_VALUES dependencies on PAY_US_STATES

Line 681: , pay_us_states ps

677: select ps.state_code
678: from hr_locations hrl
679: , hr_soft_coding_keyflex hrsckf
680: , per_all_assignments_f paf
681: , pay_us_states ps
682: where p_date_earned BETWEEN paf.effective_start_date
683: and paf.effective_end_date
684: and paf.assignment_id = p_assignment_id
685: and paf.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id