APPS.PER_PL_DEI_INFO dependencies on HR_DOCUMENT_EXTRA_INFO

Line 44: select null from hr_document_extra_info

40: select system_document_type from hr_document_types
41: where document_type_id = p_document_type_id;
42:
43: cursor csr_doc_exists is
44: select null from hr_document_extra_info
45: where person_id = p_person_id
46: and document_type_id = p_document_type_id
47: and (date_from between p_date_from and p_date_to or
48: date_to between p_date_from and p_date_to or

Line 107: select null from hr_document_extra_info

103: select system_document_type from hr_document_types
104: where document_type_id = p_document_type_id;
105:
106: cursor csr_doc_exists is
107: select null from hr_document_extra_info
108: where person_id = p_person_id
109: and document_type_id = p_document_type_id
110: and (date_from between p_date_from and p_date_to or
111: date_to between p_date_from and p_date_to or