APPS.HR_ENTRY_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 551: from per_all_assignments_f ASG

547: g_asg_info.assignment_id := p_assignment_id;
548:
549: select ASG.business_group_id
550: into g_asg_info.business_group_id
551: from per_all_assignments_f ASG
552: where ASG.assignment_id = p_assignment_id
553: and p_effective_date between
554: ASG.effective_start_date and ASG.effective_end_date;
555:

Line 7951: per_all_assignments_f asg

7947: --
7948: cursor csr_final_process_date (p_assignment_id number, p_session_date date) is
7949: select pos.final_process_date
7950: from per_periods_of_service pos,
7951: per_all_assignments_f asg
7952: where asg.assignment_id = p_assignment_id
7953: /* Added one more condition(PERIOD_OF_SERVICE_ID) for bug no: 6739960*/
7954: and pos.PERIOD_OF_SERVICE_ID=asg.PERIOD_OF_SERVICE_ID
7955: and asg.person_id = pos.person_id

Line 8074: from per_all_assignments_f paaf,per_assignment_status_types past

8070: end;
8071: --Bug 6809717
8072: --Added to stop deletion of non recurring element entries in case of assignment status change.
8073: select nvl(count(*),0) into l_assign_exist
8074: from per_all_assignments_f paaf,per_assignment_status_types past
8075: where paaf.ASSIGNMENT_ID=p_assignment_id
8076: and p_session_date+1 between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE
8077: and paaf.ASSIGNMENT_STATUS_TYPE_ID=past.ASSIGNMENT_STATUS_TYPE_ID
8078: and past.per_system_status='ACTIVE_ASSIGN';

Line 8082: from per_all_assignments_f

8078: and past.per_system_status='ACTIVE_ASSIGN';
8079:
8080: if l_assign_exist>0 then
8081: select nvl(count(*),0) into l_before_ovm
8082: from per_all_assignments_f
8083: where ASSIGNMENT_ID=p_assignment_id and
8084: p_session_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
8085:
8086: select nvl(count(*),0) into l_after_ovm

Line 8087: from per_all_assignments_f

8083: where ASSIGNMENT_ID=p_assignment_id and
8084: p_session_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
8085:
8086: select nvl(count(*),0) into l_after_ovm
8087: from per_all_assignments_f
8088: where ASSIGNMENT_ID=p_assignment_id and
8089: p_session_date+1 between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
8090:
8091: if l_before_ovm<>l_after_ovm then