APPS.PA_MISC dependencies on PA_JOB_ASSIGNMENT_OVERRIDES

Line 67: FROM pa_job_assignment_overrides pjao

63: --- get the job_id from task level overrides
64:
65: SELECT job_id
66: INTO x_job_id
67: FROM pa_job_assignment_overrides pjao
68: WHERE x_person_id = pjao.person_id
69: AND x_task_id = pjao.task_id
70: AND x_effective_date BETWEEN pjao.start_date_active
71: AND pjao.end_date_active;

Line 87: FROM pa_job_assignment_overrides pjao

83: --- get the job_id from project level overrides
84:
85: SELECT job_id
86: INTO x_job_id
87: FROM pa_job_assignment_overrides pjao
88: WHERE x_person_id = pjao.person_id
89: AND x_project_id = pjao.project_id
90: AND x_effective_date BETWEEN pjao.start_date_active
91: AND pjao.end_date_active;