APPS.HXC_TIME_APPROVAL_INFO SQL Statements

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

Line: 15

   g_application_info.delete;

Line: 24

  select aps.application_period_id,
         aps.approval_status,
	 aps.creation_date,
	 aps.notification_status,
	 aps.approver_id,
	 aps.time_recipient_id
    from hxc_tc_ap_links tcl,
	 hxc_app_period_summary aps
   where tcl.timecard_id = p_tc_id
     and tcl.application_period_id = aps.application_period_id;

Line: 64

   select max(aps.creation_date)
     from hxc_tc_ap_links tcl, hxc_app_period_summary aps
    where tcl.timecard_id = p_timecard_id
      and aps.approval_status = 'APPROVED'
      and aps.application_period_id = tcl.application_period_id;

Line: 88

  select ts.timecard_id,
         ts.approval_status,
	 ts.recorded_hours,
	 ts.has_reasons,
	 ts.submission_date
    from hxc_timecard_summary ts
   where ts.timecard_id = p_tc_id;

Line: 120

   select time_category_id
     from hxc_time_categories
    where time_category_name = p_name;

Line: 153

   select time_recipient_id
     from hxc_time_recipients
    where name = p_name;

Line: 189

      select application_period_id
	from hxc_app_period_summary
       where resource_id = p_resource_id
	 and trunc(start_time) = trunc(p_start_time)
	 and trunc(stop_time) = trunc(p_stop_time)
	 and time_recipient_id = p_time_recipient_id
	 and nvl(time_category_id,-1) = nvl(p_time_category_id,-1);

Line: 230

   select timecard_id
     from hxc_tc_ap_links
    where application_period_id = p_app_period_id;

Line: 261

   select timecard_id
     from hxc_timecard_summary
    where resource_id = p_resource_id
      and trunc(start_time) = trunc(p_start_time)
      and trunc(stop_time) = trunc(p_stop_time);