APPS.HR_NO_UTILITY dependencies on HR_DOCUMENT_EXTRA_INFO

Line 1005: select null from hr_document_extra_info

1001: )is
1002:
1003: l_exists varchar2(1);
1004: cursor csr_doc_exists is
1005: select null from hr_document_extra_info
1006: where person_id = p_person_id
1007: and document_type_id = p_document_type_id
1008: and (date_from between p_date_from and p_date_to or
1009: date_to between p_date_from and p_date_to or

Line 1013: SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE

1009: date_to between p_date_from and p_date_to or
1010: p_date_from between date_from and date_to);
1011:
1012: /*CURSOR CHECK_OVERLAP_DEI_INFO IS
1013: SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE
1014: DOCUMENT_TYPE_ID=P_DOCUMENT_TYPE_ID AND
1015: (P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/
1016: BEGIN
1017: IF P_ISSUED_DATE IS NULL THEN

Line 1044: select null from hr_document_extra_info

1040: P_DOCUMENT_TYPE_ID IN NUMBER
1041: )IS
1042: l_exists varchar2(1);
1043: cursor csr_doc_exists is
1044: select null from hr_document_extra_info
1045: where person_id = p_person_id
1046: and document_type_id = p_document_type_id
1047: and (date_from between p_date_from and p_date_to or
1048: date_to between p_date_from and p_date_to or

Line 1055: SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE

1051:
1052:
1053:
1054: /*CURSOR CHECK_OVERLAP_DEI_INFO IS
1055: SELECT 1 FROM HR_DOCUMENT_EXTRA_INFO WHERE
1056: DOCUMENT_TYPE_ID=P_DOCUMENT_TYPE_ID AND
1057: (P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/
1058: BEGIN
1059: IF P_ISSUED_DATE IS NULL THEN