DBA Data[Home] [Help]

APPS.PAY_NO_HIGH_RATE_TAX dependencies on PER_ALL_PEOPLE_F

Line 775: FROM per_all_people_f

771:
772: -- cursor to get employee full name and employee number
773: CURSOR get_person_details (l_person_id number,l_date_earned date) is
774: SELECT full_name , employee_number
775: FROM per_all_people_f
776: WHERE person_id = l_person_id
777: AND l_date_earned between effective_start_date and effective_end_date ;
778:
779: -- cursor to check if element TAX CARD exists on the primary assignment of the employee