APPS.BEN_RTS_RKD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

procedure AFTER_DELETE
(P_PERSON_RATE_ID in NUMBER
,P_GROUP_PER_IN_LER_ID_O in NUMBER
,P_PL_ID_O in NUMBER
,P_OIPL_ID_O in NUMBER
,P_GROUP_PL_ID_O in NUMBER
,P_GROUP_OIPL_ID_O in NUMBER
,P_LF_EVT_OCRD_DT_O in DATE
,P_PERSON_ID_O in NUMBER
,P_ASSIGNMENT_ID_O in NUMBER
,P_ELIG_FLAG_O in VARCHAR2
,P_WS_VAL_O in NUMBER
,P_WS_MN_VAL_O in NUMBER
,P_WS_MX_VAL_O in NUMBER
,P_WS_INCR_VAL_O in NUMBER
,P_ELIG_SAL_VAL_O in NUMBER
,P_STAT_SAL_VAL_O in NUMBER
,P_OTH_COMP_VAL_O in NUMBER
,P_TOT_COMP_VAL_O in NUMBER
,P_MISC1_VAL_O in NUMBER
,P_MISC2_VAL_O in NUMBER
,P_MISC3_VAL_O in NUMBER
,P_REC_VAL_O in NUMBER
,P_REC_MN_VAL_O in NUMBER
,P_REC_MX_VAL_O in NUMBER
,P_REC_INCR_VAL_O in NUMBER
,P_WS_VAL_LAST_UPD_DATE_O in DATE
,P_WS_VAL_LAST_UPD_BY_O in NUMBER
,P_PAY_PROPOSAL_ID_O in NUMBER
,P_ELEMENT_ENTRY_VALUE_ID_O in NUMBER
,P_INELIG_RSN_CD_O in VARCHAR2
,P_ELIG_OVRID_DT_O in DATE
,P_ELIG_OVRID_PERSON_ID_O in NUMBER
,P_COPY_DIST_BDGT_VAL_O in NUMBER
,P_COPY_WS_BDGT_VAL_O in NUMBER
,P_COPY_RSRV_VAL_O in NUMBER
,P_COPY_DIST_BDGT_MN_VAL_O in NUMBER
,P_COPY_DIST_BDGT_MX_VAL_O in NUMBER
,P_COPY_DIST_BDGT_INCR_VAL_O in NUMBER
,P_COPY_WS_BDGT_MN_VAL_O in NUMBER
,P_COPY_WS_BDGT_MX_VAL_O in NUMBER
,P_COPY_WS_BDGT_INCR_VAL_O in NUMBER
,P_COPY_RSRV_MN_VAL_O in NUMBER
,P_COPY_RSRV_MX_VAL_O in NUMBER
,P_COPY_RSRV_INCR_VAL_O in NUMBER
,P_COPY_DIST_BDGT_ISS_VAL_O in NUMBER
,P_COPY_WS_BDGT_ISS_VAL_O in NUMBER
,P_COPY_DIST_BDGT_ISS_DATE_O in DATE
,P_COPY_WS_BDGT_ISS_DATE_O in DATE
,P_COMP_POSTING_DATE_O in DATE
,P_WS_RT_START_DATE_O in DATE
,P_CURRENCY_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: BEN_RTS_RKD.AFTER_DELETE', 10);

Line: 61

hr_utility.set_location(' Leaving: BEN_RTS_RKD.AFTER_DELETE', 20);

Line: 62

end AFTER_DELETE;