APPS.HXC_MISSING_TCARD_REPORT SQL Statements

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

Line: 15

   SELECT 'Y'
   FROM   dual
   WHERE EXISTS (
          SELECT  'x'
          FROM    hr_assignment_set_amendments has
          WHERE   has.assignment_set_id = p_assignment_set_id
          AND     has.assignment_id     = p_assignment_id);

Line: 42

    SELECT    pov.vendor_name VENDOR_NAME,
              a.vendor_id     VENDOR_ID
       FROM per_assignments_f a,
            per_all_people_f pp,
	    po_vendors pov
      WHERE a.assignment_type ='C'
        AND a.person_id = pp.person_id
        AND p_start_date <= a.effective_end_date
        AND p_end_date >= a.effective_start_date
        AND p_start_date <= pp.effective_end_date
        AND p_end_date >= pp.effective_start_date
	and pp.person_id=p_resource_id
        AND a.vendor_id = pov.vendor_id(+)
        AND a.vendor_id is not null
        group by  pov.vendor_name,a.vendor_id;

Line: 86

       SELECT distinct 'Y'
       FROM per_assignments_f a,
            per_all_people_f pp,
	    po_vendors pov
      WHERE a.assignment_type ='C'
        AND a.person_id = pp.person_id
        AND p_start_date <= a.effective_end_date
        AND p_end_date >= a.effective_start_date
        AND p_start_date <= pp.effective_end_date
        AND p_end_date >= pp.effective_start_date
	and pp.person_id=p_resource_id
        AND a.vendor_id = pov.vendor_id
	and a.vendor_id=p_vendor_id
        AND a.vendor_id is not null;