[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select *
From ben_ext_rslt_dtl dtl
Where dtl.ext_rslt_id = c_ext_rslt_id
And dtl.person_id = c_person_id
And dtl.ext_rcd_id = c_ext_dtl_rcd_id;
SELECT pbg.legislation_code
FROM per_business_groups_perf pbg
WHERE pbg.business_group_id = c_business_group_id;
Select payroll_name, period_type
from pay_payrolls_f
Where c_effective_date Between effective_start_date
and effective_end_date
and payroll_id = c_payroll_id;
Select max(ppa.effective_date)
from pay_payroll_actions ppa,
per_time_periods ptp
where c_effective_date between ptp.start_date
and ptp.end_date
and ptp.time_period_id= ppa.time_period_id
and ppa.action_type in ('Q','R')
and ppa.payroll_action_id In ( Select payroll_action_id
from pay_assignment_actions
where assignment_id= c_assignment_id
and action_status = 'C');
select user_status
from per_assignment_status_types
where assignment_status_type_id = c_assignment_status_type_id;
Select to_number(sft.segment1),
asg.business_group_id
From hr_soft_coding_keyflex sft,
per_assignments_f asg
Where sft.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
And asg.assignment_id = c_assignment_id
And c_effective_date between asg.effective_start_date
and asg.effective_end_date;
Select eat.ext_dfn_type
,eat.ext_dfn_id
From pqp_extract_attributes eat
Where eat.ext_dfn_id = ben_ext_thread.g_ext_dfn_id;
select *
from per_all_people_f
where person_id = c_person_id
and c_effective_date between effective_start_date
and effective_end_date;
g_all_sec_asgs.DELETE;
Delete from ben_ext_rslt_dtl where ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id;
g_primary_asg.DELETE;
g_payroll_names.DELETE;
SELECT fed_information5 dcp_limit -- DCP EE Contribution Limit
,effective_start_date
,effective_end_date
FROM pay_us_federal_tax_info_f
WHERE fed_information_category = 'SRS LIMITS'
AND cp_effective_date BETWEEN effective_start_date
AND effective_end_date;
Select a.ext_data_elmt_in_rcd_id
,a.seq_num
,a.sprs_cd
,a.strt_pos
,a.dlmtr_val
,a.rqd_flag
,b.ext_data_elmt_id
,b.data_elmt_typ_cd
,b.data_elmt_rl
,b.name
,hr_general.decode_lookup('BEN_EXT_FRMT_MASK', b.frmt_mask_cd) frmt_mask_cd
, b.frmt_mask_cd frmt_mask_lookup_cd
,b.string_val
,b.dflt_val
,b.max_length_num
,b.just_cd
from ben_ext_data_elmt b,
ben_ext_data_elmt_in_rcd a
where a.ext_data_elmt_id = b.ext_data_elmt_id
and b.data_elmt_typ_cd = 'R'
and a.ext_rcd_id = c_ext_rcd_id
order by a.seq_num;
Select formula_type_id
from ff_formulas_f
where formula_id = c_formula_type_id
and c_effective_date between effective_start_date
and effective_end_date;
hr_utility.set_location('.....Before Calling procedure Update_Record_Values',60);
Update_Record_Values ( p_ext_rcd_id => g_ext_dtl_rcd_id
,p_ext_data_element_name => Null
,p_data_element_value => l_ff_value
,p_data_ele_seqnum => i.seq_num
,p_ext_dtl_rec => l_new_rec);
Update_Record_Values ( p_ext_rcd_id => g_ext_dtl_rcd_id
,p_ext_data_element_name => 'Pay US SRS - Detail Assignment Type'
,p_data_element_value => p_record_name
,p_ext_dtl_rec => l_new_rec);
Procedure Update_Record_Values ( p_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
,p_ext_data_element_name In ben_ext_data_elmt.name%TYPE
,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE
,p_data_ele_seqnum In Number
,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE
) Is
Cursor csr_seqnum ( c_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
,c_ext_data_element_name In ben_ext_data_elmt.name%TYPE
) Is
select der.ext_data_elmt_id,
der.seq_num,
ede.name
from ben_ext_data_elmt_in_rcd der
,ben_ext_data_elmt ede
where der.ext_rcd_id = c_ext_rcd_id
and ede.ext_data_elmt_id = der.ext_data_elmt_id
and ede.name like '%'|| c_ext_data_element_name
order by seq_num;
l_proc_name varchar2(150):= g_proc_name||'Update_Record_Values';
End Update_Record_Values;
SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
hr_utility.set_location('.....Inserting into ben_ext_rslt_dtl table...' , 15);
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
,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_dtl_rec.VAL_01
,p_dtl_rec.VAL_02
,p_dtl_rec.VAL_03
,p_dtl_rec.VAL_04
,p_dtl_rec.VAL_05
,p_dtl_rec.VAL_06
,p_dtl_rec.VAL_07
,p_dtl_rec.VAL_08
,p_dtl_rec.VAL_09
,p_dtl_rec.VAL_10
,p_dtl_rec.VAL_11
,p_dtl_rec.VAL_12
,p_dtl_rec.VAL_13
,p_dtl_rec.VAL_14
,p_dtl_rec.VAL_15
,p_dtl_rec.VAL_16
,p_dtl_rec.VAL_17
,p_dtl_rec.VAL_19
,p_dtl_rec.VAL_18
,p_dtl_rec.VAL_20
,p_dtl_rec.VAL_21
,p_dtl_rec.VAL_22
,p_dtl_rec.VAL_23
,p_dtl_rec.VAL_24
,p_dtl_rec.VAL_25
,p_dtl_rec.VAL_26
,p_dtl_rec.VAL_27
,p_dtl_rec.VAL_28
,p_dtl_rec.VAL_29
,p_dtl_rec.VAL_30
,p_dtl_rec.VAL_31
,p_dtl_rec.VAL_32
,p_dtl_rec.VAL_33
,p_dtl_rec.VAL_34
,p_dtl_rec.VAL_35
,p_dtl_rec.VAL_36
,p_dtl_rec.VAL_37
,p_dtl_rec.VAL_38
,p_dtl_rec.VAL_39
,p_dtl_rec.VAL_40
,p_dtl_rec.VAL_41
,p_dtl_rec.VAL_42
,p_dtl_rec.VAL_43
,p_dtl_rec.VAL_44
,p_dtl_rec.VAL_45
,p_dtl_rec.VAL_46
,p_dtl_rec.VAL_47
,p_dtl_rec.VAL_48
,p_dtl_rec.VAL_49
,p_dtl_rec.VAL_50
,p_dtl_rec.VAL_51
,p_dtl_rec.VAL_52
,p_dtl_rec.VAL_53
,p_dtl_rec.VAL_54
,p_dtl_rec.VAL_55
,p_dtl_rec.VAL_56
,p_dtl_rec.VAL_57
,p_dtl_rec.VAL_58
,p_dtl_rec.VAL_59
,p_dtl_rec.VAL_60
,p_dtl_rec.VAL_61
,p_dtl_rec.VAL_62
,p_dtl_rec.VAL_63
,p_dtl_rec.VAL_64
,p_dtl_rec.VAL_65
,p_dtl_rec.VAL_66
,p_dtl_rec.VAL_67
,p_dtl_rec.VAL_68
,p_dtl_rec.VAL_69
,p_dtl_rec.VAL_70
,p_dtl_rec.VAL_71
,p_dtl_rec.VAL_72
,p_dtl_rec.VAL_73
,p_dtl_rec.VAL_74
,p_dtl_rec.VAL_75
,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
);
UPDATE ben_ext_rslt_dtl
SET VAL_01 = p_dtl_rec.VAL_01
,VAL_02 = p_dtl_rec.VAL_02
,VAL_03 = p_dtl_rec.VAL_03
,VAL_04 = p_dtl_rec.VAL_04
,VAL_05 = p_dtl_rec.VAL_05
,VAL_06 = p_dtl_rec.VAL_06
,VAL_07 = p_dtl_rec.VAL_07
,VAL_08 = p_dtl_rec.VAL_08
,VAL_09 = p_dtl_rec.VAL_09
,VAL_10 = p_dtl_rec.VAL_10
,VAL_11 = p_dtl_rec.VAL_11
,VAL_12 = p_dtl_rec.VAL_12
,VAL_13 = p_dtl_rec.VAL_13
,VAL_14 = p_dtl_rec.VAL_14
,VAL_15 = p_dtl_rec.VAL_15
,VAL_16 = p_dtl_rec.VAL_16
,VAL_17 = p_dtl_rec.VAL_17
,VAL_19 = p_dtl_rec.VAL_19
,VAL_18 = p_dtl_rec.VAL_18
,VAL_20 = p_dtl_rec.VAL_20
,VAL_21 = p_dtl_rec.VAL_21
,VAL_22 = p_dtl_rec.VAL_22
,VAL_23 = p_dtl_rec.VAL_23
,VAL_24 = p_dtl_rec.VAL_24
,VAL_25 = p_dtl_rec.VAL_25
,VAL_26 = p_dtl_rec.VAL_26
,VAL_27 = p_dtl_rec.VAL_27
,VAL_28 = p_dtl_rec.VAL_28
,VAL_29 = p_dtl_rec.VAL_29
,VAL_30 = p_dtl_rec.VAL_30
,VAL_31 = p_dtl_rec.VAL_31
,VAL_32 = p_dtl_rec.VAL_32
,VAL_33 = p_dtl_rec.VAL_33
,VAL_34 = p_dtl_rec.VAL_34
,VAL_35 = p_dtl_rec.VAL_35
,VAL_36 = p_dtl_rec.VAL_36
,VAL_37 = p_dtl_rec.VAL_37
,VAL_38 = p_dtl_rec.VAL_38
,VAL_39 = p_dtl_rec.VAL_39
,VAL_40 = p_dtl_rec.VAL_40
,VAL_41 = p_dtl_rec.VAL_41
,VAL_42 = p_dtl_rec.VAL_42
,VAL_43 = p_dtl_rec.VAL_43
,VAL_44 = p_dtl_rec.VAL_44
,VAL_45 = p_dtl_rec.VAL_45
,VAL_46 = p_dtl_rec.VAL_46
,VAL_47 = p_dtl_rec.VAL_47
,VAL_48 = p_dtl_rec.VAL_48
,VAL_49 = p_dtl_rec.VAL_49
,VAL_50 = p_dtl_rec.VAL_50
,VAL_51 = p_dtl_rec.VAL_51
,VAL_52 = p_dtl_rec.VAL_52
,VAL_53 = p_dtl_rec.VAL_53
,VAL_54 = p_dtl_rec.VAL_54
,VAL_55 = p_dtl_rec.VAL_55
,VAL_56 = p_dtl_rec.VAL_56
,VAL_57 = p_dtl_rec.VAL_57
,VAL_58 = p_dtl_rec.VAL_58
,VAL_59 = p_dtl_rec.VAL_59
,VAL_60 = p_dtl_rec.VAL_60
,VAL_61 = p_dtl_rec.VAL_61
,VAL_62 = p_dtl_rec.VAL_62
,VAL_63 = p_dtl_rec.VAL_63
,VAL_64 = p_dtl_rec.VAL_64
,VAL_65 = p_dtl_rec.VAL_65
,VAL_66 = p_dtl_rec.VAL_66
,VAL_67 = p_dtl_rec.VAL_67
,VAL_68 = p_dtl_rec.VAL_68
,VAL_69 = p_dtl_rec.VAL_69
,VAL_70 = p_dtl_rec.VAL_70
,VAL_71 = p_dtl_rec.VAL_71
,VAL_72 = p_dtl_rec.VAL_72
,VAL_73 = p_dtl_rec.VAL_73
,VAL_74 = p_dtl_rec.VAL_74
,VAL_75 = p_dtl_rec.VAL_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;
Delete
From ben_ext_rslt_dtl dtl
Where dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
And dtl.ext_rcd_id = l_ext_dtl_rcd_id
And business_group_id = p_business_group_id
And dtl.val_01 In ( 'SEC_ASSIGN_FOUND','SEC_ASSIGN_NOTFOUND' );