DBA Data[Home] [Help]

APPS.PAY_RI_AC_TAX_RULE dependencies on PER_ALL_PEOPLE_F

Line 1034: per_all_people_f ppf

1030: /* cursor to get the assignment_id */
1031: CURSOR csr_get_asg_id is
1032: select paf.assignment_id
1033: from per_all_assignments_f paf,
1034: per_all_people_f ppf
1035: where ppf.full_name = p_employee
1036: and ppf.person_id = paf.person_id
1037: and ppf.business_group_id = p_business_group
1038: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date