APPS.HR_DOCUMENT_EXTRA_INFO_API dependencies on HR_DOCUMENT_TYPES_V

Line 109: l_mul_flag hr_document_types_v.multiple_occurences_flag%type;

105: l_document_type varchar2(50);
106: l_document_type_id hr_document_extra_info.document_type_id%type;
107: l_date_from hr_document_extra_info.date_from%type;
108: l_date_to hr_document_extra_info.date_to%type;
109: l_mul_flag hr_document_types_v.multiple_occurences_flag%type;
110: l_num number;
111: l_authorization_required varchar2(10);
112: l_verified_by number := p_verified_by;
113: l_verified_date date := p_verified_date;

Line 119: from hr_document_types_v

115:
116: cursor csr_get_document_type(p_document_type_id number)
117: is
118: select document_type,authorization_required
119: from hr_document_types_v
120: where document_type_id=p_document_type_id;
121:
122: cursor csr_chk_combination(p_document_type_id number,p_person_id number,
123: p_date_from DATE,p_date_to DATE) is

Line 134: from HR_DOCUMENT_TYPES_V

130:
131:
132: cursor csr_chk_multiple(p_document_type_id number) is
133: select MULTIPLE_OCCURENCES_FLAG
134: from HR_DOCUMENT_TYPES_V
135: where DOCUMENT_TYPE_ID = p_document_type_id;
136:
137: cursor csr_chk_doc_allowed(p_document_type_id number,p_person_id number) is
138: select count(*) from hr_document_extra_info

Line 632: l_mul_flag hr_document_types_v.multiple_occurences_flag%type;

628: l_authorization_required varchar2(10);
629: l_verified_by number := p_verified_by;
630: l_verified_date date := p_verified_date;
631: l_document_type varchar2(50);
632: l_mul_flag hr_document_types_v.multiple_occurences_flag%type;
633: l_num number;
634: dummy varchar2(5);
635:
636: cursor csr_get_document_type(p_document_type_id number)

Line 639: from hr_document_types_v

635:
636: cursor csr_get_document_type(p_document_type_id number)
637: is
638: select document_type,authorization_required
639: from hr_document_types_v
640: where document_type_id=p_document_type_id;
641:
642: cursor csr_chk_combination(p_document_type_id number,p_person_id number,p_date_from DATE,
643: p_date_to DATE,p_document_extra_info_id number) is

Line 655: from HR_DOCUMENT_TYPES_V

651:
652:
653: cursor csr_chk_multiple(p_document_type_id number) is
654: select MULTIPLE_OCCURENCES_FLAG
655: from HR_DOCUMENT_TYPES_V
656: where DOCUMENT_TYPE_ID = p_document_type_id;
657:
658: cursor csr_chk_doc_allowed(p_document_type_id number,p_person_id number,
659: p_document_extra_info_id number) is