APPS.PQP_HROSS_REPORTS SQL Statements

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

Line: 29

    SELECT REPLACE(p_parameter1, ' ') INTO l_parameter1 FROM DUAL;

Line: 30

    SELECT REPLACE(p_parameter2, ' ') INTO l_parameter2 FROM DUAL;

Line: 114

   PERSON_END_DATE_WHERE := ' AND ppf.effective_end_date = (SELECT max(ppf1.effective_end_date) ' ||
                                                              ' FROM per_people_f ppf1, per_person_types ppt1 ' ||
                                                             ' WHERE (to_date(''' || P_EFFECTIVE_START_DATE || ''', ''' || l_date_format || ''') between paf.effective_start_date and paf.effective_end_date ' ||
                                                                 ' OR to_date(''' || P_EFFECTIVE_END_DATE || ''', ''' || l_date_format || ''') between paf.effective_start_date and paf.effective_end_date ) ' ||
                                                               ' AND ppf1.person_id = ppf.person_id ' ||
							       ' AND ppf1.person_type_id = ppt1.person_type_id ' ||
                                                               ' AND ppt1.system_person_type in (''EMP'', ''EMP_APL'') ' ||
     							       ' AND ppt1.active_flag = ''Y'') ';

Line: 213

   PERSON_END_DATE_WHERE := ' AND ppf.effective_end_date = (SELECT max(ppf1.effective_end_date) ' ||
                                                              ' FROM per_people_f ppf1, per_person_types ppt1 ' ||
                                                             ' WHERE (to_date(''' || P_EFFECTIVE_START_DATE || ''', ''' || l_date_format || ''') between paf.effective_start_date and paf.effective_end_date ' ||
                                                                 ' OR to_date(''' || P_EFFECTIVE_END_DATE || ''', ''' || l_date_format || ''') between paf.effective_start_date and paf.effective_end_date ) ' ||
                                                               ' AND ppf1.person_id = ppf.person_id ' ||
							       ' AND ppf1.person_type_id = ppt1.person_type_id ' ||
                                                               ' AND ppt1.system_person_type in (''EMP'', ''EMP_APL'') ' ||
     							       ' AND ppt1.active_flag = ''Y'') ';

Line: 339

  SELECT to_char(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_date)), l_date_format) into l_return_value FROM dual;

Line: 414

  SELECT phone_country_code, phone_area_code, phone_number, phone_extension
    FROM hz_contact_points
   WHERE owner_table_id = c_owner_table_id
     AND phone_line_type = 'GEN'
     AND primary_flag = 'Y';

Line: 472

  SELECT phone_country_code, phone_area_code, phone_number, phone_extension
    FROM hz_contact_points
   WHERE owner_table_id = c_owner_table_id
     AND phone_line_type = 'GEN'
     AND primary_flag <> 'Y'
     AND creation_date = (SELECT MAX(creation_date)
                           FROM hz_contact_points
                          WHERE owner_table_id = c_owner_table_id
		            AND phone_line_type = 'GEN'
			    AND primary_flag <> 'Y');