APPS.PQP_NL_EXT_FUNCTIONS SQL Statements

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

Line: 7

SELECT distinct(pension_sub_category)
  FROM pqp_pension_types_f
WHERE  pension_type_id = fnd_number.canonical_to_number(c_pt);

Line: 13

SELECT enabled_flag
  FROM hr_lookups
WHERE  lookup_type = 'BEN_EXT_CHG_EVT'
  AND  lookup_code = c_code;

Line: 38

SELECT business_group_id
  FROM hr_all_organization_units
WHERE  organization_id = p_organization_id;

Line: 102

SELECT ext_chg_evt_log_id,chg_evt_cd,chg_eff_dt,prmtr_01,
       prmtr_02,prmtr_04,prmtr_05,business_group_id,object_version_number
  FROM ben_ext_chg_evt_log
WHERE  new_val1   =   p_org_information1_o
  AND  new_val2   =   nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))
  AND  prmtr_01   =   'ORG'
  AND  prmtr_02   =   p_org_information3_o
  AND  prmtr_04   =   p_organization_id
  AND  chg_evt_cd =   'COAPPD';

Line: 113

SELECT business_group_id
  FROM hr_all_organization_units
WHERE  organization_id = p_organization_id;

Line: 185

        ben_EXT_CHG_EVT_api.update_EXT_CHG_EVT
                            (p_ext_chg_evt_log_id    =>  l_log_id
                            ,p_chg_evt_cd            =>  l_cd
                            ,p_chg_eff_dt            =>  l_eff_dt
                            ,p_prmtr_01              =>  l_prmtr1
                            ,p_prmtr_02              =>  l_prmtr2
                            ,p_prmtr_03              =>  'N' -- mark this row as invalid
                            ,p_prmtr_04              =>  l_prmtr4
                            ,p_prmtr_05              =>  l_prmtr5
                            ,p_person_id             =>  -1
                            ,p_business_group_id     =>  l_bgid
                            ,p_object_version_number =>  l_ovn
                            ,p_effective_date        =>  fnd_date.canonical_to_date(p_org_information1)
                            );

Line: 235

       ben_EXT_CHG_EVT_api.update_EXT_CHG_EVT
                           (p_ext_chg_evt_log_id     =>   l_log_id
                           ,p_chg_evt_cd             =>   l_cd
                           ,p_chg_eff_dt             =>   l_eff_dt
                           ,p_prmtr_01               =>   l_prmtr1
                           ,p_prmtr_02               =>   l_prmtr2
                           ,p_prmtr_03               =>   'N'
                           ,p_prmtr_04               =>   l_prmtr4
                           ,p_person_id              =>   -1
                           ,p_business_group_id      =>   l_bgid
                           ,p_object_version_number  =>   l_ovn
                           ,p_effective_date         =>   fnd_date.canonical_to_date(p_org_information1)
                           ); */

Line: 285

       ben_EXT_CHG_EVT_api.update_EXT_CHG_EVT
                           (p_ext_chg_evt_log_id     =>   l_log_id
                           ,p_chg_evt_cd             =>   l_cd
                           ,p_chg_eff_dt             =>   l_eff_dt
                           ,p_prmtr_01               =>   l_prmtr1
                           ,p_prmtr_02               =>   l_prmtr2
                           ,p_prmtr_03               =>   'N'
                           ,p_prmtr_04               =>   l_prmtr4
                           ,p_person_id              =>   -1
                           ,p_business_group_id      =>   l_bgid
                           ,p_object_version_number  =>   l_ovn
                           ,p_effective_date         =>   p_effective_date
                           ); */

Line: 320

SELECT person_id,business_group_id
  FROM per_all_assignments_f
WHERE  assignment_id = p_assignment_id
  AND  p_effective_date BETWEEN effective_start_date
  AND  effective_end_date;

Line: 399

SELECT person_id,business_group_id
  FROM per_all_assignments_f
WHERE  assignment_id = p_assignment_id
  AND  p_effective_date BETWEEN effective_start_date
  AND  effective_end_date;

Line: 406

SELECT object_version_number
      ,ext_chg_evt_log_id
      ,chg_eff_dt
  FROM ben_ext_chg_evt_log
 WHERE person_id = c_person_id
   AND chg_evt_cd = 'COAPP'
   AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);

