APPS.PER_MANAGE_CONTRACTS_PKG SQL Statements

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

Line: 13

      SELECT 'Y'
      FROM   per_people_f      per
	    ,per_contracts_f   con
	    ,fnd_sessions      ses
      WHERE  per.person_id       = p_person_id
	AND  con.person_id       = per.person_id
	AND  ses.session_id      = USERENV('sessionid')
	AND  ses.effective_date BETWEEN per.effective_start_date
				    AND per.effective_end_date
	AND  ses.effective_date BETWEEN con.effective_start_date
				    AND con.effective_end_date;

Line: 50

      SELECT grade_structure
            ,people_group_structure
            ,job_structure
            ,position_structure
      FROM   per_business_groups
      WHERE  business_group_id = p_business_group_id;

Line: 70

  PROCEDURE update_contracts
  (p_contract_id                    IN     number
  ,p_object_version_number          IN OUT NOCOPY number
  ,p_doc_status                     IN     varchar2
  ,p_doc_status_change_date         IN     date
  ,p_exclude_flag                   IN     char)
  IS
  --
  CURSOR c_all_con IS
  SELECT contract_id,
	 effective_start_date,
	 object_version_number,
	 person_id,
         reference,
	 type,
         status
  FROM per_contracts_f
  WHERE contract_id = p_contract_id;

Line: 90

  SELECT contract_id,
	 effective_start_date,
	 object_version_number,
	 person_id,
         reference,
	 type,
         status
  FROM per_contracts_f
  WHERE contract_id = p_contract_id
  AND object_version_number <> p_object_version_number;

Line: 129

        hr_contract_api.update_contract
        (p_contract_id                   => l_con.contract_id
        ,p_effective_start_date          => l_effective_start_date
        ,p_effective_end_date            => l_effective_end_date
        ,p_object_version_number         => l_object_version_number
        ,p_person_id                     => l_con.person_id
        ,p_reference                     => l_con.reference
        ,p_type                          => l_con.type
        ,p_status                        => l_con.status
        ,p_doc_status                    => p_doc_status
        ,p_doc_status_change_date        => p_doc_status_change_date
        ,p_effective_date                => l_con.effective_start_date
        ,p_datetrack_mode                => l_dt_mode);

Line: 165

        hr_contract_api.update_contract
        (p_contract_id                   => l_con.contract_id
        ,p_effective_start_date          => l_effective_start_date
        ,p_effective_end_date            => l_effective_end_date
        ,p_object_version_number         => l_object_version_number
        ,p_person_id                     => l_con.person_id
        ,p_reference                     => l_con.reference
        ,p_type                          => l_con.type
        ,p_status                        => l_con.status
        ,p_doc_status                    => p_doc_status
        ,p_doc_status_change_date        => p_doc_status_change_date
        ,p_effective_date                => l_con.effective_start_date
        ,p_datetrack_mode                => l_dt_mode);

Line: 189

  END update_contracts;