APPS.HR_NO_UTILITY dependencies on HR_DOCUMENT_EXTRA_INFO

Line 1081: select null from hr_document_extra_info

1077: )is
1078:
1079: l_exists varchar2(1);
1080: cursor csr_doc_exists is
1081: select null from hr_document_extra_info
1082: where person_id = p_person_id
1083: and document_type_id = p_document_type_id
1084: and (date_from between p_date_from and p_date_to or
1085: date_to between p_date_from and p_date_to or

Line 1089: SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE

1085: date_to between p_date_from and p_date_to or
1086: p_date_from between date_from and date_to);
1087:
1088: /*CURSOR CHECK_OVERLAP_DEI_INFO IS
1089: SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE
1090: DOCUMENT_TYPE_ID=P_DOCUMENT_TYPE_ID AND
1091: (P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/
1092: BEGIN
1093: IF P_ISSUED_DATE IS NULL THEN

Line 1120: select null from hr_document_extra_info

1116: P_DOCUMENT_TYPE_ID IN NUMBER
1117: )IS
1118: l_exists varchar2(1);
1119: cursor csr_doc_exists is
1120: select null from hr_document_extra_info
1121: where person_id = p_person_id
1122: and document_type_id = p_document_type_id
1123: and (date_from between p_date_from and p_date_to or
1124: date_to between p_date_from and p_date_to or

Line 1131: SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE

1127:
1128:
1129:
1130: /*CURSOR CHECK_OVERLAP_DEI_INFO IS
1131: SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE
1132: DOCUMENT_TYPE_ID=P_DOCUMENT_TYPE_ID AND
1133: (P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/
1134: BEGIN
1135: IF P_ISSUED_DATE IS NULL THEN