DBA Data[Home] [Help]

APPS.PAY_RI_AC_TAX_RULE dependencies on PER_ALL_PEOPLE_F

Line 1028: per_all_people_f ppf

1024: /* cursor to get the assignment_id */
1025: CURSOR csr_get_asg_id is
1026: select paf.assignment_id
1027: from per_all_assignments_f paf,
1028: per_all_people_f ppf
1029: where ppf.full_name = p_employee
1030: and ppf.person_id = paf.person_id
1031: and ppf.business_group_id = p_business_group
1032: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date