APPS.GHR_PAR_BUS SQL Statements

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

Line: 56

    select  1
    from    ghr_noa_families  noa
    where   noa.nature_of_action_id = p_first_nature_of_action_id
    and     noa.noa_family_code     = p_noa_family_code
    and     l_effective_date
    between nvl(noa.start_date_active,l_effective_date)
    and     nvl(noa.end_date_active,l_effective_date)
    and     noa.enabled_flag        = 'Y';

Line: 139

    select  1
    from    ghr_dual_actions  dua
    where   dua.first_noa_id  = p_first_nature_of_action_id
    and     dua.second_noa_id = p_second_nature_of_action_id;

Line: 241

    SELECT  1
    FROM   per_all_people_f per
    where  per.person_id = p_val_person_id;

Line: 246

    SELECT  1
    FROM    per_all_people_f per
    WHERE   per.person_id = p_val_person_id
    AND     nvl(p_effective_date,sysdate)
    BETWEEN per.effective_start_date and per.effective_end_date;

Line: 503

    select ppf.effective_start_date,
           ppt.system_person_type
    from   per_all_people_f ppf,
           per_person_types ppt
    where  ppf.person_id = p_person_id
    and    ppf.effective_start_date < nvl(p_effective_date,sysdate)
    and    ppt.person_type_id       = ppf.person_type_id
    order by 1 desc;

Line: 688

   SELECT  first_noa_code,noa_family_code
   FROM    ghr_pa_requests par
   WHERE   par.pa_request_id = p_pa_request_id;

Line: 693

    SELECT   person_id
    FROM     per_all_assignments_f asg
    WHERE    asg.assignment_id = p_employee_assignment_id;

Line: 698

    SELECT  1
    FROM    per_all_assignments_f asg
    WHERE   asg.assignment_id = p_employee_assignment_id
    AND     nvl(p_effective_date,sysdate)
    BETWEEN asg.effective_start_date and asg.effective_end_date;

Line: 705

    select ppf.effective_start_date,
           ppt.system_person_type
    from   per_all_people_f ppf,
           per_person_types ppt
    where  ppf.person_id = p_person_id
    and    ppf.effective_start_date <= nvl(p_effective_date,sysdate)
    and    ppt.person_type_id       = ppf.person_type_id
    order by 1 desc;

Line: 836

    SELECT   1
    FROM     per_all_assignments_f asg
    WHERE    asg.assignment_id  = p_employee_assignment_id
    AND      asg.position_id    = p_from_position_id;

Line: 903

    select  hl.lookup_code ,
            hl.meaning
    from    hr_lookups hl ,
            ghr_noac_las       nla
    where   nla.nature_of_action_id  = p_first_nature_of_action_id
    and     SUBSTR(nla.lac_lookup_code,1,3)      = p_first_action_la_code1
    and     nla.valid_first_lac_flag = 'Y'
    and     hl.lookup_type           = 'GHR_US_LEGAL_AUTHORITY'
    and     hl.lookup_code           = nla.lac_lookup_code
    and     hl.enabled_flag          = 'Y'
    and     nvl(p_effective_date,trunc(sysdate))
    between nvl(hl.start_date_active,nvl(p_effective_date,trunc(sysdate)))
    and     nvl(hl.end_date_active,nvl(p_effective_date,trunc(sysdate)));

Line: 980

    select  hl.lookup_code ,
            hl.meaning
    from    hr_lookups hl,
            ghr_noac_las       nla
    where   nla.nature_of_action_id = p_first_nature_of_action_id
    and     SUBSTR(nla.lac_lookup_code,1,3)     = p_first_action_la_code2
    and     nla.valid_second_lac_flag = 'Y'
    and     hl.lookup_type          = 'GHR_US_LEGAL_AUTHORITY'
    and     hl.lookup_code          = nla.lac_lookup_code
    and     hl.enabled_flag         = 'Y'
    and     nvl(p_effective_date,trunc(sysdate))
    between nvl(hl.start_date_active,nvl(p_effective_date,trunc(sysdate)))
    and     nvl(hl.end_date_active,nvl(p_effective_date,trunc(sysdate)));

Line: 1083

    SELECT   1
    FROM     ghr_duty_stations_f dsf
    WHERE    dsf.duty_station_id = p_duty_station_id;

Line: 1088

    SELECT  1
    FROM    ghr_duty_stations_f dsf
    WHERE   dsf.duty_station_id = p_duty_station_id
    AND     nvl(p_effective_date,sysdate)
   BETWEEN dsf.effective_start_date and dsf.effective_end_date;

Line: 1157

    select  hl.lookup_code ,
            hl.meaning
    from    hr_lookups hl ,
            ghr_noac_las       nla
    where   nla.nature_of_action_id  = p_second_nature_of_action_id
    and     SUBSTR(nla.lac_lookup_code,1,3)      = p_second_action_la_code1
    and     nla.valid_first_lac_flag = 'Y'
    and     hl.lookup_type           = 'GHR_US_LEGAL_AUTHORITY'
    and     hl.lookup_code           = nla.lac_lookup_code
    and     hl.enabled_flag          = 'Y'
    and     nvl(p_effective_date,trunc(sysdate))
    between nvl(hl.start_date_active,nvl(p_effective_date,trunc(sysdate)))
    and     nvl(hl.end_date_active,nvl(p_effective_date,trunc(sysdate)));

Line: 1234

    select  hl.lookup_code ,
            hl.meaning
    from    hr_lookups hl ,
            ghr_noac_las       nla
    where   nla.nature_of_action_id   = p_second_nature_of_action_id
    and     substr(nla.lac_lookup_code,1,3)       = p_second_action_la_code2
    and     nla.valid_second_lac_flag = 'Y'
    and     hl.lookup_type            = 'GHR_US_LEGAL_AUTHORITY'
    and     hl.lookup_code            = nla.lac_lookup_code
    and     hl.enabled_flag           = 'Y'
    and     nvl(p_effective_date,trunc(sysdate))
    between nvl(hl.start_date_active,nvl(p_effective_date,trunc(sysdate)))
    and     nvl(hl.end_date_active,nvl(p_effective_date,trunc(sysdate)));

Line: 1297

Procedure insert_validate(p_rec in ghr_par_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1495

End insert_validate;

Line: 1499

Procedure update_validate(p_rec in ghr_par_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1693

End update_validate;

Line: 1698

Procedure delete_validate(p_rec in ghr_par_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1708

End delete_validate;

Line: 2626

  If (p_rec.mass_action_select_flag = hr_api.g_varchar2) then
    p_rec.mass_action_select_flag  :=
    ghr_par_shd.g_old_rec.mass_action_select_flag;