APPS.HR_MISC_WEB dependencies on PER_ALL_ASSIGNMENTS_F

Line 518: per_all_assignments_f paf

514: paf.location_id,
515: paf.primary_flag,
516: paf.object_version_number
517: FROM per_all_people_f ppf,
518: per_all_assignments_f paf
519: WHERE paf.assignment_id = p_assignment_id
520: AND paf.person_id = ppf.person_id
521: AND p_effective_date BETWEEN paf.effective_start_date
522: AND NVL(paf.effective_end_date, TRUNC(SYSDATE))

Line 548: per_all_assignments_f paf

544: ) IS
545: SELECT ppf.person_id,
546: ppf.full_name
547: FROM per_all_people_f ppf,
548: per_all_assignments_f paf
549: WHERE paf.assignment_id = p_assignment_id
550: AND paf.supervisor_id = ppf.person_id
551: -- AND paf.primary_flag = 'Y' -- To supprot multiple assignments
552: AND p_effective_date BETWEEN paf.effective_start_date

Line 569: per_all_assignments_f paf

565: ) IS
566: SELECT pj.job_id,
567: pj.name
568: FROM per_jobs_vl pj,
569: per_all_assignments_f paf
570: WHERE paf.assignment_id = p_assignment_id
571: AND paf.job_id = pj.job_id
572: -- AND paf.primary_flag = 'Y' -- To supprot multiple assignments
573: AND paf.business_group_id+0 = pj.business_group_id+0

Line 589: per_all_assignments_f paf

585: ) IS
586: SELECT hl.location_id,
587: hl.location_code
588: FROM hr_locations hl,
589: per_all_assignments_f paf
590: WHERE paf.assignment_id = p_assignment_id
591: AND paf.location_id = hl.location_id
592: -- AND paf.primary_flag = 'Y' -- To supprot multiple assignments
593: AND p_effective_date BETWEEN paf.effective_start_date

Line 608: per_all_assignments_f paf

604: ) IS
605: SELECT hou.organization_id,
606: hou.name
607: FROM hr_organization_units hou,
608: per_all_assignments_f paf
609: WHERE paf.assignment_id = p_assignment_id
610: AND paf.organization_id = hou.organization_id
611: -- AND paf.primary_flag = 'Y' -- To supprot multiple assignments
612: AND paf.business_group_id+0 = hou.business_group_id+0

Line 707: FROM per_all_assignments_f paf

703: --
704: CURSOR lc_get_assignment (p_person_id IN per_people_f.person_id%TYPE)
705: IS
706: SELECT paf.assignment_id, paf.effective_start_date
707: FROM per_all_assignments_f paf
708: WHERE paf.person_id = p_person_id
709: AND paf.primary_flag = 'Y'
710: -- Fix for bug 2268056
711: AND paf.assignment_type in ('E','C')

Line 813: per_all_assignments_f asg

809: CURSOR lc_hire_date
810: IS
811: SELECT MIN(pps.date_start)
812: FROM per_periods_of_service pps,
813: per_all_assignments_f asg
814: WHERE asg.assignment_id = p_assignment_id
815: AND asg.person_id = pps.person_id;
816:
817: -- Termination date

Line 827: --FROM per_all_assignments_f asg,

823: --
824: --CURSOR lc_termination_date
825: --IS
826: --SELECT MAX(asg.effective_start_date)
827: --FROM per_all_assignments_f asg,
828: -- per_assignment_status_types ast
829: --WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
830: --AND asg.assignment_id = p_assignment_id
831: --AND per_system_status = 'TERM_ASSIGN';

Line 836: per_all_assignments_f ass

832:
833: CURSOR lc_termination_date IS
834: select ser.actual_termination_date
835: from per_periods_of_service ser,
836: per_all_assignments_f ass
837: where ass.period_of_service_id = ser.period_of_service_id
838: AND TRUNC(SYSDATE) between ass.effective_start_date
839: AND ass.effective_end_date
840: AND ass.assignment_id = p_assignment_id;

Line 851: FROM per_all_assignments_f

847: --
848: CURSOR lc_future_assg_date
849: IS
850: SELECT MAX(effective_start_date)
851: FROM per_all_assignments_f
852: WHERE assignment_id = p_assignment_id
853: AND effective_start_date > p_effective_date;
854:
855: ld_hire_date DATE;

Line 1054: FROM per_all_assignments_f paf

1050: SELECT pbg.legislation_code
1051: FROM per_business_groups pbg
1052: WHERE pbg.business_group_id IN
1053: (SELECT paf.business_group_id
1054: FROM per_all_assignments_f paf
1055: WHERE paf.assignment_id = p_assignment_id
1056: AND TRUNC(p_effective_date) BETWEEN paf.effective_start_date
1057: AND NVL(paf.effective_end_date, TRUNC(SYSDATE)));
1058:

Line 1085: FROM per_all_assignments_f paf

1081:
1082:
1083: CURSOR csr_asg_leg_code is
1084: SELECT org.org_information9 legislation_code
1085: FROM per_all_assignments_f paf
1086: ,hr_organization_information org
1087: WHERE org.organization_id = paf.business_group_id
1088: AND org.org_information_context = 'Business Group Information'
1089: AND paf.assignment_id = p_assignment_id