APPS.HXC_HXCMISTC_XMLP_PKG SQL Statements

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

Line: 37

select ppf.full_name, nvl(ppf.employee_number, ppf.npw_number)
from per_people_f ppf
where ppf.person_id = cp_person_id
and cp_effective_date between ppf.effective_start_date
			 and ppf.effective_end_date;

Line: 45

select pay.payroll_name from pay_payrolls_f pay
where pay.payroll_id = cp_payroll_id
and cp_effective_date between pay.effective_start_date
			 and pay.effective_end_date;

Line: 51

select vendor_name from po_vendors where vendor_id=p_vendor_id;

Line: 54

select meaning from hr_lookups where lookup_type =p_lookup_type and lookup_code=p_lookup_code;

Line: 114

	select meaning into l_define_meaning
	from hxc_lookups
	where lookup_type='HXC_DEFINE_MISSING'
	and lookup_code=p_define_missing;

Line: 132

	select name into p_application_label
	from hxc_time_recipients
	where time_recipient_id = p_application;

Line: 178

	select assignment_set_name into p_assignment_set_label
	from hr_assignment_sets
	where assignment_set_id = p_payroll_assignment_set;

Line: 249

person_type1 := 'and     ppf.effective_start_date = (select max(effective_start_date)

					    from   per_people_f
					    where  person_id = ppf.person_id
					    and effective_start_date <= :p_date_to
					    and effective_end_date >= :p_date_from
					    and ptu.person_id = person_id
					    and ptu.effective_start_date <= :p_date_to
					    and ptu.effective_end_date >= :p_date_from
					    and ppt.person_type_id = ptu.person_type_id
					    --and ppt.person_type_id   = person_type_id
					    and ppt.system_person_type in ' || L_PERSON_TYPE || ')';

Line: 375

   select decode (
substr(p_pref_spec_list_out,(instr(p_pref_spec_list_out,'|',1,i)+1)
,(instr(p_pref_spec_list_out,'|',1,i+1)-1)-(instr(p_pref_spec_list_out,'|',1,i))),
'null', '',
 substr(p_pref_spec_list_out,(instr(p_pref_spec_list_out,'|',1,i)+1)
,(instr(p_pref_spec_list_out,'|',1,i+1)-1)-(instr(p_pref_spec_list_out,'|',1,i)))
	) into l_tcard_req_attri from dual;