DBA Data[Home] [Help]

APPS.PER_PAT_UPD dependencies on PER_ALLOCATED_CHECKLISTS

Line 70: from PER_ALLOCATED_CHECKLISTS

66: select full_name
67: from per_all_people_f
68: where person_id in (
69: select person_id
70: from PER_ALLOCATED_CHECKLISTS
71: where ALLOCATED_CHECKLIST_ID =p_rec.allocated_checklist_id )
72: and sysdate between effective_start_date and effective_end_date;
73:
74: cursor csr_username is