DBA Data[Home] [Help]

APPS.PA_UTILS2 dependencies on PER_ALL_ASSIGNMENTS_F

Line 5344: ,per_all_assignments_f a

5340: UPDATE pa_expenditures e
5341: SET person_type = (
5342: SELECT decode(a.assignment_type,'E','EMP','C','CWK')
5343: FROM per_assignment_status_types s
5344: ,per_all_assignments_f a
5345: WHERE a.job_id IS NOT NULL
5346: AND a.primary_flag = 'Y'
5347: AND rec.expenditure_ending_date BETWEEN trunc(a.effective_start_date)
5348: AND trunc(a.effective_end_date)

Line 5370: ,per_all_assignments_f a

5366: UPDATE pa_expenditures e
5367: SET person_type = (
5368: SELECT decode(a.assignment_type,'E','EMP','C','CWK')
5369: FROM per_assignment_status_types s
5370: ,per_all_assignments_f a
5371: WHERE a.job_id IS NOT NULL
5372: AND a.primary_flag = 'Y'
5373: AND rec1.expenditure_ending_date BETWEEN trunc(a.effective_start_date)
5374: AND trunc(a.effective_end_date)

Line 5396: ,per_all_assignments_f a

5392: UPDATE pa_expenditures e
5393: SET person_type = (
5394: SELECT decode(a.assignment_type,'E','EMP','C','CWK')
5395: FROM per_assignment_status_types s
5396: ,per_all_assignments_f a
5397: WHERE a.job_id IS NOT NULL
5398: AND a.primary_flag = 'Y'
5399: AND rec1.expenditure_ending_date BETWEEN trunc(a.effective_start_date)
5400: AND trunc(a.effective_end_date)