DBA Data[Home] [Help]

APPS.PAY_KW_ANNUAL_REPORTS dependencies on PER_ALL_PEOPLE_F

Line 1646: FROM per_all_people_f paf

1642:
1643: /*Cursor for fetch the nationality for the employee Oct 2012 */
1644: CURSOR csr_get_nationality (l_person_id number,l_date date) IS
1645: SELECT paf.NATIONALITY
1646: FROM per_all_people_f paf
1647: WHERE person_id = l_person_id
1648: AND l_date between paf.effective_start_date and paf.effective_end_date;
1649:
1650: