APPS.BEN_PIL_SHD SQL Statements

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

Line: 64

    select
		per_in_ler_id,
	per_in_ler_stat_cd,
	prvs_stat_cd,
	lf_evt_ocrd_dt,
        trgr_table_pk_id, --ABSE changes
	procd_dt,
	strtd_dt,
	voidd_dt,
	bckt_dt,
	clsd_dt,
	ntfn_dt,
	ptnl_ler_for_per_id,
	bckt_per_in_ler_id,
	ler_id,
	person_id,
	business_group_id,
        ASSIGNMENT_ID,
        WS_MGR_ID,
        GROUP_PL_ID,
        MGR_OVRID_PERSON_ID,
        MGR_OVRID_DT,
	pil_attribute_category,
	pil_attribute1,
	pil_attribute2,
	pil_attribute3,
	pil_attribute4,
	pil_attribute5,
	pil_attribute6,
	pil_attribute7,
	pil_attribute8,
	pil_attribute9,
	pil_attribute10,
	pil_attribute11,
	pil_attribute12,
	pil_attribute13,
	pil_attribute14,
	pil_attribute15,
	pil_attribute16,
	pil_attribute17,
	pil_attribute18,
	pil_attribute19,
	pil_attribute20,
	pil_attribute21,
	pil_attribute22,
	pil_attribute23,
	pil_attribute24,
	pil_attribute25,
	pil_attribute26,
	pil_attribute27,
	pil_attribute28,
	pil_attribute29,
	pil_attribute30,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	object_version_number
    from	ben_per_in_ler
    where	per_in_ler_id = p_per_in_ler_id;

Line: 191

    select 	per_in_ler_id,
	per_in_ler_stat_cd,
	prvs_stat_cd      ,
	lf_evt_ocrd_dt,
        trgr_table_pk_id, --ABSE change
	procd_dt,
	strtd_dt,
	voidd_dt,
	bckt_dt,
	clsd_dt,
	ntfn_dt,
	ptnl_ler_for_per_id,
	bckt_per_in_ler_id,
	ler_id,
	person_id,
	business_group_id,
        ASSIGNMENT_ID,
        WS_MGR_ID,
        GROUP_PL_ID,
        MGR_OVRID_PERSON_ID,
        MGR_OVRID_DT,
	pil_attribute_category,
	pil_attribute1,
	pil_attribute2,
	pil_attribute3,
	pil_attribute4,
	pil_attribute5,
	pil_attribute6,
	pil_attribute7,
	pil_attribute8,
	pil_attribute9,
	pil_attribute10,
	pil_attribute11,
	pil_attribute12,
	pil_attribute13,
	pil_attribute14,
	pil_attribute15,
	pil_attribute16,
	pil_attribute17,
	pil_attribute18,
	pil_attribute19,
	pil_attribute20,
	pil_attribute21,
	pil_attribute22,
	pil_attribute23,
	pil_attribute24,
	pil_attribute25,
	pil_attribute26,
	pil_attribute27,
	pil_attribute28,
	pil_attribute29,
	pil_attribute30,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	object_version_number
    from	ben_per_in_ler
    where	per_in_ler_id = p_per_in_ler_id
    for	update nowait;

Line: 355

	p_program_update_date           in date,
	p_object_version_number         in number
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 424

  l_rec.program_update_date              := p_program_update_date;