APPS.PAY_SE_TRNA_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 434: FROM per_all_assignments_f paaf, per_assignment_status_types past

430: CURSOR csr_start_date (
431: p_assignment_id per_all_assignments_f.assignment_id%TYPE
432: ) IS
433: SELECT min (effective_start_date)
434: FROM per_all_assignments_f paaf, per_assignment_status_types past
435: WHERE assignment_id = p_assignment_id
436: AND paaf.assignment_status_type_id = past.assignment_status_type_id
437: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
438: AND effective_start_date BETWEEN g_start_date AND g_end_date;