APPS.HR_OFFER_CUSTOM dependencies on PER_ALL_ASSIGNMENTS_F

Line 120: ,per_all_assignments_f paf

116: select ppf.person_id
117: ,ppf.first_name||' '||ppf.last_name
118: ,ppf.applicant_number
119: from per_all_people_f ppf
120: ,per_all_assignments_f paf
121: where paf.assignment_id = p_candidate_assignment_id
122: and l_effective_date
123: between paf.effective_start_date
124: and paf.effective_end_date

Line 193: from per_all_assignments_f a

189: return per_all_people_f.person_id%type is
190: --
191: cursor csr_supervisor_id is
192: select a.supervisor_id
193: from per_all_assignments_f a
194: where a.person_id = p_person_id
195: and a.primary_flag = 'Y'
196: and a.assignment_type in ('E','C')
197: and trunc(sysdate)

Line 234: from per_all_assignments_f paf

230: --
231: cursor csr_pa(l_effective_date in date
232: ,l_in_person_id in per_people_f.person_id%type) is
233: select ppf.person_id
234: from per_all_assignments_f paf
235: ,per_all_people_f ppf
236: where paf.person_id = l_in_person_id
237: and paf.primary_flag = 'Y'
238: and l_effective_date

Line 407: from per_all_assignments_f paf

403: return varchar2 is
404: --
405: cursor csr_pa(l_effective_date in date) is
406: select paf.person_id
407: from per_all_assignments_f paf
408: start with paf.person_id = p_person_id
409: and paf.primary_flag = 'Y'
410: and l_effective_date
411: between paf.effective_start_date

Line 457: --So, we should get the hiring manager from per_all_assignments_f

453: --
454: --1754123 begin
455: --the creator may not be the hiring manager if the
456: --profile option HR_USE_HIRE_MGR_APPR_CHAIN is set to 'Y'.
457: --So, we should get the hiring manager from per_all_assignments_f
458:
459: --cursor csr_papa is
460: -- select distinct papa.person_id
461: -- from per_assign_proposal_answers papa

Line 466: from per_all_assignments_f asg

462: -- where papa.assignment_id = p_candidate_assignment_id;
463:
464: cursor csr_supervisor is
465: select asg.supervisor_id
466: from per_all_assignments_f asg
467: where asg.assignment_id = p_candidate_assignment_id;
468: --1754123 end
469:
470: --

Line 663: from per_all_assignments_f paf -- 10/17/97 Changed

659: cursor csr_paf is
660: select paf.effective_start_date
661: ,paf.effective_end_date
662: ,paf.object_version_number
663: from per_all_assignments_f paf -- 10/17/97 Changed
664: where paf.assignment_id = p_candidate_assignment_id
665: order by paf.effective_start_date;
666: --
667: begin