APPS.PA_INSTALL SQL Statements

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

Line: 20

    SELECT meaning
    INTO   l_meaning
    FROM fnd_lookup_values
    WHERE lookup_type = 'PA_RES_UTIL_DEF_PERIOD_TYPES'
    AND   lookup_code = 'GE'
    AND   language = 'US';

Line: 37

    select count(*)
    into   l_count
    from   fnd_tables
    where  application_id = 1292
    and    rownum         = 1
    ;

Line: 66

    select p.status
    into   x_status
    from   fnd_product_installations p
    where  p.application_id = (select a.application_id
                               from   fnd_application a
                               where  a.application_short_name = 'PJI'
                              )
    ;

Line: 140

    select status
    into l_status
    from fnd_product_installations
    where application_id = 275;

Line: 162

  select application_id
  from fnd_application
  where application_short_name = p_product_short_name;

Line: 168

  select nvl(status,'N') from fnd_product_installations
  where application_id = x_application_id;

Line: 247

	SELECT 'Y' is_pji_setup
	INTO l_utilization_implemented
	FROM pji_system_settings
	WHERE
	organization_structure_id IS NOT NULL
	AND org_structure_version_id IS NOT NULL
	AND config_util_flag='Y'
	AND EXISTS (
	SELECT 'Y' is_pji_load_program_run
	FROM
	pji_system_parameters
	WHERE NAME = 'LAST_PJI_EXTR_DATE');

Line: 281

    select p.status
    into   x_status
    from   fnd_product_installations p
    where  p.application_id = (select a.application_id
                               from   fnd_application a
                               where  a.application_short_name = 'ONT'
                              ) ;