APPS.HR_TERMINATION_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 236: ,per_all_assignments_f paf

232: ----------------------------------------------------------------------------
233: CURSOR csr_get_subordinate IS
234: SELECT ppf.person_id
235: FROM per_all_people_f ppf -- Bug 2130066 fix
236: ,per_all_assignments_f paf
237: ,per_periods_of_service ppos
238: WHERE paf.supervisor_id = l_number_value
239: AND paf.person_id = ppf.person_id
240: AND ppf.person_id = ppos.person_id

Line 256: ,per_all_assignments_f paf

252: OR dummy = 'Y')
253: UNION -- CWK Phase III Changes.
254: SELECT ppf.person_id
255: FROM per_all_people_f ppf -- Bug 2130066 fix
256: ,per_all_assignments_f paf
257: ,per_periods_of_placement ppop
258: WHERE paf.supervisor_id = l_number_value
259: AND paf.person_id = ppf.person_id
260: AND ppf.person_id = ppop.person_id

Line 316: select primary_flag into dummy from per_all_assignments_f

312: itemtype => itemtype,
313: itemkey => itemkey,
314: aname => 'CURRENT_ASSIGNMENT_ID');
315:
316: select primary_flag into dummy from per_all_assignments_f
317: where assignment_id=l_asg_number_value and l_effective_date between effective_start_date
318: and effective_end_date;
319:
320: l_term_sec_asg := wf_engine.getitemattrtext(itemtype, itemkey,

Line 3122: per_all_assignments_f paf ,

3118: pos2.name SUPERVISOR_POSITION_NAME,
3119: org2.name SUPERVISOR_ORGANIZATION
3120: FROM per_all_people_f ppf, -- Changed to use base table, see bug 2130066
3121: per_all_people_f ppf2 ,
3122: per_all_assignments_f paf ,
3123: per_all_assignments_f paf2 ,
3124: per_jobs_vl jbs ,
3125: hr_all_positions_f_tl pos ,
3126: per_grades_vl pg ,

Line 3123: per_all_assignments_f paf2 ,

3119: org2.name SUPERVISOR_ORGANIZATION
3120: FROM per_all_people_f ppf, -- Changed to use base table, see bug 2130066
3121: per_all_people_f ppf2 ,
3122: per_all_assignments_f paf ,
3123: per_all_assignments_f paf2 ,
3124: per_jobs_vl jbs ,
3125: hr_all_positions_f_tl pos ,
3126: per_grades_vl pg ,
3127: hr_all_organization_units_tl org ,

Line 3181: FROM per_all_assignments_f

3177: CURSOR lc_object_version_no(cp_assignment_id number
3178: ,cp_effective_date date) IS
3179: SELECT object_version_number,
3180: assignment_type
3181: FROM per_all_assignments_f
3182: WHERE assignment_id = cp_assignment_id
3183: AND (cp_effective_date BETWEEN
3184: NVL ( effective_start_date , cp_effective_date)
3185: AND NVL ( effective_end_date , cp_effective_date )) ;

Line 3216: ln_assignment_type per_all_assignments_f.assignment_type%type;

3212: lv_param_15 varchar2(200);
3213: l_validate boolean;
3214:
3215: ln_object_version_no NUMBER ;
3216: ln_assignment_type per_all_assignments_f.assignment_type%type;
3217: ln_comment_id NUMBER ;
3218: ld_effective_start_date DATE;
3219: ld_effective_end_date DATE;
3220: lb_no_managers_warning BOOLEAN ;