APPS.PER_PL_DEI_INFO dependencies on HR_DOCUMENT_TYPES

Line 40: select system_document_type from hr_document_types

36: P_DATE_FROM DATE,
37: P_DATE_TO DATE) IS
38:
39: cursor csr_document_type is
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

Line 52: l_sys_doc_type hr_document_types.system_document_type%TYPE;

48: date_to between p_date_from and p_date_to or
49: p_date_from between date_from and date_to);
50:
51: l_exists varchar2(1);
52: l_sys_doc_type hr_document_types.system_document_type%TYPE;
53: l_proc varchar2(18);
54: BEGIN
55: l_proc:='CREATE_PL_DEI_INFO';
56: /* Added for GSI Bug 5472781 */

Line 103: select system_document_type from hr_document_types

99: P_DATE_TO DATE,
100: P_ISSUED_DATE DATE) IS
101:
102: cursor csr_document_type is
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

Line 116: l_sys_doc_type hr_document_types.system_document_type%TYPE;

112: p_date_from between date_from and date_to)
113: and document_extra_info_id <> p_document_extra_info_id;
114:
115: l_exists varchar2(1);
116: l_sys_doc_type hr_document_types.system_document_type%TYPE;
117: l_proc varchar2(18);
118: BEGIN
119: l_proc:='UPDATE_PL_DEI_INFO';
120: /* Added for GSI Bug 5472781 */