APPS.PER_FR_BIAF_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 64: per_all_assignments_f paf ,

60: from
61: hr_locations_all hla,
62: hr_all_organization_units hou,
63: hr_all_organization_units_tl hout,
64: per_all_assignments_f paf ,
65: per_all_people_f apf,
66: per_addresses pav,
67: hr_organization_information hoi,
68: per_contracts_f pcf,

Line 448: FROM per_all_assignments_f asg,

444: p_udt_column IN VARCHAR2
445: --p_include_suspended IN VARCHAR2
446: ) IS
447: SELECT COUNT(asg.assignment_id)
448: FROM per_all_assignments_f asg,
449: per_assignment_status_types ast,
450: -- per_person_types_v pt,
451: per_all_people_f peo
452: WHERE asg.establishment_id=p_est_id

Line 483: FROM per_all_assignments_f asg2,

479: AND p_effective_date <= peo.effective_end_date;
480: /*
481: AND (LEAST(asg.effective_end_date,peo.effective_end_date) > p_effective_date
482: OR EXISTS (SELECT null
483: FROM per_all_assignments_f asg2,
484: per_assignment_status_types ast2,
485: -- per_person_types_v pt2,
486: per_all_people_f peo2
487: WHERE asg2.establishment_id =p_est_id

Line 541: per_all_assignments_f paf,

537: cursor get_date(f_person_id number) is
538: select pcf.effective_start_date,
539: pcf.effective_end_date
540: from per_contracts_f pcf ,
541: per_all_assignments_f paf,
542: per_all_people_f ppf
543: where ppf.person_id=f_person_id
544: and paf.person_id=ppf.person_id
545: and paf.contract_id(+)=pcf.contract_id

Line 593: from per_all_assignments_f paf,

589: per_all_people_f apf where apf.person_id=lp_person_id;*/
590:
591: cursor c_asg_set1(l_asg_id number,l_bg_id number, p_effective_date date) is
592: select distinct paf.person_id ,l_asg_id ,pef.employee_number
593: from per_all_assignments_f paf,
594: hr_assignment_sets hs,
595: per_all_people_f pef
596: where hs.assignment_set_id=l_asg_id
597: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id

Line 610: from per_all_assignments_f paf,

606:
607:
608: cursor c_asg_set2(l_asg_id number,l_bg_id number, p_effective_date date) is
609: select distinct paf.person_id ,l_asg_id ,pef.employee_number
610: from per_all_assignments_f paf,
611: hr_assignment_sets hs,
612: per_all_people_f pef
613: where hs.assignment_set_id=l_asg_id
614: and hs.business_group_id=paf.business_group_id

Line 633: from per_all_assignments_f paf,hr_assignment_sets hs,per_all_people_f pef

629:
630: /*
631: UNION
632: select paf.person_id ,l_asg_id ,pef.employee_number
633: from per_all_assignments_f paf,hr_assignment_sets hs,per_all_people_f pef
634: where hs.assignment_set_id=l_asg_id
635: and hs.payroll_id is null
636: and hs.business_group_id=paf.business_group_id
637: and pef.person_id=paf.person_id