APPS.BEN_VPF_RKI SQL Statements

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

Line: 5

procedure AFTER_INSERT
(P_VRBL_RT_PRFL_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_PL_TYP_OPT_TYP_ID in NUMBER
,P_PL_ID in NUMBER
,P_OIPL_ID in NUMBER
,P_COMP_LVL_FCTR_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_ACTY_TYP_CD in VARCHAR2
,P_RT_TYP_CD in VARCHAR2
,P_BNFT_RT_TYP_CD in VARCHAR2
,P_TX_TYP_CD in VARCHAR2
,P_VRBL_RT_TRTMT_CD in VARCHAR2
,P_ACTY_REF_PERD_CD in VARCHAR2
,P_MLT_CD in VARCHAR2
,P_INCRMNT_ELCN_VAL in NUMBER
,P_DFLT_ELCN_VAL in NUMBER
,P_MX_ELCN_VAL in NUMBER
,P_MN_ELCN_VAL in NUMBER
,P_LWR_LMT_VAL in NUMBER
,P_LWR_LMT_CALC_RL in NUMBER
,P_UPR_LMT_VAL in NUMBER
,P_UPR_LMT_CALC_RL in NUMBER
,P_ULTMT_UPR_LMT in NUMBER
,P_ULTMT_LWR_LMT in NUMBER
,P_ULTMT_UPR_LMT_CALC_RL in NUMBER
,P_ULTMT_LWR_LMT_CALC_RL in NUMBER
,P_ANN_MN_ELCN_VAL in NUMBER
,P_ANN_MX_ELCN_VAL in NUMBER
,P_VAL in NUMBER
,P_NAME in VARCHAR2
,P_NO_MN_ELCN_VAL_DFND_FLAG in VARCHAR2
,P_NO_MX_ELCN_VAL_DFND_FLAG in VARCHAR2
,P_ALWYS_SUM_ALL_CVG_FLAG in VARCHAR2
,P_ALWYS_CNT_ALL_PRTTS_FLAG in VARCHAR2
,P_VAL_CALC_RL in NUMBER
,P_VRBL_RT_PRFL_STAT_CD in VARCHAR2
,P_VRBL_USG_CD in VARCHAR2
,P_ASMT_TO_USE_CD in VARCHAR2
,P_RNDG_CD in VARCHAR2
,P_RNDG_RL in NUMBER
,P_RT_HRLY_SLRD_FLAG in VARCHAR2
,P_RT_PSTL_CD_FLAG in VARCHAR2
,P_RT_LBR_MMBR_FLAG in VARCHAR2
,P_RT_LGL_ENTY_FLAG in VARCHAR2
,P_RT_BENFTS_GRP_FLAG in VARCHAR2
,P_RT_WK_LOC_FLAG in VARCHAR2
,P_RT_BRGNG_UNIT_FLAG in VARCHAR2
,P_RT_AGE_FLAG in VARCHAR2
,P_RT_LOS_FLAG in VARCHAR2
,P_RT_PER_TYP_FLAG in VARCHAR2
,P_RT_FL_TM_PT_TM_FLAG in VARCHAR2
,P_RT_EE_STAT_FLAG in VARCHAR2
,P_RT_GRD_FLAG in VARCHAR2
,P_RT_PCT_FL_TM_FLAG in VARCHAR2
,P_RT_ASNT_SET_FLAG in VARCHAR2
,P_RT_HRS_WKD_FLAG in VARCHAR2
,P_RT_COMP_LVL_FLAG in VARCHAR2
,P_RT_ORG_UNIT_FLAG in VARCHAR2
,P_RT_LOA_RSN_FLAG in VARCHAR2
,P_RT_PYRL_FLAG in VARCHAR2
,P_RT_SCHEDD_HRS_FLAG in VARCHAR2
,P_RT_PY_BSS_FLAG in VARCHAR2
,P_RT_PRFL_RL_FLAG in VARCHAR2
,P_RT_CMBN_AGE_LOS_FLAG in VARCHAR2
,P_RT_PRTT_PL_FLAG in VARCHAR2
,P_RT_SVC_AREA_FLAG in VARCHAR2
,P_RT_PPL_GRP_FLAG in VARCHAR2
,P_RT_DSBLD_FLAG in VARCHAR2
,P_RT_HLTH_CVG_FLAG in VARCHAR2
,P_RT_POE_FLAG in VARCHAR2
,P_RT_TTL_CVG_VOL_FLAG in VARCHAR2
,P_RT_TTL_PRTT_FLAG in VARCHAR2
,P_RT_GNDR_FLAG in VARCHAR2
,P_RT_TBCO_USE_FLAG in VARCHAR2
,P_VPF_ATTRIBUTE_CATEGORY in VARCHAR2
,P_VPF_ATTRIBUTE1 in VARCHAR2
,P_VPF_ATTRIBUTE2 in VARCHAR2
,P_VPF_ATTRIBUTE3 in VARCHAR2
,P_VPF_ATTRIBUTE4 in VARCHAR2
,P_VPF_ATTRIBUTE5 in VARCHAR2
,P_VPF_ATTRIBUTE6 in VARCHAR2
,P_VPF_ATTRIBUTE7 in VARCHAR2
,P_VPF_ATTRIBUTE8 in VARCHAR2
,P_VPF_ATTRIBUTE9 in VARCHAR2
,P_VPF_ATTRIBUTE10 in VARCHAR2
,P_VPF_ATTRIBUTE11 in VARCHAR2
,P_VPF_ATTRIBUTE12 in VARCHAR2
,P_VPF_ATTRIBUTE13 in VARCHAR2
,P_VPF_ATTRIBUTE14 in VARCHAR2
,P_VPF_ATTRIBUTE15 in VARCHAR2
,P_VPF_ATTRIBUTE16 in VARCHAR2
,P_VPF_ATTRIBUTE17 in VARCHAR2
,P_VPF_ATTRIBUTE18 in VARCHAR2
,P_VPF_ATTRIBUTE19 in VARCHAR2
,P_VPF_ATTRIBUTE20 in VARCHAR2
,P_VPF_ATTRIBUTE21 in VARCHAR2
,P_VPF_ATTRIBUTE22 in VARCHAR2
,P_VPF_ATTRIBUTE23 in VARCHAR2
,P_VPF_ATTRIBUTE24 in VARCHAR2
,P_VPF_ATTRIBUTE25 in VARCHAR2
,P_VPF_ATTRIBUTE26 in VARCHAR2
,P_VPF_ATTRIBUTE27 in VARCHAR2
,P_VPF_ATTRIBUTE28 in VARCHAR2
,P_VPF_ATTRIBUTE29 in VARCHAR2
,P_VPF_ATTRIBUTE30 in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
,P_RT_CNTNG_PRTN_PRFL_FLAG in VARCHAR2
,P_RT_CBR_QUALD_BNF_FLAG in VARCHAR2
,P_RT_OPTD_MDCR_FLAG in VARCHAR2
,P_RT_LVG_RSN_FLAG in VARCHAR2
,P_RT_PSTN_FLAG in VARCHAR2
,P_RT_COMPTNCY_FLAG in VARCHAR2
,P_RT_JOB_FLAG in VARCHAR2
,P_RT_QUAL_TITL_FLAG in VARCHAR2
,P_RT_DPNT_CVRD_PL_FLAG in VARCHAR2
,P_RT_DPNT_CVRD_PLIP_FLAG in VARCHAR2
,P_RT_DPNT_CVRD_PTIP_FLAG in VARCHAR2
,P_RT_DPNT_CVRD_PGM_FLAG in VARCHAR2
,P_RT_ENRLD_OIPL_FLAG in VARCHAR2
,P_RT_ENRLD_PL_FLAG in VARCHAR2
,P_RT_ENRLD_PLIP_FLAG in VARCHAR2
,P_RT_ENRLD_PTIP_FLAG in VARCHAR2
,P_RT_ENRLD_PGM_FLAG in VARCHAR2
,P_RT_PRTT_ANTHR_PL_FLAG in VARCHAR2
,P_RT_OTHR_PTIP_FLAG in VARCHAR2
,P_RT_NO_OTHR_CVG_FLAG in VARCHAR2
,P_RT_DPNT_OTHR_PTIP_FLAG in VARCHAR2
,P_RT_QUA_IN_GR_FLAG in VARCHAR2
,P_RT_PERF_RTNG_FLAG in VARCHAR2
,P_RT_ELIG_PRFL_FLAG in VARCHAR2
)is
begin
hr_utility.set_location('Entering: ben_vpf_RKI.AFTER_INSERT', 10);

Line: 143

hr_utility.set_location(' Leaving: ben_vpf_RKI.AFTER_INSERT', 20);

Line: 144

end AFTER_INSERT;