APPS.HR_AUTH_INT SQL Statements

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

Line: 19

SELECT user_name
FROM fnd_user
WHERE user_id = p_user_id;

Line: 72

SELECT bg.legislation_code
FROM per_all_people_f ppl,
     per_business_groups bg
WHERE ppl.person_id = p_person_id
  AND SYSDATE BETWEEN ppl.effective_start_date
                  AND ppl.effective_end_date
  AND ppl.business_group_id = bg.business_group_id;

Line: 162

PROCEDURE update_sso_url
	(
	p_url IN VARCHAR2,
	p_app_id IN VARCHAR2
  ) IS

l_procedure VARCHAR2(31) := 'update_sso_url';

Line: 257

END update_sso_url;

Line: 345

  update_sso_url(get_url_from_profile(l_country),
                 l_app_id );

Line: 735

SELECT 'Y'
FROM ben_ler_f
WHERE sysdate BETWEEN effective_start_date
          AND effective_end_date
  AND ler_id = p_ler_id
  AND typ_cd = 'SCHEDDO';

Line: 743

SELECT target_page
FROM hr_authoria_mappings
WHERE pl_id = p_pl_id
  AND NVL(plip_id,-924926578) = NVL(p_plip_id,-924926578)
  AND open_enrollment_flag = l_open_flag;