APPS.PER_PERRPRAS_XMLP_PKG SQL Statements

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

Line: 11

    SELECT business_group_id
      FROM per_org_structure_versions
     WHERE org_structure_version_id = p_org_structure_version_id;

Line: 43

 select legislation_code
 into l_legislation_code
 from per_business_groups
 where business_group_id = p_business_group_id;

Line: 178

      '(select organization_id_child '||
      'from per_org_structure_elements '||
      'connect by organization_id_parent = '||
      'prior organization_id_child '||
      'and org_structure_version_id = prior org_structure_version_id '||
      'start with organization_id_parent = '||
         to_char(P_PARENT_ORGANIZATION_ID) ||
      ' and org_structure_version_id = '||
       to_char(P_ORG_STRUCTURE_VERSION_ID) ||
      ' union select ' ||
       to_char(P_PARENT_ORGANIZATION_ID) ||
      ' from sys.dual)';

Line: 216

    select max(effective_end_date) + 1
    into l_status_start_date
    from per_assignments_f
    where assignment_id = p_assignment_id
    and   assignment_status_type_id <> p_assignment_status_type_id
    and   effective_end_date < C_SESSION_DATE;

Line: 227

    select min(effective_start_date)
    into l_status_start_date
    from per_assignments_f
    where assignment_id = p_assignment_id
    and assignment_status_type_id = p_assignment_status_type_id
    and effective_start_date <= C_SESSION_DATE;

Line: 247

    select min(effective_start_date) - 1
    into l_status_end_date
    from per_assignments_f
    where assignment_id = p_assignment_id
    and   assignment_status_type_id <> p_assignment_status_type_id
    and   effective_start_date > C_SESSION_DATE;

Line: 258

    select max(effective_end_date)
    into l_status_end_date
    from per_assignments_f
    where assignment_id = p_assignment_id
    and assignment_status_type_id = p_assignment_status_type_id
    and effective_end_date >= C_SESSION_DATE;