DBA Data[Home] [Help]

APPS.BEN_HWF_SHD SQL Statements

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

Line: 68

    select
		hrs_wkd_in_perd_fctr_id,
	name,
	business_group_id,
	hrs_src_cd,
	rndg_cd,
	rndg_rl,
	hrs_wkd_det_cd,
	hrs_wkd_det_rl,
	no_mn_hrs_wkd_flag,
	mx_hrs_num,
	no_mx_hrs_wkd_flag,
	once_r_cntug_cd,
	mn_hrs_num,
        hrs_alt_val_to_use_cd,
        pyrl_freq_cd,
        hrs_wkd_calc_rl,
        defined_balance_id,
        bnfts_bal_id,
	hwf_attribute_category,
	hwf_attribute1,
	hwf_attribute2,
	hwf_attribute3,
	hwf_attribute4,
	hwf_attribute5,
	hwf_attribute6,
	hwf_attribute7,
	hwf_attribute8,
	hwf_attribute9,
	hwf_attribute10,
	hwf_attribute11,
	hwf_attribute12,
	hwf_attribute13,
	hwf_attribute14,
	hwf_attribute15,
	hwf_attribute16,
	hwf_attribute17,
	hwf_attribute18,
	hwf_attribute19,
	hwf_attribute20,
	hwf_attribute21,
	hwf_attribute22,
	hwf_attribute23,
	hwf_attribute24,
	hwf_attribute25,
	hwf_attribute26,
	hwf_attribute27,
	hwf_attribute28,
	hwf_attribute29,
	hwf_attribute30,
	object_version_number
    from	ben_hrs_wkd_in_perd_fctr
    where	hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id;
Line: 188

    select 	hrs_wkd_in_perd_fctr_id,
	name,
	business_group_id,
	hrs_src_cd,
	rndg_cd,
	rndg_rl,
	hrs_wkd_det_cd,
	hrs_wkd_det_rl,
	no_mn_hrs_wkd_flag,
	mx_hrs_num,
	no_mx_hrs_wkd_flag,
	once_r_cntug_cd,
	mn_hrs_num,
        hrs_alt_val_to_use_cd,
        pyrl_freq_cd,
        hrs_wkd_calc_rl,
        defined_balance_id,
        bnfts_bal_id,
	hwf_attribute_category,
	hwf_attribute1,
	hwf_attribute2,
	hwf_attribute3,
	hwf_attribute4,
	hwf_attribute5,
	hwf_attribute6,
	hwf_attribute7,
	hwf_attribute8,
	hwf_attribute9,
	hwf_attribute10,
	hwf_attribute11,
	hwf_attribute12,
	hwf_attribute13,
	hwf_attribute14,
	hwf_attribute15,
	hwf_attribute16,
	hwf_attribute17,
	hwf_attribute18,
	hwf_attribute19,
	hwf_attribute20,
	hwf_attribute21,
	hwf_attribute22,
	hwf_attribute23,
	hwf_attribute24,
	hwf_attribute25,
	hwf_attribute26,
	hwf_attribute27,
	hwf_attribute28,
	hwf_attribute29,
	hwf_attribute30,
	object_version_number
    from	ben_hrs_wkd_in_perd_fctr
    where	hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id
    for	update nowait;