eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BFT_SHD SQL Statements

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

Line: 66


    select
	benefit_action_id,
	process_date,
	uneai_effective_date,
	mode_cd,
	derivable_factors_flag,
	close_uneai_flag,
	validate_flag,
	person_id,
	person_type_id,
	pgm_id,
	business_group_id,
	pl_id,
	popl_enrt_typ_cycl_id,
	no_programs_flag,
	no_plans_flag,
	comp_selection_rl,
	person_selection_rl,
	ler_id,
	organization_id,
	benfts_grp_id,
	location_id,
	pstl_zip_rng_id,
	rptg_grp_id,
	pl_typ_id,
	opt_id,
	eligy_prfl_id,
	vrbl_rt_prfl_id,
	legal_entity_id,
	payroll_id,
	debug_messages_flag,
  cm_trgr_typ_cd,
  cm_typ_id,
  age_fctr_id,
  min_age,
  max_age,
  los_fctr_id,
  min_los,
  max_los,
  cmbn_age_los_fctr_id,
  min_cmbn,
  max_cmbn,
  date_from,
  elig_enrol_cd,
  actn_typ_id,
  use_fctr_to_sel_flag,
  los_det_to_use_cd,
  audit_log_flag,
  lmt_prpnip_by_org_flag,
  lf_evt_ocrd_dt,
  ptnl_ler_for_per_stat_cd,
	bft_attribute_category,
	bft_attribute1,
	bft_attribute3,
	bft_attribute4,
	bft_attribute5,
	bft_attribute6,
	bft_attribute7,
	bft_attribute8,
	bft_attribute9,
	bft_attribute10,
	bft_attribute11,
	bft_attribute12,
	bft_attribute13,
	bft_attribute14,
	bft_attribute15,
	bft_attribute16,
	bft_attribute17,
	bft_attribute18,
	bft_attribute19,
	bft_attribute20,
	bft_attribute21,
	bft_attribute22,
	bft_attribute23,
	bft_attribute24,
	bft_attribute25,
	bft_attribute26,
	bft_attribute27,
	bft_attribute28,
	bft_attribute29,
	bft_attribute30,
  request_id,
  program_application_id,
  program_id,
  program_update_date,
	object_version_number,
	enrt_perd_id,
	inelg_action_cd,
	org_hierarchy_id,
	org_starting_node_id,
	grade_ladder_id,
	asg_events_to_all_sel_dt,
	rate_id,
	per_sel_dt_cd,
	per_sel_freq_cd,
	per_sel_dt_from,
	per_sel_dt_to,
	year_from,
	year_to,
	cagr_id,
	qual_type,
	qual_status,
	concat_segs,
  grant_price_val
  from	ben_benefit_actions
    where	benefit_action_id = p_benefit_action_id;

Line: 239


    select 	benefit_action_id,
	process_date,
	uneai_effective_date,
	mode_cd,
	derivable_factors_flag,
	close_uneai_flag,
	validate_flag,
	person_id,
	person_type_id,
	pgm_id,
	business_group_id,
	pl_id,
	popl_enrt_typ_cycl_id,
	no_programs_flag,
	no_plans_flag,
	comp_selection_rl,
	person_selection_rl,
	ler_id,
	organization_id,
	benfts_grp_id,
	location_id,
	pstl_zip_rng_id,
	rptg_grp_id,
	pl_typ_id,
	opt_id,
	eligy_prfl_id,
	vrbl_rt_prfl_id,
	legal_entity_id,
	payroll_id,
	debug_messages_flag,
  cm_trgr_typ_cd,
  cm_typ_id,
  age_fctr_id,
  min_age,
  max_age,
  los_fctr_id,
  min_los,
  max_los,
  cmbn_age_los_fctr_id,
  min_cmbn,
  max_cmbn,
  date_from,
  elig_enrol_cd,
  actn_typ_id,
  use_fctr_to_sel_flag,
  los_det_to_use_cd,
  audit_log_flag,
  lmt_prpnip_by_org_flag,
  lf_evt_ocrd_dt,
  ptnl_ler_for_per_stat_cd,
	bft_attribute_category,
	bft_attribute1,
	bft_attribute3,
	bft_attribute4,
	bft_attribute5,
	bft_attribute6,
	bft_attribute7,
	bft_attribute8,
	bft_attribute9,
	bft_attribute10,
	bft_attribute11,
	bft_attribute12,
	bft_attribute13,
	bft_attribute14,
	bft_attribute15,
	bft_attribute16,
	bft_attribute17,
	bft_attribute18,
	bft_attribute19,
	bft_attribute20,
	bft_attribute21,
	bft_attribute22,
	bft_attribute23,
	bft_attribute24,
	bft_attribute25,
	bft_attribute26,
	bft_attribute27,
	bft_attribute28,
	bft_attribute29,
	bft_attribute30,
  request_id,
  program_application_id,
  program_id,
  program_update_date,
	object_version_number,
	enrt_perd_id,
	inelg_action_cd,
	org_hierarchy_id,
	org_starting_node_id,
	grade_ladder_id,
	asg_events_to_all_sel_dt,
	rate_id,
	per_sel_dt_cd,
	per_sel_freq_cd,
	per_sel_dt_from,
	per_sel_dt_to,
	year_from,
	year_to,
	cagr_id,
	qual_type,
	qual_status,
	concat_segs,
  grant_price_val
    from	ben_benefit_actions
    where	benefit_action_id = p_benefit_action_id
    for	update nowait;