Line: 455

    ben_ext_chg_evt_api.delete_ext_chg_evt
        (p_validate               => FALSE
        ,p_ext_chg_evt_log_id     => l_xst_log_id
        ,p_object_version_number  => l_log_xst_ovn
        ,p_effective_date         => l_xst_log_eff_dt
        );

Line: 509

SELECT business_group_id
  FROM hr_all_organization_units
WHERE  organization_id = p_organization_id;

Line: 560

SELECT business_group_id
  FROM hr_all_organization_units
WHERE  organization_id = p_organization_id;

Line: 616

SELECT person_id,business_group_id
  FROM per_all_assignments_f
WHERE  assignment_id = p_assignment_id
 AND   p_effective_date BETWEEN effective_start_date
 AND   effective_end_date;

Line: 677

SELECT person_id,business_group_id
  FROM per_all_assignments_f
WHERE  assignment_id = p_assignment_id
 AND   p_effective_date BETWEEN effective_start_date
 AND   effective_end_date;

Line: 684

SELECT ext_chg_evt_log_id,chg_evt_cd,chg_eff_dt,prmtr_01,
       prmtr_02,business_group_id,object_version_number
  FROM ben_ext_chg_evt_log
WHERE  new_val1   =   p_aei_information1_o
  AND  new_val2   =   nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))
  AND  prmtr_01   =   'ASG'
  AND  prmtr_02   =   p_aei_information3_o
  AND  person_id  =   c_person_id
  AND  chg_evt_cd =   'COSIPD';

Line: 773

SELECT person_id,business_group_id,payroll_id
  FROM per_all_assignments_f
WHERE  assignment_id = p_assignment_id
  AND  p_effective_date BETWEEN effective_start_date
  AND  effective_end_date;

Line: 781

SELECT max(ppa.date_earned)
  FROM pay_assignment_actions paa
      ,pay_payroll_actions ppa
WHERE  paa.assignment_id = p_assignment_id
  AND  ppa.payroll_action_id = paa.payroll_action_id;

Line: 789

SELECT min(effective_start_date)
  FROM per_all_assignments_f
WHERE  assignment_id = p_assignment_id;

Line: 797

SELECT start_date
  FROM per_time_periods
WHERE  payroll_id = c_payroll_id
  AND  start_date > c_date_earned
  AND  rownum = 1;

Line: 807

SELECT start_date
  FROM per_time_periods
WHERE  payroll_id = c_payroll_id
  AND  c_start_date BETWEEN start_date
  AND  end_date;

Line: 940

SELECT person_id,business_group_id,payroll_id
  FROM per_all_assignments_f
WHERE  assignment_id = p_assignment_id
  AND  p_effective_date BETWEEN effective_start_date
  AND  effective_end_date;

Line: 948

SELECT max(ppa.date_earned)
  FROM pay_assignment_actions paa
      ,pay_payroll_actions ppa
WHERE  paa.assignment_id = p_assignment_id
  AND  ppa.payroll_action_id = paa.payroll_action_id;

Line: 956

SELECT min(effective_start_date)
  FROM per_all_assignments_f
WHERE  assignment_id = p_assignment_id;

Line: 964

SELECT start_date
  FROM per_time_periods
WHERE  payroll_id = c_payroll_id
  AND  start_date > c_date_earned
  AND  rownum = 1;

Line: 974

SELECT start_date
  FROM per_time_periods
WHERE  payroll_id = c_payroll_id
  AND  c_start_date BETWEEN start_date
  AND  end_date;

Line: 981

SELECT object_version_number
      ,ext_chg_evt_log_id
      ,chg_eff_dt
  FROM ben_ext_chg_evt_log
 WHERE person_id = c_person_id
   AND chg_evt_cd = 'COAPKOP'
   AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);

Line: 1124

    ben_ext_chg_evt_api.delete_ext_chg_evt
        (p_validate               => FALSE
        ,p_ext_chg_evt_log_id     => l_xst_log_id
        ,p_object_version_number  => l_log_xst_ovn
        ,p_effective_date         => l_xst_log_eff_dt
        );