The following lines contain the word 'select', 'insert', 'update' or 'delete':
,last_update_date DATE
,creation_date DATE);
SELECT pdf.segment3 NFC_Agency_Code,
pdf.segment4 Personnel_Office_ID,
pdf.segment7 Grade
FROM hr_all_positions_f pos, per_position_definitions pdf
WHERE pos.position_definition_id = pdf.position_definition_id
AND pos.position_id = c_position_id
AND c_effective_date between pos.effective_start_date and pos.effective_end_date;
SELECT 'X'
FROM hr_all_positions_f hap
WHERE hap.position_id =cp_position_id
AND cp_effective_date BETWEEN hap.effective_start_date
AND hap.effective_end_date
AND hap.business_group_id =cp_business_group_id
AND hap.information6 is null;
SELECT 'X'
FROM hr_all_positions_f hap
WHERE hap.position_id =cp_position_id
AND cp_effective_date BETWEEN hap.effective_start_date
AND hap.effective_end_date
AND hap.business_group_id =cp_business_group_id
AND hap.information6 is not null;
SELECT argument7, --Tranmission Type
argument8, -- Date Criteria
argument12, -- From Date
argument13, -- To Date
argument14, -- Agency Code
argument15, -- Personnel Office Id
argument16, -- Transmission Indicator
argument17, -- Signon Identification
argument18, -- User_ID
argument19, -- dept Code
argument20, -- Payroll_id
argument21 -- Notify
FROM fnd_concurrent_requests
WHERE request_id = c_req_id;
SELECT bba.request_id
FROM ben_benefit_actions bba
WHERE bba.pl_id = c_ext_rslt_id
AND bba.pgm_id = c_ext_dfn_id
AND bba.business_group_id = c_business_group_id;
SELECT rcd.ext_rcd_id
FROM ben_ext_rcd rcd
,ben_ext_rcd_in_file rin
,ben_ext_dfn dfn
WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
AND rin.ext_file_id = dfn.ext_file_id
AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
AND rin.ext_rcd_id = rcd.ext_rcd_id
AND rcd.rcd_type_cd = c_rcd_type_cd; --S- Sub Header D=Detail,H=Header,F=Footer
SELECT *
FROM ben_ext_rslt_dtl dtl
WHERE dtl.ext_rslt_id = c_ext_rslt_id
AND dtl.VAL_71 = c_position_id
AND dtl.ext_rcd_id = c_ext_dtl_rcd_id;
SELECT *
FROM ben_ext_rslt_dtl dtl
WHERE dtl.ext_rslt_id = c_ext_rslt_id
AND dtl.VAL_71 = c_position_id
AND dtl.ext_rslt_dtl_id = c_ext_rslt_dtl_id;
SELECT dtl.val_71 --Position_id
FROM ben_ext_rslt_dtl dtl
WHERE dtl.ext_rslt_id = c_ext_rslt_id
AND dtl.VAL_45 = 'A' --Function Code
AND dtl.ext_rcd_id = c_ext_dtl_rcd_id
AND dtl.VAL_49 is not null; --Incumbent SSN
SELECT rslt.ext_rslt_dtl_id
FROM ben_ext_rcd rcd
,ben_ext_rcd_in_file rin
,ben_ext_dfn dfn
,ben_ext_rslt_dtl rslt
WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
AND rin.ext_file_id = dfn.ext_file_id
AND rin.hide_flag = c_ext_hide_flag -- Y=Hidden, N=Not Hidden
AND rin.ext_rcd_id = rcd.ext_rcd_id
AND rslt.EXT_RCD_ID = rcd.ext_rcd_id
AND rcd.rcd_type_cd = c_rcd_type_cd --S- Sub Header D=Detail,H=Header,F=Footer
and rslt.val_71 =c_position_id
and rslt.ext_rslt_id =c_ext_rslt_id
and rslt.business_group_id =c_business_group_id;
SELECT ptp.period_num
FROM per_time_periods ptp
WHERE ptp.payroll_id=p_payroll_id
AND cp_effective_date BETWEEN ptp.start_date
AND ptp.end_date;
SELECT ptp.period_num
,ptp.start_date start_date
,ptp.end_date end_date
,paa.position_id
FROM per_time_periods ptp
,per_all_assignments_f paa
WHERE paa.assignment_id = cp_assignment_id
AND paa.business_group_id = cp_business_group_id
AND cp_effective_date BETWEEN paa.effective_start_date
AND paa.effective_end_date
AND paa.payroll_id =ptp.payroll_id
AND cp_effective_date BETWEEN ptp.start_date
AND ptp.end_date;
SELECT pea.ext_dfn_id ext_dfn_id
FROM pqp_extract_attributes pea
WHERE pea.ext_dfn_name = c_extract_name;
update ben_ext_rslt_dtl
set val_01 = p_val_tab(1)
,val_02 = p_val_tab(2)
,val_03 = p_val_tab(3)
,val_04 = p_val_tab(4)
,val_05 = p_val_tab(5)
,val_06 = p_val_tab(6)
,val_07 = p_val_tab(7)
,val_08 = p_val_tab(8)
,val_09 = p_val_tab(9)
,val_10 = p_val_tab(10)
,val_11 = p_val_tab(11)
,val_12 = p_val_tab(12)
,val_13 = p_val_tab(13)
,val_14 = p_val_tab(14)
,val_15 = p_val_tab(15)
,val_16 = p_val_tab(16)
,val_17 = p_val_tab(17)
,val_19 = p_val_tab(19)
,val_18 = p_val_tab(18)
,val_20 = p_val_tab(20)
,val_21 = p_val_tab(21)
,val_22 = p_val_tab(22)
,val_23 = p_val_tab(23)
,val_24 = p_val_tab(24)
,val_25 = p_val_tab(25)
,val_26 = p_val_tab(26)
,val_27 = p_val_tab(27)
,val_28 = p_val_tab(28)
,val_29 = p_val_tab(29)
,val_30 = p_val_tab(30)
,val_31 = p_val_tab(31)
,val_32 = p_val_tab(32)
,val_33 = p_val_tab(33)
,val_34 = p_val_tab(34)
,val_35 = p_val_tab(35)
,val_36 = p_val_tab(36)
,val_37 = p_val_tab(37)
,val_38 = p_val_tab(38)
,val_39 = p_val_tab(39)
,val_40 = p_val_tab(40)
,val_41 = p_val_tab(41)
,val_42 = p_val_tab(42)
,val_43 = p_val_tab(43)
,val_44 = p_val_tab(44)
,val_45 = p_val_tab(45)
,val_46 = p_val_tab(46)
,val_47 = p_val_tab(47)
,val_48 = p_val_tab(48)
,val_49 = p_val_tab(49)
,val_50 = p_val_tab(50)
,val_51 = p_val_tab(51)
,val_52 = p_val_tab(52)
,val_53 = p_val_tab(53)
,val_54 = p_val_tab(54)
,val_55 = p_val_tab(55)
,val_56 = p_val_tab(56)
,val_57 = p_val_tab(57)
,val_58 = p_val_tab(58)
,val_59 = p_val_tab(59)
,val_60 = p_val_tab(60)
,val_61 = p_val_tab(61)
,val_62 = p_val_tab(62)
,val_63 = p_val_tab(63)
,val_64 = p_val_tab(64)
,val_65 = p_val_tab(65)
,val_66 = p_val_tab(66)
,val_67 = p_val_tab(67)
,val_68 = p_val_tab(68)
,val_69 = p_val_tab(69)
,val_70 = p_val_tab(70)
,val_71 = p_val_tab(71)
,val_72 = p_val_tab(72)
,val_73 = p_val_tab(73)
,val_74 = p_val_tab(74)
,val_75 = p_val_tab(75)
,object_version_number = p_dtl_rec.object_version_number
--,thrd_sort_val = p_dtl_rec.thrd_sort_val
where ext_rslt_dtl_id = p_dtl_rec.ext_rslt_dtl_id;
select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;
insert into ben_ext_rslt_dtl
(ext_rslt_dtl_id
,ext_rslt_id
,business_group_id
,ext_rcd_id
,person_id
,val_01
,val_02
,val_03
,val_04
,val_05
,val_06
,val_07
,val_08
,val_09
,val_10
,val_11
,val_12
,val_13
,val_14
,val_15
,val_16
,val_17
,val_19
,val_18
,val_20
,val_21
,val_22
,val_23
,val_24
,val_25
,val_26
,val_27
,val_28
,val_29
,val_30
,val_31
,val_32
,val_33
,val_34
,val_35
,val_36
,val_37
,val_38
,val_39
,val_40
,val_41
,val_42
,val_43
,val_44
,val_45
,val_46
,val_47
,val_48
,val_49
,val_50
,val_51
,val_52
,val_53
,val_54
,val_55
,val_56
,val_57
,val_58
,val_59
,val_60
,val_61
,val_62
,val_63
,val_64
,val_65
,val_66
,val_67
,val_68
,val_69
,val_70
,val_71
,val_72
,val_73
,val_74
,val_75
/*,val_76
,val_77
,val_78
,val_79
,val_80
,val_81
,val_82
,val_83
,val_84
,val_85
,val_86
,val_87
,val_88
,val_89
,val_90
,val_91
,val_92
,val_93
,val_94
,val_95
,val_96
,val_97
,val_98
,val_99
,val_100
,val_101
,val_102
,val_103
,val_104
,val_105
,val_106
,val_107
,val_108
,val_109
,val_110
,val_111
,val_112
,val_113
,val_114
,val_115
,val_116
,val_117
,val_118
,val_119
,val_120
,val_121
,val_122
,val_123
,val_124
,val_125
,val_126
,val_127
,val_128
,val_129
,val_130
,val_131
,val_132
,val_133
,val_134
,val_135
,val_136
,val_137
,val_138
,val_139
,val_140
,val_141
,val_142
,val_143
,val_144
,val_145
,val_146
,val_147
,val_148
,val_149
,val_150 */
,created_by
,creation_date
,last_update_date
,last_updated_by
,last_update_login
,program_application_id
,program_id
,program_update_date
,request_id
,object_version_number
,prmy_sort_val
,scnd_sort_val
,thrd_sort_val
,trans_seq_num
,rcrd_seq_num
)
values
(p_dtl_rec.ext_rslt_dtl_id
,p_dtl_rec.ext_rslt_id
,p_dtl_rec.business_group_id
,p_dtl_rec.ext_rcd_id
,p_dtl_rec.person_id
,p_val_tab(1)
,p_val_tab(2)
,p_val_tab(3)
,p_val_tab(4)
,p_val_tab(5)
,p_val_tab(6)
,p_val_tab(7)
,p_val_tab(8)
,p_val_tab(9)
,p_val_tab(10)
,p_val_tab(11)
,p_val_tab(12)
,p_val_tab(13)
,p_val_tab(14)
,p_val_tab(15)
,p_val_tab(16)
,p_val_tab(17)
,p_val_tab(19)
,p_val_tab(18)
,p_val_tab(20)
,p_val_tab(21)
,p_val_tab(22)
,p_val_tab(23)
,p_val_tab(24)
,p_val_tab(25)
,p_val_tab(26)
,p_val_tab(27)
,p_val_tab(28)
,p_val_tab(29)
,p_val_tab(30)
,p_val_tab(31)
,p_val_tab(32)
,p_val_tab(33)
,p_val_tab(34)
,p_val_tab(35)
,p_val_tab(36)
,p_val_tab(37)
,p_val_tab(38)
,p_val_tab(39)
,p_val_tab(40)
,p_val_tab(41)
,p_val_tab(42)
,p_val_tab(43)
,p_val_tab(44)
,p_val_tab(45)
,p_val_tab(46)
,p_val_tab(47)
,p_val_tab(48)
,p_val_tab(49)
,p_val_tab(50)
,p_val_tab(51)
,p_val_tab(52)
,p_val_tab(53)
,p_val_tab(54)
,p_val_tab(55)
,p_val_tab(56)
,p_val_tab(57)
,p_val_tab(58)
,p_val_tab(59)
,p_val_tab(60)
,p_val_tab(61)
,p_val_tab(62)
,p_val_tab(63)
,p_val_tab(64)
,p_val_tab(65)
,p_val_tab(66)
,p_val_tab(67)
,p_val_tab(68)
,p_val_tab(69)
,p_val_tab(70)
,p_val_tab(71)
,p_val_tab(72)
,p_val_tab(73)
,p_val_tab(74)
,p_val_tab(75)
/*,p_val_tab(76)
,p_val_tab(77)
,p_val_tab(78)
,p_val_tab(79)
,p_val_tab(80)
,p_val_tab(81)
,p_val_tab(82)
,p_val_tab(83)
,p_val_tab(84)
,p_val_tab(85)
,p_val_tab(86)
,p_val_tab(87)
,p_val_tab(88)
,p_val_tab(89)
,p_val_tab(90)
,p_val_tab(91)
,p_val_tab(92)
,p_val_tab(93)
,p_val_tab(94)
,p_val_tab(95)
,p_val_tab(96)
,p_val_tab(97)
,p_val_tab(98)
,p_val_tab(99)
,p_val_tab(100)
,p_val_tab(101)
,p_val_tab(102)
,p_val_tab(103)
,p_val_tab(104)
,p_val_tab(105)
,p_val_tab(106)
,p_val_tab(107)
,p_val_tab(108)
,p_val_tab(109)
,p_val_tab(110)
,p_val_tab(111)
,p_val_tab(112)
,p_val_tab(113)
,p_val_tab(114)
,p_val_tab(115)
,p_val_tab(116)
,p_val_tab(117)
,p_val_tab(118)
,p_val_tab(119)
,p_val_tab(120)
,p_val_tab(121)
,p_val_tab(122)
,p_val_tab(123)
,p_val_tab(124)
,p_val_tab(125)
,p_val_tab(126)
,p_val_tab(127)
,p_val_tab(128)
,p_val_tab(129)
,p_val_tab(130)
,p_val_tab(131)
,p_val_tab(132)
,p_val_tab(133)
,p_val_tab(134)
,p_val_tab(135)
,p_val_tab(136)
,p_val_tab(137)
,p_val_tab(138)
,p_val_tab(139)
,p_val_tab(140)
,p_val_tab(141)
,p_val_tab(142)
,p_val_tab(143)
,p_val_tab(144)
,p_val_tab(145)
,p_val_tab(146)
,p_val_tab(147)
,p_val_tab(148)
,p_val_tab(149)
,p_val_tab(150)*/
,p_dtl_rec.created_by
,p_dtl_rec.creation_date
,p_dtl_rec.last_update_date
,p_dtl_rec.last_updated_by
,p_dtl_rec.last_update_login
,p_dtl_rec.program_application_id
,p_dtl_rec.program_id
,p_dtl_rec.program_update_date
,p_dtl_rec.request_id
,p_dtl_rec.object_version_number
,p_dtl_rec.prmy_sort_val
,p_dtl_rec.scnd_sort_val
,p_dtl_rec.thrd_sort_val
,p_dtl_rec.trans_seq_num
,p_dtl_rec.rcrd_seq_num
);
p_pos_extra_info(1).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(2).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(3).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(4).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(5).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(6).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(7).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(8).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(9).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(10).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(11).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(12).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(13).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(14).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(15).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(16).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(17).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(18).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(19).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(20).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(21).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(22).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(23).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(24).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(25).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(26).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(27).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(28).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(29).last_update_date :=p_posi_extra_info.last_update_date;
p_pos_extra_info(30).last_update_date :=p_posi_extra_info.last_update_date;
SELECT hap.effective_start_date
,hap.effective_end_date
,permanent_temporary_flag
,HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status
,hap.location_id
FROM hr_all_positions_f hap
WHERE cp_eff_date BETWEEN hap.effective_start_date
AND hap.effective_end_date
AND hap.position_id=p_position_id
AND hap.business_group_id = p_business_group_id;
SELECT hap.effective_start_date st_date
,hap.effective_end_date e_date
,hap.creation_date
,HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status
FROM hr_all_positions_f hap
WHERE hap.position_id=p_position_id
AND hap.business_group_id = p_business_group_id
AND hap.effective_start_date <= p_eff_dt
ORDER BY hap.effective_start_date asc;
SELECT 1
FROM ghr_pa_history hist
WHERE hist.information1 = to_char(c_position_id)
AND hist.table_name = 'HR_ALL_POSITIONS_F'
AND (hist.effective_date BETWEEN c_eff_start_date AND c_eff_end_date
OR TRUNC(hist.process_date) BETWEEN TRUNC(c_eff_start_date) AND TRUNC(c_eff_end_date))
AND EXISTS(
SELECT 1 FROM ghr_pa_history hist1
WHERE hist1.information1 = to_char(c_position_id)
AND hist1.table_name = 'HR_ALL_POSITIONS_F'
AND hist1.effective_date > hist.effective_date
and hist.pa_history_id > hist1.pa_history_id
AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(hist1.information24) = 'Eliminated') ;
SELECT hap.information6 mrn
FROM hr_all_positions_f hap
WHERE hap.position_id =cp_position_id
AND cp_effective_date BETWEEN hap.effective_start_date
AND hap.effective_end_date
AND hap.business_group_id =cp_business_group_id;
SELECT pg.name
FROM per_grades pg
WHERE pg.grade_id=cp_grade_id
AND pg.business_group_id = cp_business_group_id;
SELECT job.name
FROM hr_all_positions_f pos,
per_jobs job
WHERE pos.position_id = p_position_id
AND p_date_effective BETWEEN pos.effective_start_date
AND pos.effective_end_date
AND job.job_id = pos.job_id;
SELECT poei_information3 Int_Series_Code
,poei_information4 Int_Title_Code
,poei_information6 Int_Title_Suffix
,poei_information5 Int_Title_Prefix
FROM per_position_extra_info pei
WHERE pei.position_id = cp_position_id
AND rownum <=10
AND information_type = 'GHR_US_POSITION_INTERDISC'
ORDER BY poei_information3;
SELECT hap.effective_start_date
,hap.effective_end_date
FROM hr_all_positions_f hap
WHERE hap.position_id = cp_position_id
AND (cp_effective_end_date BETWEEN hap.effective_start_date
AND hap.effective_end_date
OR hap.effective_start_date BETWEEN cp_effective_start_date
AND cp_effective_end_date
OR hap.effective_end_date BETWEEN cp_effective_start_date
AND cp_effective_end_date)
AND hap.business_group_id = cp_business_group_id
ORDER BY hap.effective_end_date;
l_master_data_temp.delete;
g_master_data.delete;
g_int_data.delete;
g_int_metadata.delete;
g_master_data.delete;
l_pqp_record_values.delete;
l_pqp_record_values.delete;
SELECT 'X'
FROM per_all_assignments_f
WHERE position_id = c_position_id
AND business_group_id = c_business_group_id
AND c_effective_date BETWEEN effective_start_date
AND effective_end_date;
SELECT position_id
FROM per_all_assignments_f
WHERE assignment_id = c_assignment_id
AND business_group_id = c_business_group_id
AND c_effective_date BETWEEN effective_start_date
AND effective_end_date;
SELECT period_num
FROM per_time_periods
WHERE payroll_id = c_payroll_id
AND c_effective_date BETWEEN start_date
AND end_date;
SELECT bba.request_id
FROM ben_benefit_actions bba
WHERE bba.pl_id = c_ext_rslt_id
AND bba.pgm_id = c_ext_dfn_id ;
SELECT argument4, --Business Group ID
argument5, --User ID
argument6, --dept Code
argument7, --Agency Code
argument8 --POI
FROM fnd_concurrent_requests
WHERE request_id = c_req_id;
SELECT POSITION_ID,
susp_function_cd,
record_id,
result_dtl_id,
result_id
FROM ghr_pos_interface_err_dtls;
SELECT dtl.ext_rslt_dtl_id
,dtl.val_45 --Detail function code
,dtl.val_26 --Open Position function code
FROM ben_ext_rslt_dtl dtl
WHERE dtl.ext_rslt_id = c_ext_rslt_id
AND dtl.VAL_71 = c_position_id
AND dtl.ext_rcd_id = c_ext_dtl_rcd_id;
SELECT Count(dtl.ext_rslt_dtl_id)
FROM ben_ext_rslt_dtl dtl
WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
AND dtl.ext_rcd_id NOT IN(c_ext_rcd_id);
select distinct paf.position_id
from per_all_assignments_f paf
,ben_ext_rslt_dtl dtl
where dtl.val_71 = paf.position_id
and paf.business_group_id = c_business_group_id
and paf.business_group_id = dtl.business_group_id
and paf.person_id = dtl.person_id
and dtl.ext_rslt_id = c_ext_rslt_id
and dtl.VAL_45 = 'C'
and dtl.ext_rcd_id = c_ext_rcd_id
and dtl.VAL_49 is not null
and paf.effective_start_date = c_effective_date;
SELECT dtl.*
FROM ben_ext_rcd rcd
,ben_ext_rcd_in_file rin
,ben_ext_dfn dfn
,ben_ext_rslt_dtl dtl
WHERE dfn.ext_dfn_id = c_ext_dfn_id
AND rin.ext_file_id = dfn.ext_file_id
AND rin.hide_flag = 'N' -- Y=Hidden, N=Not Hidden
AND rin.ext_rcd_id = rcd.ext_rcd_id
AND rcd.rcd_type_cd in ('S','D')
AND rcd.ext_rcd_id = dtl.ext_rcd_id
and dtl.ext_rslt_id = c_ext_rslt_id
ORDER BY dtl.val_02 desc;
-- then delete it from detail record
DELETE
FROM ben_ext_rslt_dtl
WHERE ext_rcd_id = g_ext_dtl_rcd_id
AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
AND business_group_id = p_business_group_id
AND val_71 = l_ext_position_id;
-- then delete it from detail record
DELETE
FROM ben_ext_rslt_dtl
WHERE ext_rcd_id = g_ext_dtl_rcd_id
AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
AND business_group_id = p_business_group_id
AND val_71 = l_ext_position_id;
DELETE
FROM ben_ext_rslt_dtl
WHERE ext_rcd_id = csr_rcd_rec_t.ext_rcd_id
AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
AND business_group_id = p_business_group_id
AND val_52 = 'FOUND';
UPDATE ben_ext_rslt_dtl set val_06 = LPAD(l_rc,8,'0')
WHERE ext_rcd_id = csr_header_rcd_id.ext_rcd_id
AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
AND business_group_id= p_business_group_id;
UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val
,group_val_01 = ' '
WHERE ext_rcd_id = l_main_rec.ext_rcd_id
AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
AND ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
AND business_group_id= p_business_group_id;
UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val
WHERE ext_rcd_id = l_main_rec.ext_rcd_id
AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
AND ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
AND business_group_id= p_business_group_id;