APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PER_ALL_ASSIGNMENTS_F
Line 69: FROM per_all_assignments_f assn
65:
66: END IF;
67:
68: select job_id INTO x_job_id 69: FROM per_all_assignments_f assn 70: WHERE assn.person_id = l_person_id
71: AND p_planning_start_date BETWEEN assn.effective_start_date
72: AND assn.effective_end_date
73: AND assn.assignment_type in ('C','E')