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 7967: per_all_assignments_f asg

7963: --
7964: cursor csr_final_process_date (p_assignment_id number, p_session_date date) is
7965: select pos.final_process_date
7966: from per_periods_of_service pos,
7967: per_all_assignments_f asg
7968: where asg.assignment_id = p_assignment_id
7969: /* Added one more condition(PERIOD_OF_SERVICE_ID) for bug no: 6739960*/
7970: and pos.PERIOD_OF_SERVICE_ID=asg.PERIOD_OF_SERVICE_ID
7971: and asg.person_id = pos.person_id

Line 8090: from per_all_assignments_f paaf,per_assignment_status_types past

8086: end;
8087: --Bug 6809717
8088: --Added to stop deletion of non recurring element entries in case of assignment status change.
8089: select nvl(count(*),0) into l_assign_exist
8090: from per_all_assignments_f paaf,per_assignment_status_types past
8091: where paaf.ASSIGNMENT_ID=p_assignment_id
8092: and p_session_date+1 between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE
8093: and paaf.ASSIGNMENT_STATUS_TYPE_ID=past.ASSIGNMENT_STATUS_TYPE_ID
8094: and past.per_system_status='ACTIVE_ASSIGN';

Line 8098: from per_all_assignments_f

8094: and past.per_system_status='ACTIVE_ASSIGN';
8095:
8096: if l_assign_exist>0 then
8097: select nvl(count(*),0) into l_before_ovm
8098: from per_all_assignments_f
8099: where ASSIGNMENT_ID=p_assignment_id and
8100: p_session_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
8101:
8102: select nvl(count(*),0) into l_after_ovm

Line 8103: from per_all_assignments_f

8099: where ASSIGNMENT_ID=p_assignment_id and
8100: p_session_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
8101:
8102: select nvl(count(*),0) into l_after_ovm
8103: from per_all_assignments_f
8104: where ASSIGNMENT_ID=p_assignment_id and
8105: p_session_date+1 between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
8106:
8107: if l_before_ovm<>l_after_ovm then

Line 8526: from per_all_assignments_f ASG

8522: --
8523: -- Bug 9013257, gets minimum assignment effective_start_date
8524: select min(ASG.effective_start_date)
8525: into l_session_date_cur
8526: from per_all_assignments_f ASG
8527: where ASG.assignment_id = l_assignment_id_o;
8528: --
8529: -- Bug 9013257, use min(effective_start_date) as the session_date
8530: -- if it is later than session_date and ZAP mode