DBA Data[Home] [Help]

APPS.PQH_FR_STAT_SIT_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 236: FROM per_all_assignments_f asg,

232: p_determination_date IN DATE) return varchar2
233: IS
234: Cursor csr_emp_type is
235: SELECT scl.segment10 emp_type
236: FROM per_all_assignments_f asg,
237: hr_soft_coding_keyflex scl
238: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
239: AND person_id = p_person_id
240: AND p_determination_date between effective_start_date and effective_end_date