APPS.PA_PROJECT_SEARCH_UTILS dependencies on PA_PARTY_RESOURCE_DETAILS_V

Line 103: FROM pa_party_resource_details_v

99: AND trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date);
100:
101: CURSOR p_ids IS
102: SELECT party_id
103: FROM pa_party_resource_details_v
104: WHERE party_name = p_resource_name
105: AND party_type = 'PERSON' -- Added for Bug 4745885
106: AND trunc(sysdate) between trunc(start_date)
107: and trunc(nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY')));