APPS.IGS_PERSONSTATS_PUB SQL Statements

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

Line: 7

  SELECT WIDTH , precision , column_type ,scale
  FROM FND_COLUMNS
  WHERE  table_id IN
    (SELECT TABLE_ID
     FROM FND_TABLES
     WHERE table_name = p_table_name AND APPLICATION_ID = 8405)
  AND column_name = p_param_name
  AND APPLICATION_ID = 8405;

Line: 78

  SELECT
    person_id
  FROM
    igs_pe_prsid_grp_mem_v
  WHERE   group_id = p_group_id
  AND          NVL(TRUNC(start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE)
  AND          NVL(TRUNC(end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE);

Line: 87

        SELECT 'X'
	FROM igs_pe_prsid_grp_mem
	WHERE  person_id = p_person_id
	AND group_id = p_group_id
  AND NVL(TRUNC(start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE)
  AND NVL(TRUNC(end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE);

Line: 151

				IGS_AD_UPD_INITIALISE.update_per_stats(p_person_id,NULL);

Line: 202

						IGS_AD_UPD_INITIALISE.update_per_stats(c_person_group_rec.person_id,NULL);