APPS.PER_RO_DEI_INFO dependencies on HR_DOCUMENT_TYPES

Line 14: select system_document_type from hr_document_types

10: P_DATE_TO DATE
11: ) IS
12:
13: /*cursor csr_document_type is
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

Line 25: l_sys_doc_type hr_document_types.system_document_type%TYPE;

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;
23:
24:
25: l_sys_doc_type hr_document_types.system_document_type%TYPE;
26: l_unique varchar2(1);
27: l_expiry_date date;
28: l_doc_exist number default 0;
29: --l_str varchar2(200);

Line 35: (select document_type_id from hr_document_types where category_code in ('RO_ID_INFO','RO_WORK_AUTH','RO_FISCAL_CERT'));

31: BEGIN
32:
33: BEGIN
34: select 1 into l_doc_exist from dual where p_document_type_id in
35: (select document_type_id from hr_document_types where category_code in ('RO_ID_INFO','RO_WORK_AUTH','RO_FISCAL_CERT'));
36: exception
37: when no_data_found then
38: l_doc_exist :=0;
39: end;