DBA Data[Home] [Help]

APPS.BEN_XCL_SHD SQL Statements

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

Line: 64

    select
	ext_chg_evt_log_id,
	chg_evt_cd,
	chg_eff_dt,
	chg_user_id,
	prmtr_01,
	prmtr_02,
	prmtr_03,
	prmtr_04,
	prmtr_05,
	prmtr_06,
	prmtr_07,
	prmtr_08,
	prmtr_09,
	prmtr_10,
	person_id,
	business_group_id,
	object_version_number,
        chg_actl_dt,
        new_val1,
        new_val2,
        new_val3,
        new_val4,
        new_val5,
        new_val6,
        old_val1,
        old_val2,
        old_val3,
        old_val4,
        old_val5,
        old_val6
    from	ben_ext_chg_evt_log
    where	ext_chg_evt_log_id = p_ext_chg_evt_log_id;
Line: 164

    select
	ext_chg_evt_log_id,
	chg_evt_cd,
	chg_eff_dt,
	chg_user_id,
	prmtr_01,
	prmtr_02,
	prmtr_03,
	prmtr_04,
	prmtr_05,
	prmtr_06,
	prmtr_07,
	prmtr_08,
	prmtr_09,
	prmtr_10,
	person_id,
	business_group_id,
	object_version_number,
        chg_actl_dt,
        new_val1,
        new_val2,
        new_val3,
        new_val4,
        new_val5,
        new_val6,
        old_val1,
        old_val2,
        old_val3,
        old_val4,
        old_val5,
        old_val6
    from	ben_ext_chg_evt_log
    where	ext_chg_evt_log_id = p_ext_chg_evt_log_id
    for	update nowait;