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';
302: IF p_resource_id IS NOT NULL AND p_resource_id<>FND_API.G_MISS_NUM THEN
303:
304: SELECT party_id
305: INTO x_resource_id
306: FROM pa_party_resource_details_v hz
307: WHERE hz.party_id = p_resource_id
308: AND trunc(p_date) between trunc(hz.start_date)
309: and trunc(nvl(hz.end_date, to_date('31-12-4712', 'DD-MM-YYYY')));
310:
311: ELSE
312: IF (p_resource_name IS NOT NULL) THEN
313: SELECT party_id
314: INTO x_resource_id
315: FROM pa_party_resource_details_v hz
316: WHERE hz.party_name = p_resource_name
317: AND trunc(p_date) between trunc(hz.start_date)
318: and trunc(nvl(hz.end_date, to_date('31-12-4712', 'DD-MM-YYYY')));
319: ELSE