APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_ROLE_TYPES_B

Line 8073: pa_project_role_types_b role,

8069:
8070: Select 1 INTO x_return_status from dual
8071: where exists (
8072: Select role.project_role_id from
8073: pa_project_role_types_b role,
8074: pa_project_assignments asm where
8075: asm.project_role_id = role.project_role_id and
8076: trunc(SYSDATE) Between trunc(role.start_date_active) and trunc(NVL(role.end_date_active,SYSDATE+1))
8077: and asm.assignment_id = p_assignment_id);