APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_RESOURCES_DENORM

Line 2223: pa_resources_denorm res

2219:
2220: CURSOR get_start_end_date IS
2221: SELECT asgn.start_date, asgn.end_date, asgn.project_id, res.person_id
2222: FROM pa_project_assignments asgn,
2223: pa_resources_denorm res
2224: WHERE assignment_id = p_assignment_id
2225: AND res.resource_id = asgn.resource_id
2226: AND rownum=1;
2227: