DBA Data[Home] [Help]

APPS.PAYVWELE dependencies on PER_ASSIGNMENTS_F

Line 84: per_assignments_f paf

80: --
81: SELECT scl.segment1
82: INTO l_tax_unit_id
83: FROM hr_soft_coding_keyflex scl,
84: per_assignments_f paf
85: where scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
86: and paf.assignment_id = p_assignment_id
87: and p_session_date between paf.effective_start_date AND paf.effective_end_date;
88: --