APPS.HR_PERSON_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 2329: FROM per_all_assignments_f

2325: WHERE cagr_grade_def_id = p_cagr_grade_def_id;
2326: l_cag_rec per_cagr_grades_def%ROWTYPE := NULL;
2327: CURSOR assignment_record_update IS
2328: SELECT *
2329: FROM per_all_assignments_f
2330: WHERE assignment_id = s_assignment_id
2331: AND apl_ass_start_date 2332: ORDER BY effective_start_date;
2333:

Line 2338: per_all_assignments_f asg

2334:
2335: cursor csr_old_asg_status(p_date date) is
2336: select ast.per_system_status,asg.assignment_status_type_id
2337: from per_assignment_status_types ast,
2338: per_all_assignments_f asg
2339: where ast.assignment_status_type_id = asg.assignment_status_type_id
2340: and asg.assignment_id = t_assignment_id
2341: and p_date between asg.effective_start_date and asg.effective_end_date;
2342:

Line 2663: from per_all_assignments_f

2659: if g_debug then
2660: hr_utility.set_location(l_proc, 3);
2661: end if;
2662: select max(effective_end_date) into l_max_eff_end_date
2663: from per_all_assignments_f
2664: where assignment_id=s_assignment_id;
2665: if l_max_eff_end_date <> to_date('31/12/4712','DD/MM/YYYY') then
2666:
2667: hr_assignment_api.terminate_apl_asg

Line 2695: FROM per_all_assignments_f

2691:
2692: CURSOR appl_assignments IS
2693: SELECT assignment_id,
2694: Min(effective_start_date) eff_start_date
2695: FROM per_all_assignments_f
2696: WHERE person_id = p_source_person_id
2697: GROUP BY assignment_id;
2698:
2699: CURSOR assign_record(c_apl_ass_start_date DATE,

Line 2702: FROM per_all_assignments_f

2698:
2699: CURSOR assign_record(c_apl_ass_start_date DATE,
2700: c_assignment_id NUMBER) IS
2701: SELECT *
2702: FROM per_all_assignments_f
2703: WHERE assignment_id = c_assignment_id
2704: AND c_apl_ass_start_date BETWEEN effective_start_date AND effective_end_date;
2705:
2706: CURSOR csr_sys_person_type(c_person_id NUMBER) IS

Line 2803: and not exists (select null from per_all_assignments_f paaf where paaf.person_id = ptuf.person_id)

2799: from per_person_type_usages_f ptuf, per_person_types ppt
2800: where ppt.system_person_type = 'IRC_REG_USER'
2801: and ptuf.person_type_id = ppt.person_type_id
2802: and ppt.business_group_id + 0 = nvl(l_bg_id,ppt.business_group_id)
2803: and not exists (select null from per_all_assignments_f paaf where paaf.person_id = ptuf.person_id)
2804: and not exists (select null from per_contact_relationships pcr where pcr.contact_person_id = ptuf.person_id)
2805: and ptuf.person_id=p_source_person_id;
2806: EXCEPTION
2807: WHEN OTHERS THEN

Line 2964: where exists(select 1 from per_all_assignments_f

2960:
2961: l_vac_exists:=0;
2962: BEGIN
2963: select 1 into l_vac_exists from dual
2964: where exists(select 1 from per_all_assignments_f
2965: where vacancy_id=l_per_assign_record.vacancy_id
2966: and person_id=p_target_person_id
2967: and assignment_type='A');
2968: EXCEPTION

Line 3216: and not exists (select null from per_all_assignments_f paaf where paaf.person_id = ptuf.person_id)

3212: from per_person_type_usages_f ptuf, per_person_types ppt
3213: where ppt.system_person_type = 'IRC_REG_USER'
3214: and ptuf.person_type_id = ppt.person_type_id
3215: and ppt.business_group_id + 0 = nvl(l_bg_id,ppt.business_group_id)
3216: and not exists (select null from per_all_assignments_f paaf where paaf.person_id = ptuf.person_id)
3217: and not exists (select null from per_contact_relationships pcr where pcr.contact_person_id = ptuf.person_id)
3218: and ptuf.person_id=p_target_person_id;
3219: EXCEPTION
3220: WHEN OTHERS THEN