APPS.PSB_LD_POS_DEFAULTS_PVT SQL Statements

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

Line: 47

    SELECT position_id,
	   business_group_id,
	   vacant_position_flag,
	   effective_start_date,
	   effective_end_date
      FROM PSB_POSITIONS
     WHERE data_extract_id = p_data_extract_id
       AND (vacant_position_flag is NULL
	or vacant_position_flag = 'N');

Line: 58

    SELECT effective_start_date,
	   effective_END_date
      FROM PSB_POSITIONS
     WHERE position_id = l_position_id;

Line: 68

    SELECT distribution_id,
	   position_id,
	   data_extract_id,
	   effective_start_date,
	   effective_END_date,
	   chart_of_accounts_id,
	   code_combination_id,
	   distribution_percent,
	   distribution_default_rule_id
      FROM PSB_POSITION_PAY_DISTRIBUTIONS
     WHERE data_extract_id = p_data_extract_id
       AND (((l_position_END_date is not NULL)
       AND (((effective_start_date <= l_position_end_date)
       AND (effective_END_date is NULL))
	OR ((effective_start_date between l_position_start_date
       AND l_position_END_date)
	OR (effective_END_date between l_position_start_date
       AND l_position_END_date)
	OR ((effective_start_date < l_position_start_date)
       AND (effective_END_date > l_position_END_date)))))
	OR ((l_position_END_date is NULL)
       AND (nvl(effective_END_date, l_position_start_date)
	   >= l_position_start_date)))
       AND position_id = l_position_id
       AND code_combination_id IS NOT NULL;

Line: 97

    SELECT effective_start_date, effective_end_date
    FROM   PSB_POSITION_PAY_DISTRIBUTIONS
    WHERE  position_id=l_position_id
    AND    project_id IS NOT NULL
    AND    code_combination_id IS NULL;

Line: 105

    SELECT a.default_rule_id,
	   a.priority
      FROM PSB_DEFAULTS a,
	   PSB_SET_RELATIONS b,
	   PSB_BUDGET_POSITIONS c
     WHERE exists
	  (SELECT 1
	     FROM PSB_DEFAULT_ACCOUNT_DISTRS d
	    WHERE d.default_rule_id = a.default_rule_id)
       AND a.priority is not NULL
       AND (a.global_default_flag = 'N'
	   or a.global_default_flag IS NULL)
       AND a.default_rule_id = b.default_rule_id
       AND b.account_position_set_id = c.account_position_set_id
       AND c.data_extract_id = p_data_extract_id
       AND c.position_id = l_position_id
     ORDER BY a.priority;

Line: 124

    SELECT chart_of_accounts_id,
	   code_combination_id,
	   distribution_percent
      FROM PSB_DEFAULT_ACCOUNT_DISTRS
     WHERE default_rule_id = l_default_rule_id
     AND   code_combination_id IS NOT NULL;

Line: 342

  Select data_extract_name
    into l_data_extract_name
    from psb_data_extracts
   where data_extract_id = p_data_extract_id;