DBA Data[Home] [Help]

APPS.PAY_NO_HIGH_RATE_TAX dependencies on PER_ALL_PEOPLE_F

Line 753: FROM per_all_people_f

749:
750: -- cursor to get employee full name and employee number
751: CURSOR get_person_details (l_person_id number,l_date_earned date) is
752: SELECT full_name , employee_number
753: FROM per_all_people_f
754: WHERE person_id = l_person_id
755: AND l_date_earned between effective_start_date and effective_end_date ;
756:
757: -- cursor to check if element TAX CARD exists on the primary assignment of the employee