[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(org_information_id)
FROM hr_organization_information
WHERE org_information_context= 'PER_CONT_AREA_CONT_BASE_CN'
AND org_information1 = p_org_information1
AND org_information2 = p_org_information2
AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information15)
AND fnd_date.canonical_to_date(NVL(org_information16,'4712/12/31 00:00:00'))
AND organization_id = p_organization_id
AND (org_information_id <> p_org_information_id
OR p_org_information_id IS NULL);
SELECT count(org_information_id)
FROM hr_organization_information
WHERE org_information_context='PER_CONT_AREA_PHF_SI_RATES_CN'
AND org_information1 = p_org_information1
AND nvl(org_information2,'X') = nvl(p_org_information2,'X')
AND org_information3 = p_org_information3
AND nvl(org_information9,'X') = nvl(p_org_information4,'X')
AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information10)
AND fnd_date.canonical_to_date(NVL(org_information11,'4712/12/31 00:00:00'))
AND organization_id = p_organization_id
AND (org_information_id <> p_org_information_id
OR p_org_information_id IS NULL) ;
SELECT min(fnd_date.canonical_to_date(org_information15))
FROM hr_organization_information
WHERE org_information1 = p_org_information1
AND org_information2 = p_org_information2
AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
AND org_information_context='PER_CONT_AREA_CONT_BASE_CN'
AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
AND fnd_date.canonical_to_date(org_information15) > p_effective_start_date
AND organization_id = p_organization_id
AND (org_information_id <> p_org_information_id
OR p_org_information_id IS NULL);
SELECT min(fnd_date.canonical_to_date(org_information10))
FROM hr_organization_information
WHERE org_information1 = p_org_information1
AND NVL(org_information2,'X') = NVL(p_org_information2,'X')
AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
AND org_information_context='PER_CONT_AREA_PHF_SI_RATES_CN'
AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
AND fnd_date.canonical_to_date(org_information10) > p_effective_start_date
AND organization_id = p_organization_id
AND (org_information_id <> p_org_information_id
OR p_org_information_id IS NULL);
SELECT COUNT (org_information_id)
FROM hr_organization_information hoi
WHERE hoi.organization_id = p_organization_id
AND hoi.org_information_context = p_org_info_type_code
AND p_effective_start_date BETWEEN
fnd_date.canonical_to_date(NVL(hoi.org_information3,'1900/01/01 00:00:00'))
AND fnd_date.canonical_to_date(NVL(hoi.org_information4,'4712/12/31 00:00:00'))
AND (org_information_id <>p_org_information_id OR p_org_information_id IS NULL);
SELECT min(fnd_date.canonical_to_date(org_information3))
FROM hr_organization_information
WHERE org_information_context= p_org_info_type_code
AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
AND fnd_date.canonical_to_date(NVL(org_information3,'1900/01/01 00:00:00')) > p_effective_start_date
AND organization_id = p_organization_id
AND (org_information_id <> p_org_information_id
OR p_org_information_id IS NULL);
SELECT COUNT (org_information_id) -- Y/N
FROM hr_organization_information hoi
WHERE hoi.organization_id = p_organization_id
AND hoi.org_information_context = 'PER_PHF_STAT_INFO_CN'
AND hoi.org_information1 = p_org_information1
AND (org_information_id <>p_org_information_id OR p_org_information_id IS NULL);
PROCEDURE CHECK_CN_ORG_INFO_TYPE_UPDATE
(p_org_info_type_code IN VARCHAR2 --Organization Information type
,p_org_information_id IN NUMBER --Organization Information ID
,p_org_information1 IN VARCHAR2
,p_org_information2 IN VARCHAR2
,p_org_information3 IN VARCHAR2
,p_org_information4 IN VARCHAR2
,p_org_information5 IN VARCHAR2
,p_org_information6 IN VARCHAR2
,p_org_information7 IN VARCHAR2
,p_org_information8 IN VARCHAR2
,p_org_information9 IN VARCHAR2
,p_org_information10 IN VARCHAR2
,p_org_information11 IN VARCHAR2
,p_org_information12 IN VARCHAR2
,p_org_information13 IN VARCHAR2
,p_org_information14 IN VARCHAR2
,p_org_information15 IN VARCHAR2
,p_org_information16 IN VARCHAR2
,p_org_information17 IN VARCHAR2
,p_org_information18 IN VARCHAR2
,p_org_information19 IN VARCHAR2
,p_org_information20 IN VARCHAR2
)
IS
l_organization_id NUMBER;
SELECT organization_id
,org_information1
,org_information2
,org_information3
,org_information4
,org_information5
,org_information6
,org_information7
,org_information8
,org_information9
,org_information10
,org_information11
,org_information12
,org_information13
,org_information14
,org_information15
,org_information16
,org_information17
,org_information18
,org_information19
,org_information20
FROM hr_organization_information
WHERE org_information_id = p_org_information_id;
l_procedure := g_package || 'check_cn_org_info_type_update';
END CHECK_CN_ORG_INFO_TYPE_UPDATE;