APPS.PA_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 523: , per_all_assignments_f a -- Modified for bug 4699231

519: INTO
520: X_org_id
521: FROM
522: per_assignment_status_types s
523: , per_all_assignments_f a -- Modified for bug 4699231
524: WHERE
525: a.person_id = X_person_id
526: AND a.primary_flag = 'Y'
527: AND a.assignment_type in ('E', 'C')

Line 551: , per_all_assignments_f a -- Modified for bug 4699231

547: INTO
548: X_org_id
549: FROM
550: per_assignment_status_types s
551: , per_all_assignments_f a -- Modified for bug 4699231
552: WHERE
553: a.person_id = X_person_id
554: AND a.primary_flag = 'Y'
555: AND a.assignment_type in ('E', 'C')

Line 843: , per_all_assignments_f a -- Modified for bug 4699231

839: INTO
840: X_emp_job_id
841: FROM
842: per_assignment_status_types s
843: , per_all_assignments_f a -- Modified for bug 4699231
844: WHERE
845: a.job_id IS NOT NULL
846: AND a.primary_flag = 'Y'
847: AND X_date BETWEEN trunc( a.effective_start_date )

Line 871: , per_all_assignments_f a -- Modified for bug 4699231

867: INTO
868: X_emp_job_id
869: FROM
870: per_assignment_status_types s
871: , per_all_assignments_f a -- Modified for bug 4699231
872: WHERE
873: a.job_id IS NOT NULL
874: AND a.primary_flag = 'Y'
875: AND X_date BETWEEN trunc( a.effective_start_date )

Line 899: , per_all_assignments_f a -- for Bug 4699231

895: INTO
896: X_emp_job_id
897: FROM
898: per_assignment_status_types s
899: , per_all_assignments_f a -- for Bug 4699231
900: WHERE
901: a.job_id IS NOT NULL
902: AND a.primary_flag = 'Y'
903: AND X_date BETWEEN trunc( a.effective_start_date )

Line 929: , per_all_assignments_f a -- for Bug 4699231

925: INTO
926: X_emp_job_id
927: FROM
928: per_assignment_status_types s
929: , per_all_assignments_f a -- for Bug 4699231
930: WHERE
931: a.job_id IS NOT NULL
932: AND a.primary_flag = 'Y'
933: AND X_date BETWEEN trunc( a.effective_start_date )

Line 974: from per_all_assignments_f

970: BEGIN
971:
972: select location_id
973: into l_location_id
974: from per_all_assignments_f
975: where person_id = p_person_id
976: and p_ei_date between effective_start_date and effective_end_date
977: and primary_flag = 'Y';
978:

Line 1856: , per_all_assignments_f a -- modified for Bug 4699231

1852: X_emp_job_id,
1853: X_Emp_Org_Id
1854: FROM
1855: per_assignment_status_types s
1856: , per_all_assignments_f a -- modified for Bug 4699231
1857: , pa_implementations i
1858: WHERE
1859: a.job_id IS NOT NULL
1860: AND a.primary_flag = 'Y'

Line 1884: , per_all_assignments_f a -- modified for Bug 4699231

1880: X_emp_job_id,
1881: X_Emp_Org_Id
1882: FROM
1883: per_assignment_status_types s
1884: , per_all_assignments_f a -- modified for Bug 4699231
1885: , pa_implementations i
1886: WHERE
1887: a.job_id IS NOT NULL
1888: AND a.primary_flag = 'Y'

Line 2367: from per_all_assignments_f

2363:
2364:
2365: CURSOR get_exp_details IS
2366: SELECT distinct job_id JOB_ID
2367: from per_all_assignments_f
2368: where person_id = p_incurred_by_person_id
2369: and trunc(p_exp_item_date) between trunc(effective_start_date)
2370: and trunc(nvl(effective_end_date,p_exp_item_date));
2371: