APPS.GHR_VALIDATE_PERWSDPO dependencies on PER_ASSIGNMENTS_F

Line 344: select count(*) into l_count from PER_ASSIGNMENTS_F assign

340: FUNCTION chk_location_assigned (p_location_id in number) RETURN BOOLEAN IS
341: l_chk_location_assigned boolean :=false;
342: l_count number;
343: begin
344: select count(*) into l_count from PER_ASSIGNMENTS_F assign
345: where assign.location_id=p_location_id and assign.primary_flag='Y'
346: and assign.assignment_type <> 'B';
347: if l_count>0 then
348: l_chk_location_assigned :=true;

Line 363: select count(*) into l_count from PER_ASSIGNMENTS_F assign

359: FUNCTION chk_position_assigned (p_position_id in number) RETURN BOOLEAN IS
360: l_chk_position_assigned boolean :=false;
361: l_count number;
362: begin
363: select count(*) into l_count from PER_ASSIGNMENTS_F assign
364: where assign.position_id=p_position_id and assign.assignment_type <> 'B';
365: if l_count>0 then
366: l_chk_position_assigned :=true;
367: else

Line 382: from PER_ASSIGNMENTS_F asg

378: ,p_date in date)
379: RETURN BOOLEAN IS
380: CURSOR c_asg IS
381: select 1
382: from PER_ASSIGNMENTS_F asg
383: where asg.position_id = p_position_id
384: and asg.assignment_type <> 'B'
385: and NVL(p_date,trunc(sysdate))
386: between asg.effective_start_date and asg.effective_end_date;

Line 405: from PER_ASSIGNMENTS_F asg

401: ,p_date in date)
402: RETURN BOOLEAN IS
403: CURSOR c_asg IS
404: select 1
405: from PER_ASSIGNMENTS_F asg
406: where asg.position_id = p_position_id
407: and asg.assignment_id <> p_assignment_id -- Exclude Current Assignment
408: and asg.assignment_type <> 'B'
409: and NVL(p_date,trunc(sysdate)) between asg.effective_start_date

Line 429: from PER_ASSIGNMENTS_F asg

425: ,p_date in date)
426: RETURN BOOLEAN IS
427: CURSOR c_asg IS
428: select 1
429: from PER_ASSIGNMENTS_F asg
430: where asg.position_id = p_position_id
431: and asg.assignment_type = 'C'
432: and NVL(p_date,trunc(sysdate)) between asg.effective_start_date
433: and asg.effective_end_date;

Line 569: from PER_ASSIGNMENTS_F asg

565: ,p_date in date)
566: RETURN BOOLEAN IS
567: CURSOR c_asg IS
568: select 1
569: from PER_ASSIGNMENTS_F asg
570: where asg.position_id = p_position_id
571: and asg.assignment_type <> 'B'
572: and asg.effective_start_date >= NVL(p_date,trunc(sysdate));
573: