APPS.BEN_BENLESUM_XMLP_PKG SQL Statements

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

Line: 16

Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_REPT_MODL_CD' and lookup_code = p_report_module_cd;

Line: 19

Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_ASG_TYPE' and lookup_code = p_assignment_type;

Line: 22

Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_LER_TYPE' and lookup_code = p_ler_type;

Line: 25

select hr_general.decode_organization(p_organization_id),hr_general.decode_location(p_location_id),hr_general.decode_organization(p_business_group_id) from dual;

Line: 28

Select name from BEN_BENFTS_GRP where benfts_grp_id=p_benefit_group_id and business_group_id=p_business_group_id;

Line: 31

Select tl.name from ben_rptg_grp rpt,ben_rptg_grp_tl tl where rpt.rptg_grp_id=p_reporting_group_id and business_group_id=p_business_group_id and rpt.rptg_grp_id=tl.rptg_grp_id
and tl.language=userenv('LANG');

Line: 35

Select tl.name from ben_ler_f ler, ben_ler_f_tl tl
	where
	ler.ler_id = tl.ler_id and
	ler.effective_start_date = tl.effective_start_date and
	tl.language = userenv('LANG') and
	ler.ler_id=p_ler_id and business_group_id=p_business_group_id;

Line: 43

Select full_name from per_all_people_f where person_id=p_person_id and business_group_id=p_business_group_id;

Line: 46

Select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_disp_flex_fields_flag;

Line: 201

			cursor c_pl is select null from ben_popl_rptg_grp_f rgr
				where rgr.rptg_grp_id = p_reporting_group_id
				and rgr.pl_id=p_pl_id
				and p_run_date between rgr.effective_start_date and rgr.effective_end_date;

Line: 205

			cursor c_rpt_grp is Select tl.name from ben_rptg_grp rpt,ben_rptg_grp_tl tl
				where rpt.rptg_grp_id=p_reporting_group_id and
				business_group_id=p_business_group_id and rpt.rptg_grp_id=tl.rptg_grp_id
				and tl.language=userenv('LANG');