APPS.PER_ASSIGNMENTS_F1_PKG dependencies on PER_PERIODS_OF_PLACEMENT
Line 86: FROM per_periods_of_placement pdp
82: FROM per_periods_of_service
83: WHERE period_of_service_id = p_pd_os_id
84: UNION
85: SELECT NVL(pdp.final_process_date, p_eot) 86: FROM per_periods_of_placement pdp 87: WHERE pdp.person_id = l_person_id
88: AND pdp.date_start = l_pdp_date_start;
89:
90: BEGIN