APPS.PA_RESOURCE_UTILS dependencies on PA_PARTY_RESOURCE_DETAILS_V

Line 26: FROM pa_party_resource_details_v

22: and rownum=1;
23:
24: CURSOR external IS
25: SELECT 'Y'
26: FROM pa_party_resource_details_v
27: WHERE party_name = p_resource_name
28: and rownum=1;
29:
30: l_internal VARCHAR2(1) := 'N';

Line 307: FROM pa_party_resource_details_v hz

303: IF p_resource_id IS NOT NULL AND p_resource_id<>FND_API.G_MISS_NUM THEN
304:
305: SELECT party_id
306: INTO x_resource_id
307: FROM pa_party_resource_details_v hz
308: WHERE hz.party_id = p_resource_id
309: AND trunc(p_date) between trunc(hz.start_date)
310: and trunc(nvl(hz.end_date, to_date('31-12-4712', 'DD-MM-YYYY')));
311:

Line 316: FROM pa_party_resource_details_v hz

312: ELSE
313: IF (p_resource_name IS NOT NULL) THEN
314: SELECT party_id
315: INTO x_resource_id
316: FROM pa_party_resource_details_v hz
317: WHERE hz.party_name = p_resource_name
318: AND trunc(p_date) between trunc(hz.start_date)
319: and trunc(nvl(hz.end_date, to_date('31-12-4712', 'DD-MM-YYYY')));
320: ELSE