APPS.GHR_VALIDATE_PERWSDPO dependencies on PER_ASSIGNMENTS_F

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

409: FUNCTION chk_location_assigned (p_location_id in number) RETURN BOOLEAN IS
410: l_chk_location_assigned boolean :=false;
411: l_count number;
412: begin
413: select count(*) into l_count from PER_ASSIGNMENTS_F assign
414: where assign.location_id=p_location_id and assign.primary_flag='Y'
415: and assign.assignment_type <> 'B';
416: if l_count>0 then
417: l_chk_location_assigned :=true;

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

428: FUNCTION chk_position_assigned (p_position_id in number) RETURN BOOLEAN IS
429: l_chk_position_assigned boolean :=false;
430: l_count number;
431: begin
432: select count(*) into l_count from PER_ASSIGNMENTS_F assign
433: where assign.position_id=p_position_id and assign.assignment_type <> 'B';
434: if l_count>0 then
435: l_chk_position_assigned :=true;
436: else

Line 451: from PER_ASSIGNMENTS_F asg

447: ,p_date in date)
448: RETURN BOOLEAN IS
449: CURSOR c_asg IS
450: select 1
451: from PER_ASSIGNMENTS_F asg
452: where asg.position_id = p_position_id
453: and asg.assignment_type <> 'B'
454: and NVL(p_date,trunc(sysdate))
455: between asg.effective_start_date and asg.effective_end_date;

Line 474: from PER_ASSIGNMENTS_F asg

470: ,p_date in date)
471: RETURN BOOLEAN IS
472: CURSOR c_asg IS
473: select 1
474: from PER_ASSIGNMENTS_F asg
475: where asg.position_id = p_position_id
476: and asg.assignment_id <> p_assignment_id -- Exclude Current Assignment
477: and asg.assignment_type <> 'B'
478: and NVL(p_date,trunc(sysdate)) between asg.effective_start_date

Line 498: from PER_ASSIGNMENTS_F asg

494: ,p_date in date)
495: RETURN BOOLEAN IS
496: CURSOR c_asg IS
497: select 1
498: from PER_ASSIGNMENTS_F asg
499: where asg.position_id = p_position_id
500: and asg.assignment_type = 'C'
501: and NVL(p_date,trunc(sysdate)) between asg.effective_start_date
502: and asg.effective_end_date;

Line 638: from PER_ASSIGNMENTS_F asg

634: ,p_date in date)
635: RETURN BOOLEAN IS
636: CURSOR c_asg IS
637: select 1
638: from PER_ASSIGNMENTS_F asg
639: where asg.position_id = p_position_id
640: and asg.assignment_type <> 'B'
641: and asg.effective_start_date >= NVL(p_date,trunc(sysdate));
642: