[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select PERSON_ID
,BUSINESS_GROUP_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,DATE_OF_BIRTH
,DATE_OF_DEATH
,ON_MILITARY_SERVICE
,MARITAL_STATUS
,REGISTERED_DISABLED_FLAG
,SEX
,STUDENT_STATUS
,BENEFIT_GROUP_ID
,COORD_BEN_NO_CVG_FLAG
,USES_TOBACCO_FLAG
,COORD_BEN_MED_PLN_NO
,PER_INFORMATION10
,DPDNT_VLNTRY_SVCE_FLAG
,RECEIPT_OF_DEATH_CERT_DATE
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE16
,ATTRIBUTE17
,ATTRIBUTE18
,ATTRIBUTE19
,ATTRIBUTE20
,ATTRIBUTE21
,ATTRIBUTE22
,ATTRIBUTE23
,ATTRIBUTE24
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,null
from per_all_people_f
where rowid = p_rowid;
select PERSON_ID
,BUSINESS_GROUP_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,DATE_OF_BIRTH
,DATE_OF_DEATH
,ON_MILITARY_SERVICE
,MARITAL_STATUS
,REGISTERED_DISABLED_FLAG
,SEX
,STUDENT_STATUS
,BENEFIT_GROUP_ID
,COORD_BEN_NO_CVG_FLAG
,USES_TOBACCO_FLAG
,COORD_BEN_MED_PLN_NO
,PER_INFORMATION10
,DPDNT_VLNTRY_SVCE_FLAG
,RECEIPT_OF_DEATH_CERT_DATE
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE16
,ATTRIBUTE17
,ATTRIBUTE18
,ATTRIBUTE19
,ATTRIBUTE20
,ATTRIBUTE21
,ATTRIBUTE22
,ATTRIBUTE23
,ATTRIBUTE24
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,ORIGINAL_DATE_OF_HIRE
from per_all_people_f
where rowid = p_rowid;
select PERSON_ID
,ASSIGNMENT_ID
,BUSINESS_GROUP_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,ORGANIZATION_ID
,GRADE_ID
,JOB_ID
,POSITION_ID
,PAYROLL_ID
,LOCATION_ID
,ASSIGNMENT_STATUS_TYPE_ID
,ASSIGNMENT_TYPE
,PAY_BASIS_ID
,PRIMARY_FLAG
,CHANGE_REASON
,EMPLOYMENT_CATEGORY
,FREQUENCY
,NORMAl_HOURS
,BARGAINING_UNIT_CODE
,LABOUR_UNION_MEMBER_FLAG
,PEOPLE_GROUP_ID
,HOURLY_SALARIED_CODE
,ASS_ATTRIBUTE1
,ASS_ATTRIBUTE2
,ASS_ATTRIBUTE3
,ASS_ATTRIBUTE4
,ASS_ATTRIBUTE5
,ASS_ATTRIBUTE6
,ASS_ATTRIBUTE7
,ASS_ATTRIBUTE8
,ASS_ATTRIBUTE9
,ASS_ATTRIBUTE10
,ASS_ATTRIBUTE11
,ASS_ATTRIBUTE12
,ASS_ATTRIBUTE13
,ASS_ATTRIBUTE14
,ASS_ATTRIBUTE15
,ASS_ATTRIBUTE16
,ASS_ATTRIBUTE17
,ASS_ATTRIBUTE18
,ASS_ATTRIBUTE19
,ASS_ATTRIBUTE20
,ASS_ATTRIBUTE21
,ASS_ATTRIBUTE22
,ASS_ATTRIBUTE23
,ASS_ATTRIBUTE24
,ASS_ATTRIBUTE25
,ASS_ATTRIBUTE26
,ASS_ATTRIBUTE27
,ASS_ATTRIBUTE28
,ASS_ATTRIBUTE29
,ASS_ATTRIBUTE30
from per_all_assignments_f
where rowid = p_rowid;
select PERSON_ID
-- 9999 ,person_type_usage_id
,null
,PERSON_TYPE_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
from per_person_type_usages_f
where rowid = p_rowid;
l_delete_benass boolean := false;
select count(*)
from per_periods_of_service
where person_id = p_person_id;
select *
from per_all_assignments_f
where person_id = p_person_id
and assignment_type = 'B'
and primary_flag = 'Y'
--
-- Bug 4395472 : added condition so that correct benefit
-- assignment record is picked
and effective_end_date >= p_pds_old_atd
-- End Bug 4395472
order by effective_start_date;
select null
from per_all_assignments_f asg
where asg.person_id = p_person_id
and asg.effective_start_date = p_pds_atd + 1
and assignment_type = 'B'
and primary_flag = 'Y';
select ptu.person_id, ppt.system_person_type
from per_person_type_usages_f ptu,
per_person_types ppt
where ptu.person_id in (select pcr.contact_person_id
from per_contact_relationships pcr
where pcr.person_id = p_person_id
)
and trunc(p_pds_old_atd+1) between trunc(ptu.effective_start_date)
and trunc(ptu.effective_end_date)
and ptu.person_type_id = ppt.person_type_id
and ppt.system_person_type in ( 'SRVNG_SPS',
'SRVNG_DP',
'SRVNG_DPFM',
'SRVNG_FMLY_MMBR');
l_delete_mode boolean;
l_delete_next_change_mode boolean;
l_asg_delete_mode varchar2(60);
l_delete_benass := false;
hr_utility.set_location('Assignment not being deleted', 10);
hr_utility.set_location('Assignment being deleted', 10);
l_delete_benass := true;
if l_delete_benass then
--
open c2;
p_delete => l_delete_mode,
p_future_change => l_future_change_mode,
p_delete_next_change => l_delete_next_change_mode);
if l_delete_next_change_mode = true then
-- Refer steps to reproduce of bug 3865655 to find the Scenario under which
-- this condition will be true
l_asg_delete_mode := 'DELETE_NEXT_CHANGE';
l_asg_delete_mode := 'ZAP';
ben_assignment_api.delete_ben_asg
(p_datetrack_mode => l_asg_delete_mode
,p_assignment_id => l_c2.assignment_id
,p_object_version_number => l_c2.object_version_number
,p_effective_date => l_c2.effective_start_date
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date);
select PERSON_ID
,null
,BUSINESS_GROUP_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,VAL
,BNFTS_BAL_ID
from ben_per_bnfts_bal_f
where rowid = p_rowid;
select PERSON_ID
,PER_BNFTS_BAL_ID
,BUSINESS_GROUP_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,VAL
,BNFTS_BAL_ID
from ben_per_bnfts_bal_f
where rowid = p_rowid;
select PRTT_ENRT_RSLT_ID
,null
,DPNT_PERSON_ID
,BUSINESS_GROUP_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,CVG_STRT_DT
,CVG_THRU_DT
,ovrdn_flag
,ovrdn_thru_dt
from ben_elig_cvrd_dpnt_f
where rowid = p_rowid;
select PRTT_ENRT_RSLT_ID
,elig_cvrd_dpnt_id
,dpnt_person_id
,BUSINESS_GROUP_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,CVG_STRT_DT
,CVG_THRU_DT
,ovrdn_flag
,ovrdn_thru_dt
from ben_elig_cvrd_dpnt_f
where rowid = p_rowid;
select PERSON_ID
,null
,BUSINESS_GROUP_ID
,ENRT_CVG_STRT_DT
,ENRT_CVG_THRU_DT
,BNFT_AMT
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
from ben_prtt_enrt_rslt_f
where rowid = p_rowid;
select PERSON_ID
,prtt_enrt_rslt_id
,BUSINESS_GROUP_ID
,ENRT_CVG_STRT_DT
,ENRT_CVG_THRU_DT
,BNFT_AMT
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
from ben_prtt_enrt_rslt_f
where rowid = p_rowid;
select ELEMENT_ENTRY_VALUE_ID
,SCREEN_ENTRY_VALUE
from pay_element_entry_values_f
where rowid = p_rowid;
select ASSIGNMENT_ID
,BUSINESS_GROUP_ID
,VALUE
,ASSIGNMENT_BUDGET_VALUE_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
from per_assignment_budget_values_f
where rowid = p_rowid;