APPS.PER_RO_DEI_INFO dependencies on DUAL

Line 34: select 1 into l_doc_exist from dual where p_document_type_id in

30:
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;

Line 83: select ((add_months(trunc(P_DATE_FROM,'Y'),12)-1) + 60) into l_expiry_date from dual;

79: end if;
80:
81: /* validating the expiry date in case of Fiscal Residence Certificate (usually the respective calendar year plus the next 60 days) */
82: if l_sys_doc_type = 'RO Foreign citizens' then
83: select ((add_months(trunc(P_DATE_FROM,'Y'),12)-1) + 60) into l_expiry_date from dual;
84: if l_expiry_date <> P_DATE_TO THEN
85: hr_utility.set_message(800,'HR_520016_DEI_DATE_TO_CHK');
86: hr_utility.raise_error;
87: end if;