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_person_id number;
68: l_assignment_id number;
69: l_person_id_canonical varchar2(20);
70: l_assignment_id_canonical varchar2(20);

Line 88: --per_all_assignments_f%rowtype cursor.

84: where person_id = l_person_id
85: and trunc(effective_start_date) = l_start_date
86: and trunc(effective_end_date) = l_end_date;
87: --
88: --per_all_assignments_f%rowtype cursor.
89: --
90: cursor l_assignment_cur is
91: select *
92: from per_all_assignments_f

Line 92: from per_all_assignments_f

88: --per_all_assignments_f%rowtype cursor.
89: --
90: cursor l_assignment_cur is
91: select *
92: from per_all_assignments_f
93: where assignment_id = l_assignment_id
94: and trunc(effective_start_date) = l_start_date
95: and trunc(effective_end_date) = l_end_date;
96: --

Line 486: p_rec in per_all_assignments_f%rowtype,

482: --
483: --
484: --
485: procedure per_asg_wf(
486: p_rec in per_all_assignments_f%rowtype,
487: p_action in varchar2) is
488: --
489: -- local variables
490: --

Line 499: l_position_id per_all_assignments_f.position_id%TYPE;

495: l_person_id_canonical varchar2(20);
496: l_assignment_id_canonical varchar2(20);
497: l_parameters wf_parameter_list_t;
498: --
499: l_position_id per_all_assignments_f.position_id%TYPE;
500: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
501: l_max_date date;
502: l_start_date date;
503: l_end_date date;

Line 500: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

496: l_assignment_id_canonical varchar2(20);
497: l_parameters wf_parameter_list_t;
498: --
499: l_position_id per_all_assignments_f.position_id%TYPE;
500: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
501: l_max_date date;
502: l_start_date date;
503: l_end_date date;
504: --

Line 507: from per_all_assignments_f

503: l_end_date date;
504: --
505: cursor start_date is
506: select min(effective_start_date)
507: from per_all_assignments_f
508: where assignment_id = l_assignment_id
509: and position_id = l_position_id
510: and nvl(assignment_type,'Z') = 'E'
511: and nvl(primary_flag,'Z') = 'Y';