APPS.PER_HRWF_SYNCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 66: l_assignment_rec per_all_assignments_f%rowtype;

62: l_counter number;
63: l_proc varchar2(80) := g_package||'call_back';
64: l_entity varchar2(10);
65: l_person_rec per_all_people_f%rowtype;
66: l_assignment_rec per_all_assignments_f%rowtype;
67: l_pds_rec per_periods_of_service%rowtype;
68: l_person_id number;
69: l_assignment_id number;
70: l_person_id_canonical varchar2(20);

Line 96: --per_all_assignments_f%rowtype cursor.

92: from per_periods_of_service
93: where person_id = l_person_id
94: and trunc(date_start) = l_start_date
95: and trunc(actual_termination_date) = l_end_date;
96: --per_all_assignments_f%rowtype cursor.
97: --
98: cursor l_assignment_cur is
99: select *
100: from per_all_assignments_f

Line 100: from per_all_assignments_f

96: --per_all_assignments_f%rowtype cursor.
97: --
98: cursor l_assignment_cur is
99: select *
100: from per_all_assignments_f
101: where assignment_id = l_assignment_id
102: and trunc(effective_start_date) = l_start_date
103: and trunc(effective_end_date) = l_end_date;
104: --

Line 580: p_rec in per_all_assignments_f%rowtype,

576: --
577: --
578: --
579: procedure per_asg_wf(
580: p_rec in per_all_assignments_f%rowtype,
581: p_action in varchar2) is
582: --
583: -- local variables
584: --

Line 593: l_position_id per_all_assignments_f.position_id%TYPE;

589: l_person_id_canonical varchar2(20);
590: l_assignment_id_canonical varchar2(20);
591: l_parameters wf_parameter_list_t;
592: --
593: l_position_id per_all_assignments_f.position_id%TYPE;
594: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
595: l_max_date date;
596: l_start_date date;
597: l_end_date date;

Line 594: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

590: l_assignment_id_canonical varchar2(20);
591: l_parameters wf_parameter_list_t;
592: --
593: l_position_id per_all_assignments_f.position_id%TYPE;
594: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
595: l_max_date date;
596: l_start_date date;
597: l_end_date date;
598: --

Line 601: from per_all_assignments_f

597: l_end_date date;
598: --
599: cursor start_date is
600: select min(effective_start_date)
601: from per_all_assignments_f
602: where assignment_id = l_assignment_id
603: and position_id = l_position_id
604: and nvl(assignment_type,'Z') = 'E'
605: and nvl(primary_flag,'Z') = 'Y';

Line 1008: from per_all_assignments_f paaf

1004: l_proc varchar2(200) := 'per_hrwf_synch.synch_user_pos_role.';
1005: Cursor Csr_assignment_data (p_in_person_id in number,p_in_start_date in date,p_in_exp_date in date)
1006: is
1007: Select *
1008: from per_all_assignments_f paaf
1009: where paaf.person_id = p_in_person_id
1010: and trunc(effective_end_date) >= trunc(p_in_start_date)
1011: and trunc(effective_start_date) <= trunc(nvl(p_in_exp_date,effective_start_date))
1012: order by effective_start_date asc;

Line 1020: from per_all_assignments_f paaf

1016: hr_utility.set_location('Entering '||l_proc,10);
1017:
1018: select count(*)
1019: into l_fetch_rec_count
1020: from per_all_assignments_f paaf
1021: where paaf.person_id = p_in_person_id
1022: and trunc(effective_end_date) >= greatest(trunc(p_in_start_date),trunc(sysdate) )
1023: and trunc(effective_start_date) <= trunc(nvl(p_in_exp_date,effective_start_date))
1024: order by effective_start_date asc;