APPS.HR_DOR_REVIEW_SS dependencies on HR_DOCUMENT_TYPES_V

Line 2545: l_document_type hr_document_types_v.document_type%type;

2541: )
2542: IS
2543:
2544: l_proc varchar2(72) := g_package ||'validate_dor';
2545: l_document_type hr_document_types_v.document_type%type;
2546: l_num number;
2547: l_num1 number;
2548: msg_name varchar2(1000);
2549: msg_appl varchar2(10);

Line 2809: from hr_document_types_v

2805: if l_num > 0 then
2806: close csr_chk_duplicate_txn;
2807:
2808: select document_type into l_document_type
2809: from hr_document_types_v
2810: where document_type_id = p_document_type_id;
2811:
2812: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2813: hr_utility.set_message_token('TYPE', l_document_type);

Line 3543: FROM HR_DOCUMENT_TYPES_V

3539: ,l_category_name
3540: ,l_sub_category_name
3541: ,l_legislation_code
3542: ,l_system_doc_type
3543: FROM HR_DOCUMENT_TYPES_V
3544: WHERE DOCUMENT_TYPE_ID=p_dor_rec.document_type_id;
3545:
3546: if l_legislation_code is not null then
3547: SELECT TERRITORY_SHORT_NAME