DBA Data[Home] [Help]

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')