Line: 409


	p_comp_selection_rl             in number,
	p_person_selection_rl           in number,
	p_ler_id                        in number,
	p_organization_id               in number,
	p_benfts_grp_id                 in number,
	p_location_id                   in number,
	p_pstl_zip_rng_id               in number,
	p_rptg_grp_id                   in number,
	p_pl_typ_id                     in number,
	p_opt_id                        in number,
	p_eligy_prfl_id                 in number,
	p_vrbl_rt_prfl_id               in number,
	p_legal_entity_id               in number,
	p_payroll_id                    in number,
	p_debug_messages_flag           in varchar2,
  p_cm_trgr_typ_cd                in varchar2,
  p_cm_typ_id                     in number,
  p_age_fctr_id                   in number,
  p_min_age                       in number,
  p_max_age                       in number,
  p_los_fctr_id                   in number,
  p_min_los                       in number,
  p_max_los                       in number,
  p_cmbn_age_los_fctr_id          in number,
  p_min_cmbn                      in number,
  p_max_cmbn                      in number,
  p_date_from                     in date,
  p_elig_enrol_cd                 in varchar2,
  p_actn_typ_id                   in number,
  p_use_fctr_to_sel_flag          in varchar2,
  p_los_det_to_use_cd             in varchar2,
  p_audit_log_flag                in varchar2,
  p_lmt_prpnip_by_org_flag        in varchar2,
  p_lf_evt_ocrd_dt                in date,
  p_ptnl_ler_for_per_stat_cd      in varchar2,
	p_bft_attribute_category        in varchar2,
	p_bft_attribute1                in varchar2,
	p_bft_attribute3                in varchar2,
	p_bft_attribute4                in varchar2,
	p_bft_attribute5                in varchar2,
	p_bft_attribute6                in varchar2,
	p_bft_attribute7                in varchar2,
	p_bft_attribute8                in varchar2,
	p_bft_attribute9                in varchar2,
	p_bft_attribute10               in varchar2,
	p_bft_attribute11               in varchar2,
	p_bft_attribute12               in varchar2,
	p_bft_attribute13               in varchar2,
	p_bft_attribute14               in varchar2,
	p_bft_attribute15               in varchar2,
	p_bft_attribute16               in varchar2,
	p_bft_attribute17               in varchar2,
	p_bft_attribute18               in varchar2,
	p_bft_attribute19               in varchar2,
	p_bft_attribute20               in varchar2,
	p_bft_attribute21               in varchar2,
	p_bft_attribute22               in varchar2,
	p_bft_attribute23               in varchar2,
	p_bft_attribute24               in varchar2,
	p_bft_attribute25               in varchar2,
	p_bft_attribute26               in varchar2,
	p_bft_attribute27               in varchar2,
	p_bft_attribute28               in varchar2,
	p_bft_attribute29               in varchar2,
	p_bft_attribute30               in varchar2,
  p_request_id                    in number,
  p_program_application_id        in number,
  p_program_id                    in number,
  p_program_update_date           in date,
	p_object_version_number         in number,
	p_enrt_perd_id                  in number,
	p_inelg_action_cd               in varchar2,
	p_org_hierarchy_id               in number ,
	p_org_starting_node_id               in number,
	p_grade_ladder_id               in number,
	p_asg_events_to_all_sel_dt               in varchar2,
	p_rate_id               in number,
	p_per_sel_dt_cd               in varchar2,
	p_per_sel_freq_cd               in varchar2,
	p_per_sel_dt_from               in date,
	p_per_sel_dt_to               in date,
	p_year_from               in number,
	p_year_to               in number,
	p_cagr_id               in number,
	p_qual_type               in number,
	p_qual_status               in varchar2,
	p_concat_segs               in varchar2,
  p_grant_price_val               in number
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 524


  l_rec.comp_selection_rl                := p_comp_selection_rl;

Line: 525


  l_rec.person_selection_rl              := p_person_selection_rl;

Line: 592


  l_rec.program_update_date              := p_program_update_date;