APPS.HR_PERSON_FLEX_LOGIC dependencies on PER_ALL_ASSIGNMENTS_F

Line 510: , per_all_assignments_f asg

506: , asg.effective_start_date
507: , asg.effective_end_date
508: , asg.organization_id
509: from per_assignment_status_types ast
510: , per_all_assignments_f asg
511: where asg.assignment_status_type_id = ast.assignment_status_type_id
512: and asg.assignment_id = p_assignment_id
513: and asg.effective_start_date <= p_period_end_date
514: order by asg.effective_start_date desc;

Line 519: , per_all_assignments_f asg

515: --
516: cursor hire_date_csr is
517: select per.start_date
518: from per_all_people_f per
519: , per_all_assignments_f asg
520: where asg.person_id = per.person_id
521: and p_period_end_date between per.effective_start_date and per.effective_end_date
522: and p_period_end_date between asg.effective_start_date and asg.effective_end_date
523: and asg.assignment_id = p_assignment_id;

Line 528: ,per_all_assignments_f asg

524: --
525: cursor term_date_csr is
526: select pos.actual_termination_date
527: from per_periods_of_service pos
528: ,per_all_assignments_f asg
529: where asg.period_of_service_id = pos.period_of_service_id
530: and p_period_start_date-1 between asg.effective_start_date
531: and asg.effective_end_date
532: and asg.assignment_id = p_assignment_id;

Line 537: ,per_all_assignments_f asg

533: --
534: cursor cwk_term_date_csr is
535: select pps.actual_termination_date
536: from per_periods_of_placement pps
537: ,per_all_assignments_f asg
538: where asg.person_id = pps.person_id
539: and asg.period_of_placement_date_start = pps.date_start
540: and p_period_start_date-1 between asg.effective_start_date
541: and asg.effective_end_date

Line 709: from per_all_assignments_f paf

705: from per_periods_of_service pos
706: where pos.date_start between add_months(p_report_date,-1) and p_report_date
707: and pos.period_of_service_id in (
708: select paf.period_of_service_id
709: from per_all_assignments_f paf
710: where paf.period_of_service_id = pos.period_of_service_id
711: and paf.organization_id = p_organization_id
712: and paf.assignment_id = p_assignment_id);
713:

Line 762: from per_all_assignments_f paf

758: from per_periods_of_service pos
759: where pos.date_start between p_cur_date_from and p_cur_date_to
760: and pos.period_of_service_id in (
761: select paf.period_of_service_id
762: from per_all_assignments_f paf
763: where paf.period_of_service_id = pos.period_of_service_id
764: and paf.organization_id = p_organization_id
765: and paf.assignment_id = p_assignment_id);
766:

Line 777: from per_all_assignments_f paf

773: select 'Y'
774: from per_periods_of_placement pps
775: where pps.date_start between p_cur_date_from and p_cur_date_to
776: and exists (select 1
777: from per_all_assignments_f paf
778: where paf.person_id = pps.person_id
779: and paf.period_of_placement_date_start = pps.date_start
780: and paf.organization_id = p_organization_id
781: and paf.assignment_id = p_assignment_id);