APPS.PER_PEOPLE12_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 20: from per_all_assignments_f

16: FROM pay_payroll_actions pac,
17: pay_assignment_actions act
18: WHERE act.assignment_id =
19: (select assignment_id
20: from per_all_assignments_f
21: where person_id = p_person_id
22: and p_effective_date between
23: effective_start_date and effective_end_date
24: and primary_flag = 'Y'

Line 362: from per_all_assignments_f

358: and effective_start_date > p_hire_date;
359:
360: cursor csr_fut_asg_rec(p_application_id number) is
361: select assignment_id, effective_start_date, effective_end_date
362: from per_all_assignments_f
363: where person_id = p_person_id
364: and assignment_id <> p_new_primary_id
365: and application_id = p_application_id
366: and effective_start_date > greatest(p_hire_date,p_session_date)

Line 377: from per_all_assignments_f

373: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
374:
375: cursor get_apln_id is
376: select distinct application_id
377: from per_all_assignments_f
378: where person_id = p_person_id
379: and assignment_id = p_new_primary_id;
380:
381: --ER FPT

Line 977: from per_all_assignments_f

973: loop
974: l_fpt_hire_flag := 'Y';
975:
976: select max(effective_end_date) into l_apl_end_date
977: from per_all_assignments_f
978: where person_id = p_person_id
979: and assignment_id = apl.assignment_id
980: and assignment_type = 'A';
981:

Line 1026: update per_all_assignments_f

1022: end if;
1023: close chk_apl_exists;
1024:
1025: -- update the asgt with the application ID
1026: update per_all_assignments_f
1027: set application_id = l_cur_apl_id
1028: where person_id = p_person_id
1029: and assignment_id = apl.assignment_id
1030: and effective_start_date = apl.effective_start_date

Line 2647: FROM per_all_assignments_f

2643: l_apl_id number;
2644:
2645: cursor c_get_asg_apl_ids is
2646: SELECT assignment_id, application_id
2647: FROM per_all_assignments_f
2648: WHERE person_id = p_person_id
2649: AND primary_flag = 'Y'
2650: AND assignment_type = 'E'
2651: AND p_session_date BETWEEN effective_start_date AND effective_end_date;

Line 2662: select 'Y' from per_all_assignments_f

2658: l_chk_future_asg varchar2(1) := 'N';
2659: l_chk_future_pt varchar2(1) := 'N';
2660:
2661: cursor chk_future_asg is
2662: select 'Y' from per_all_assignments_f
2663: where person_id = p_person_id
2664: and effective_start_date >= p_hire_date
2665: and assignment_type = 'A';
2666: