DBA Data[Home] [Help]

APPS.PER_US_ADD_LEG_HOOK dependencies on PER_ADDRESSES

Line 62: per_addresses padd

58:
59: cursor csr_emp_assign(p_address_id number) is
60: select asg.assignment_id
61: from per_assignments_f asg,
62: per_addresses padd
63: where asg.person_id = padd.person_id
64: and padd.address_id = p_address_id
65: and asg.assignment_type='E'
66: and asg.payroll_id is not null /*bug 10008870 */