APPS.PER_RO_DEI_INFO dependencies on HR_DOCUMENT_EXTRA_INFO

Line 18: select 'X' from hr_document_extra_info

14: select system_document_type from hr_document_types
15: where document_type_id = p_document_type_id; */
16:
17: cursor csr_doc_no_unique is
18: select 'X' from hr_document_extra_info
19: where document_type_id = P_DOCUMENT_TYPE_ID
20: and document_number = P_DOCUMENT_NUMBER
21: and ( DOCUMENT_EXTRA_INFO_ID <> P_DOCUMENT_EXTRA_INFO_ID or P_DOCUMENT_EXTRA_INFO_ID is null)
22: and sysdate between date_from and date_to;

Line 103: select 'x' from hr_document_extra_info

99: P_DATE_FROM DATE,
100: P_DATE_TO DATE) IS
101:
102: cursor csr_doc_exists is
103: select 'x' from hr_document_extra_info
104: where person_id = p_person_id
105: and document_type_id = p_document_type_id
106: and (date_from between p_date_from and p_date_to or
107: date_to between p_date_from and p_date_to or

Line 151: select null from hr_document_extra_info

147: P_DATE_TO DATE,
148: P_ISSUED_DATE DATE) IS
149:
150: cursor csr_doc_exists is
151: select null from hr_document_extra_info
152: where person_id = p_person_id
153: and document_type_id = p_document_type_id
154: and (date_from between p_date_from and p_date_to or
155: date_to between p_date_from and p_date_to or