APPS.PAY_IN_TERMINATION_PKG SQL Statements

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

Line: 81

      SELECT 'X'
      FROM   hr_organization_information
      WHERE  organization_id         = p_organization_id
      AND    org_information_context = p_org_info_type_code
      AND    org_information1        = p_emp_category
      AND    org_information_id     <> NVL(p_org_information_id,0);

Line: 191

        SELECT pet.element_type_id
        FROM pay_element_types_f pet
             ,pay_element_entries_f pee
	WHERE pet.element_type_id = pee.element_type_id
	AND pee.element_entry_id = p_element_entry_id
	AND pet.element_name = 'Gratuity Information'
	AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
	AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date;

Line: 205

	SELECT  'TRUE'
 	FROM  pay_element_entry_values_f peev
	     ,pay_input_values_f piv
	WHERE  peev.element_entry_id = p_element_entry_id
	AND  piv.element_Type_id = p_element_type_id
	AND  peev.input_value_id = piv.input_value_id
	AND  piv.name = 'Forfeiture Amount'
	AND  peev.screen_entry_value IS NOT NULL
	AND  p_effective_date BETWEEN piv.effective_start_date
			      AND piv.effective_end_date
	AND  p_effective_date BETWEEN peev.effective_start_date
			      AND peev.effective_end_date;

Line: 225

	SELECT 'TRUE'
	FROM  pay_element_entry_values_f peev
	     ,pay_input_values_f piv
	WHERE  peev.element_entry_id = p_element_entry_id
	AND  piv.element_Type_id = p_element_type_id
	AND  peev.input_value_id = piv.input_value_id
	AND  piv.name = 'Forfeiture Reason'
	AND  peev.screen_entry_value IS NOT NULL
	AND  p_effective_date BETWEEN piv.effective_start_date
			      AND piv.effective_end_date
	AND  p_effective_date BETWEEN peev.effective_start_date
			      AND peev.effective_end_date;

Line: 438

  SELECT
     paa.assignment_action_id,
     ppa.date_earned,
     ppa.effective_date,
     ptp.start_date,
     ptp.end_date
  FROM
     per_time_periods ptp,
     pay_payroll_actions ppa,
     pay_assignment_actions paa
  WHERE ptp.payroll_id = p_payroll_id
  AND   ptp.start_date between TRUNC(p_start_date,'MM') AND  p_end_date
  AND   ptp.payroll_id = ppa.payroll_id
  AND   ptp.time_period_id = ppa.time_period_id
  AND   ppa.action_status = 'C'
  AND   ppa.action_type IN ('R','Q','I','B')
  AND   ppa.payroll_action_id = paa.payroll_action_id
  AND   paa.assignment_id = p_assignment_id
  AND   paa.source_action_id IS NULL
  UNION
  SELECT
     paa.assignment_action_id,
     ppa.date_earned,
     ppa.effective_date,
     ptp.start_date,
     ptp.end_date
  FROM
     per_time_periods ptp,
     pay_payroll_actions ppa,
     pay_assignment_actions paa
  WHERE ptp.payroll_id = p_payroll_id
  AND   ptp.payroll_id = ppa.payroll_id
  AND   ptp.time_period_id = ppa.time_period_id
  AND   ppa.payroll_action_id = paa.payroll_action_id
  AND   paa.assignment_id = p_assignment_id
  AND   paa.payroll_action_id = ppa.payroll_action_id
  AND   paa.assignment_action_id = p_assignment_action_id
  ORDER BY 2;

Line: 609

     SELECT paf.assignment_id
           ,paf.payroll_id
	   ,ppf.start_date
	   ,pos.leaving_reason
	   ,pos.notified_termination_date
     FROM   per_periods_of_service pos
	   ,per_assignments_f paf
	   ,per_people_f ppf
     WHERE  pos.period_of_service_id = p_period_of_service_id
     AND    pos.business_group_id    = p_business_group_id
     AND    pos.period_of_service_id = paf.period_of_service_id
     AND    paf.person_id            = ppf.person_id
     AND    p_effective_date  BETWEEN ppf.effective_start_date
                              AND     ppf.effective_end_date
     AND    p_effective_date  BETWEEN paf.effective_start_date
                              AND     paf.effective_end_date;

Line: 687

   SELECT inputs.name
        , inputs.input_value_id
     FROM pay_element_types_f types
        , pay_input_values_f inputs
    WHERE types.element_type_id  = p_element_type_id
      AND inputs.element_type_id = types.element_type_id
      AND (inputs.legislation_code = g_legislation_code OR inputs.business_group_id = p_business_group_id)
      AND p_effective_date BETWEEN types.effective_start_date
                           AND types.effective_end_date
      AND p_effective_date BETWEEN inputs.effective_start_date
                           AND inputs.effective_end_date
    ORDER BY inputs.display_sequence;

Line: 767

   SELECT pel.element_link_id
         ,pet.element_type_id
     FROM pay_element_links_f pel,
          pay_element_types_f pet,
	  per_assignments_f   paf
    WHERE pet.element_name      = p_element_name
      AND paf.assignment_id     = g_assignment_id
      AND pet.element_type_id   = pel.element_type_id
      AND (pel.payroll_id       = g_payroll_id or pel.payroll_id IS NULL)
      AND pel.business_group_id = paf.business_group_id
      AND p_effective_date BETWEEN paf.effective_start_date
                               AND paf.effective_end_date
      AND p_effective_date BETWEEN pet.effective_start_date
                               AND pet.effective_end_date
      AND p_effective_date BETWEEN pel.effective_start_date
                               AND pel.effective_end_date;

Line: 786

   SELECT element_type_id
   FROM   pay_element_types_f
   WHERE  (
            legislation_code = 'IN'
           OR
            business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
          )
   AND    element_name = p_element_name
   AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 1042

    SELECT  asg.business_group_id
           ,asg.payroll_id
    FROM   per_assignments_f asg
    WHERE  asg.assignment_id     = p_assignment_id
    AND    asg.primary_flag      = 'Y'
    AND    p_effective_date  BETWEEN asg.effective_start_date
                            AND      asg.effective_end_date ;

Line: 1053

    SELECT pel.element_link_id
    FROM   pay_element_links_f pel,
           pay_element_types_f pet
    WHERE  pet.element_name      = p_element_name
    AND    pet.element_type_id   = pel.element_type_id
    AND    (pel.payroll_id       = l_payroll_id
           OR (pel.payroll_id IS NULL
              AND pel.link_to_all_payrolls_flag = 'Y' ) )
    AND    pel.business_group_id = l_business_group_id
    AND    p_effective_date  BETWEEN pet.effective_start_date
                             AND     pet.effective_end_date
    AND    p_effective_date  BETWEEN pel.effective_start_date
                             AND     pel.effective_end_date ;

Line: 1070

    SELECT element_entry_id
          ,object_version_number
          ,effective_start_date
    FROM   pay_element_entries_f
    WHERE  assignment_id   = p_assignment_id
    AND    element_link_id = c_element_link_id
    AND    p_effective_date BETWEEN effective_start_date
                            AND     effective_end_date ;

Line: 1173

    SELECT  asg.business_group_id
           ,asg.payroll_id
    FROM   per_assignments_f asg
    WHERE  asg.assignment_id     = p_assignment_id
    AND    asg.primary_flag      = 'Y'
    AND    p_effective_date  BETWEEN asg.effective_start_date
                            AND      asg.effective_end_date ;

Line: 1184

    SELECT pel.element_link_id
    FROM   pay_element_links_f pel,
           pay_element_types_f pet
    WHERE  pet.element_name      = p_element_name
    AND    pet.element_type_id   = pel.element_type_id
    AND    (pel.payroll_id       = l_payroll_id
           OR (pel.payroll_id IS NULL
              AND pel.link_to_all_payrolls_flag = 'Y' ) )
    AND    pel.business_group_id = l_business_group_id
    AND    p_effective_date  BETWEEN pet.effective_start_date
                             AND     pet.effective_end_date
    AND    p_effective_date  BETWEEN pel.effective_start_date
                             AND     pel.effective_end_date ;

Line: 1201

    SELECT pef.element_entry_id
          ,pef.object_version_number
	  ,pef.effective_start_date
    FROM   pay_element_entries_f pef
          ,pay_element_entry_values_f pev
	  ,pay_input_values_f piv
    WHERE  pef.assignment_id      = p_assignment_id
    AND    pef.element_link_id    = c_element_link_id
    AND    pef.element_entry_id   = pev.element_entry_id
    AND    pev.input_value_id     = piv.input_value_id
    AND    piv.NAME               = p_input_value_name
    AND    pev.screen_entry_value = p_input_value
    AND    p_effective_date BETWEEN pef.effective_start_date
                            AND     pef.effective_end_date
    AND    p_effective_date BETWEEN pev.effective_start_date
                            AND     pev.effective_end_date
    AND    p_effective_date BETWEEN piv.effective_start_date
                            AND     piv.effective_end_date;

Line: 1306

 SELECT 1
   FROM pay_run_results prr,
        pay_assignment_actions paa,
        pay_element_types_f pet,
        pay_payroll_Actions ppa
  WHERE paa.assignment_id = p_assignment_id
   AND  paa.assignment_action_id = prr.assignment_action_id
   AND  paa.payroll_action_id= ppa.payroll_action_id
   AND  ppa.action_type in('R','Q','B')
   AND  ppa.action_status = 'C'
   AND  paa.action_status = 'C'
   AND  prr.element_type_id=pet.element_type_id
   AND  pet.element_name=p_element_name;

Line: 1378

    SELECT  asg.business_group_id
           ,asg.payroll_id
    FROM   per_assignments_f asg
    WHERE  asg.assignment_id     = p_assignment_id
    AND    asg.primary_flag      = 'Y'
    AND    p_effective_date  BETWEEN asg.effective_start_date
                            AND      asg.effective_end_date ;

Line: 1390

   SELECT pee.element_entry_id
        , pee.object_version_number
        ,pee.effective_start_date
    FROM pay_element_types_f pet,
         pay_element_classifications pec,
         pay_element_entries_f pee,
         pay_element_entry_values_f peev,
         pay_input_values_f piv
   WHERE pet.classification_id = pec.classification_id
     AND pec.classification_name = 'Information'
     AND pet.element_name LIKE '%Excess Advance'
     AND pet.element_type_id = piv.element_type_id
     AND piv.name ='Component Name'
     AND piv.default_value = p_component_name
     AND peev.input_value_id = piv.input_value_id
     AND peev.element_entry_id = pee.element_entry_id
     AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
     AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
     AND p_effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
     AND p_effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date
     AND pee.assignment_id = p_assignment_id
     AND pee.element_type_id = pet.element_type_id
     AND pet.business_group_id = l_business_group_id;

Line: 1481

   SELECT scl.segment8
   FROM   per_assignments_f asg
         ,hr_soft_coding_keyflex  scl
   WHERE  asg.assignment_id    = g_assignment_id
   AND    asg.primary_flag     = 'Y'
   AND    p_actual_termination_date
                           BETWEEN asg.effective_start_date
                           AND     asg.effective_end_date
   AND    scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
   AND    scl.enabled_flag           = 'Y' ;

Line: 1676

PROCEDURE delete_gratuity_entry
              (p_period_of_service_id    IN NUMBER
              ,p_business_group_id       IN NUMBER
              ,p_actual_termination_date IN DATE
              ,p_calling_procedure       IN VARCHAR2
              ,p_message_name            OUT NOCOPY VARCHAR2
              ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
              ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type
              )
IS
  l_procedure          VARCHAR2(100);

Line: 1693

  l_delete_warning     BOOLEAN;

Line: 1697

  l_procedure := g_package || 'delete_gratuity_entry' ;

Line: 1722

     pay_element_entry_api.delete_element_entry
              (p_datetrack_delete_mode => hr_api.g_delete
              ,p_effective_date        => l_start_date
              ,p_element_entry_id      => l_element_entry_id
              ,p_object_version_number => l_ee_ovn
              ,p_effective_start_date  => l_eff_start_date
              ,p_effective_end_date    => l_eff_end_date
              ,p_delete_warning        => l_delete_warning
               ) ;

Line: 1737

END delete_gratuity_entry;

Line: 1767

     SELECT NVL(paf.employee_category,'IN_DEF'),
            paf.notice_period,paf.notice_period_uom
     FROM   per_assignments_f paf
     WHERE  paf.assignment_id           = g_assignment_id
     AND    p_actual_termination_date BETWEEN paf.effective_start_date
                                    AND     paf.effective_end_date;

Line: 1775

     SELECT hoi.org_information2
     FROM   hr_organization_information hoi
     WHERE  hoi.organization_id         = p_business_group_id
     AND    hoi.org_information_context = 'PER_IN_NOTICE_DF'
     AND    hoi.org_information1        = p_emp_category;

Line: 1982

PROCEDURE delete_notice_entry
              (p_period_of_service_id    IN NUMBER
              ,p_business_group_id       IN NUMBER
              ,p_actual_termination_date IN DATE
              ,p_calling_procedure       IN VARCHAR2
              ,p_message_name            OUT NOCOPY VARCHAR2
              ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
              ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type
              )
IS
  l_procedure          VARCHAR2(100);

Line: 1999

  l_delete_warning     BOOLEAN;

Line: 2003

  l_procedure := g_package || 'delete_notice_entry' ;

Line: 2027

     pay_element_entry_api.delete_element_entry
              (p_datetrack_delete_mode => hr_api.g_delete
              ,p_effective_date        => l_start_date
              ,p_element_entry_id      => l_element_entry_id
              ,p_object_version_number => l_ee_ovn
              ,p_effective_start_date  => l_eff_start_date
              ,p_effective_end_date    => l_eff_end_date
              ,p_delete_warning        => l_delete_warning
               ) ;

Line: 2042

END delete_notice_entry;

Line: 2161

PROCEDURE delete_retrenchment_entry
              (p_period_of_service_id    IN NUMBER
              ,p_business_group_id       IN NUMBER
              ,p_actual_termination_date IN DATE
              ,p_calling_procedure       IN VARCHAR2
              ,p_message_name            OUT NOCOPY VARCHAR2
              ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
              ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type
              )
IS
  l_procedure          VARCHAR2(100);

Line: 2178

  l_delete_warning     BOOLEAN;

Line: 2185

  l_procedure := g_package || 'delete_retrenchment_entry' ;

Line: 2209

     pay_element_entry_api.delete_element_entry
              (p_datetrack_delete_mode => hr_api.g_delete
              ,p_effective_date        => l_start_date
              ,p_element_entry_id      => l_element_entry_id
              ,p_object_version_number => l_ee_ovn
              ,p_effective_start_date  => l_eff_start_date
              ,p_effective_end_date    => l_eff_end_date
              ,p_delete_warning        => l_delete_warning
               ) ;

Line: 2224

END delete_retrenchment_entry;

Line: 2435

PROCEDURE delete_vrs_entry
              (p_period_of_service_id    IN NUMBER
              ,p_business_group_id       IN NUMBER
              ,p_actual_termination_date IN DATE
              ,p_calling_procedure       IN VARCHAR2
              ,p_message_name            OUT NOCOPY VARCHAR2
              ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
              ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type
              )
IS
  l_procedure          VARCHAR2(100);

Line: 2452

  l_delete_warning     BOOLEAN;

Line: 2459

  l_procedure := g_package || 'delete_vrs_entry' ;

Line: 2484

     pay_element_entry_api.delete_element_entry
              (p_datetrack_delete_mode => hr_api.g_delete
              ,p_effective_date        => l_start_date
              ,p_element_entry_id      => l_element_entry_id
              ,p_object_version_number => l_ee_ovn
              ,p_effective_start_date  => l_eff_start_date
              ,p_effective_end_date    => l_eff_end_date
              ,p_delete_warning        => l_delete_warning
               ) ;

Line: 2499

END delete_vrs_entry;

Line: 2626

PROCEDURE delete_pension_entry
              (p_period_of_service_id    IN NUMBER
              ,p_business_group_id       IN NUMBER
              ,p_actual_termination_date IN DATE
              ,p_calling_procedure       IN VARCHAR2
              ,p_message_name            OUT NOCOPY VARCHAR2
              ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
              ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type
              )
IS
  l_procedure          VARCHAR2(100);

Line: 2643

  l_delete_warning     BOOLEAN;

Line: 2650

  l_procedure := g_package || 'delete_pension_entry' ;

Line: 2674

     pay_element_entry_api.delete_element_entry
              (p_datetrack_delete_mode => hr_api.g_delete
              ,p_effective_date        => l_start_date
              ,p_element_entry_id      => l_element_entry_id
              ,p_object_version_number => l_ee_ovn
              ,p_effective_start_date  => l_eff_start_date
              ,p_effective_end_date    => l_eff_end_date
              ,p_delete_warning        => l_delete_warning
               ) ;

Line: 2688

END delete_pension_entry;

Line: 2736

   SELECT pet.element_name
        ,piv1.default_value
        ,pbt.balance_name
    FROM pay_element_types_f pet,
         pay_element_classifications pec,
         pay_balance_feeds_f pbf,
         pay_balance_types pbt,
         pay_input_values_f piv,
         pay_input_values_f piv1,
         pay_element_types_f pet2
   WHERE pet.classification_id = pec.classification_id
     AND pec.classification_name = 'Voluntary Deductions'
     AND pec.legislation_code = 'IN'
     AND pet.element_name LIKE '%Recover'
     AND pbf.input_value_id = piv.input_value_id
     AND pbt.balance_type_id = pbf.balance_type_id
     AND pbt.balance_name IN ('Outstanding Advance for Allowances',
                              'Outstanding Advance for Earnings',
                              'Outstanding Advance for Fringe Benefits')
     AND pbt.legislation_code='IN'
     AND piv1.element_type_id = pet.element_type_id
     AND piv.name = 'Pay Value'
     AND piv.element_type_id = pet.element_type_id
     AND piv1.name ='Component Name'
     AND p_actual_termination_date BETWEEN pbf.effective_start_date AND pbf.effective_end_date
     AND p_actual_termination_date BETWEEN pet.effective_start_date AND pet.effective_end_date
     AND p_actual_termination_date BETWEEN piv1.effective_start_date AND piv1.effective_end_date
     AND p_actual_termination_date BETWEEN piv.effective_start_date AND piv.effective_end_date
     AND piv.business_group_id  = p_business_group_id
     AND piv1.business_group_id = p_business_group_id
     AND pet.business_group_id  = p_business_group_id
     AND pet2.business_group_id = p_business_group_id
     AND pet2.element_name = SUBSTR(pet.element_name,1,INSTR(pet.element_name,' Recover',-1))||'Advance'
     AND p_actual_termination_date BETWEEN pet.effective_start_date AND pet.effective_end_date
     AND EXISTS (SELECT '1'
                   FROM pay_run_results prr,
                        pay_assignment_actions paa,
                        pay_payroll_Actions ppa
                  WHERE paa.assignment_id = g_assignment_id
                    AND paa.assignment_action_id = prr.assignment_action_id
                    AND paa.payroll_action_id= ppa.payroll_action_id
                    AND ppa.action_type in('R','Q','B')
                    AND prr.element_type_id = pet2.element_type_id
                    AND ROWNUM =1
                    AND ppa.action_status = 'C'
                    AND paa.action_status = 'C'
                    AND ppa.business_group_id = p_business_group_id
                 );

Line: 2786

     SELECT MAX(paa.assignment_action_id)
     FROM   pay_assignment_actions paa
           ,pay_payroll_actions ppa
     WHERE  paa.assignment_id = g_assignment_id
     AND    paa.payroll_action_id = ppa.payroll_action_id
     AND    paa.action_status = 'C'
     AND    paa.source_action_id IS NULL
     AND    ppa.action_type in ('R','Q')
     AND    ppa.action_status = 'C' ;

Line: 2902

PROCEDURE delete_advances_entry
              (p_period_of_service_id    IN NUMBER
              ,p_business_group_id       IN NUMBER
              ,p_actual_termination_date IN DATE
              ,p_calling_procedure       IN VARCHAR2
              ,p_message_name            OUT NOCOPY VARCHAR2
              ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
              ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type
              )
IS
  l_procedure          VARCHAR2(100);

Line: 2919

  l_delete_warning     BOOLEAN;

Line: 2922

  SELECT pet.element_name
    FROM pay_element_types_f pet,
         pay_element_classifications pec
   WHERE pet.classification_id = pec.classification_id
     AND pec.classification_name = 'Information'
     AND pet.element_name LIKE '%Excess Advance'
     AND pet.business_group_id = p_business_group_id
     and p_actual_termination_date between pet.effective_start_date and pet.effective_end_date;

Line: 2934

  l_procedure := g_package || 'delete_advances_entry' ;

Line: 2958

     pay_element_entry_api.delete_element_entry
              (p_datetrack_delete_mode => hr_api.g_delete
              ,p_effective_date        => l_start_date
              ,p_element_entry_id      => l_element_entry_id
              ,p_object_version_number => l_ee_ovn
              ,p_effective_start_date  => l_eff_start_date
              ,p_effective_end_date    => l_eff_end_date
              ,p_delete_warning        => l_delete_warning
               ) ;

Line: 2975

END delete_advances_entry;

Line: 3106

PROCEDURE delete_pf_entry
              (p_period_of_service_id    IN NUMBER
              ,p_business_group_id       IN NUMBER
              ,p_actual_termination_date IN DATE
              ,p_calling_procedure       IN VARCHAR2
              ,p_message_name            OUT NOCOPY VARCHAR2
              ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
              ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type
              )
IS
  l_procedure          VARCHAR2(100);

Line: 3123

  l_delete_warning     BOOLEAN;

Line: 3130

  l_procedure := g_package || 'delete_pf_entry' ;

Line: 3154

     pay_element_entry_api.delete_element_entry
              (p_datetrack_delete_mode => hr_api.g_delete
              ,p_effective_date        => l_start_date
              ,p_element_entry_id      => l_element_entry_id
              ,p_object_version_number => l_ee_ovn
              ,p_effective_start_date  => l_eff_start_date
              ,p_effective_end_date    => l_eff_end_date
              ,p_delete_warning        => l_delete_warning
               ) ;

Line: 3169

END delete_pf_entry;

Line: 3213

  SELECT pee.element_entry_id
  FROM   pay_element_entries_f pee
	    ,pay_input_values_f piv
        ,pay_element_entry_values_f peev
  WHERE  pee.assignment_id = g_assignment_id
  AND    pee.element_entry_id = peev.element_entry_id
  AND    peev.input_value_id = piv.input_value_id
  AND    piv.name = 'Component Name'
  AND    peev.screen_entry_value = 'Loan at Concessional Rate'
  AND    p_actual_termination_date BETWEEN pee.effective_start_date
                                   AND     pee.effective_end_date
  AND    p_actual_termination_date BETWEEN piv.effective_start_date
                                   AND     piv.effective_end_date
  AND    p_actual_termination_date BETWEEN peev.effective_start_date
                                   AND     peev.effective_end_date;

Line: 3234

  SELECT peev.screen_entry_value
  FROM   pay_element_entry_values_f peev
	    ,pay_input_values_f piv
  WHERE  peev.element_entry_id = p_element_entry_id
  AND    peev.input_value_id  = piv.input_value_id
  AND    piv.NAME = p_name
  AND    p_actual_termination_date BETWEEN peev.effective_start_date
                                   AND     peev.effective_end_date
  AND    p_actual_termination_date BETWEEN piv.effective_start_date
                                   AND     piv.effective_end_date;

Line: 3251

     SELECT max(paa.assignment_action_id)
     FROM   pay_assignment_actions paa
           ,pay_payroll_actions ppa
     WHERE  paa.assignment_id = g_assignment_id
     AND    paa.payroll_action_id = ppa.payroll_action_id
     AND    paa.action_status = 'C'
     AND    paa.source_action_id IS NULL
     AND    ppa.action_type in ('R','Q')
     AND    ppa.action_status = 'C' ;

Line: 3388

PROCEDURE delete_loan_entry
              (p_period_of_service_id    IN NUMBER
              ,p_business_group_id       IN NUMBER
              ,p_actual_termination_date IN DATE
              ,p_calling_procedure       IN VARCHAR2
              ,p_message_name            OUT NOCOPY VARCHAR2
              ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
              ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type
              )
IS
  l_procedure          VARCHAR2(100);

Line: 3405

  l_delete_warning     BOOLEAN;

Line: 3408

  SELECT pee.element_entry_id
  FROM   pay_element_entries_f pee
	    ,pay_input_values_f piv
        ,pay_element_entry_values_f peev
  WHERE  pee.assignment_id = g_assignment_id
  AND    pee.element_entry_id = peev.element_entry_id
  AND    peev.input_value_id = piv.input_value_id
  AND    piv.name = 'Component Name'
  AND    peev.screen_entry_value = 'Loan at Concessional Rate'
  AND    p_actual_termination_date BETWEEN pee.effective_start_date
                                   AND     pee.effective_end_date
  AND    p_actual_termination_date BETWEEN piv.effective_start_date
                                   AND     piv.effective_end_date
  AND    p_actual_termination_date BETWEEN peev.effective_start_date
                                   AND     peev.effective_end_date;

Line: 3429

  SELECT peev.screen_entry_value
  FROM   pay_element_entry_values_f peev
	    ,pay_input_values_f piv
  WHERE  peev.element_entry_id = p_element_entry_id
  AND    peev.input_value_id  = piv.input_value_id
  AND    piv.NAME = p_name
  AND    p_actual_termination_date BETWEEN peev.effective_start_date
                                   AND     peev.effective_end_date
  AND    p_actual_termination_date BETWEEN piv.effective_start_date
                                   AND     piv.effective_end_date;

Line: 3446

  l_procedure := g_package || 'delete_loan_entry' ;

Line: 3489

        pay_element_entry_api.delete_element_entry
              (p_datetrack_delete_mode => hr_api.g_delete
              ,p_effective_date        => l_start_date
              ,p_element_entry_id      => l_element_entry_id
              ,p_object_version_number => l_ee_ovn
              ,p_effective_start_date  => l_eff_start_date
              ,p_effective_end_date    => l_eff_end_date
              ,p_delete_warning        => l_delete_warning
               ) ;

Line: 3506

END delete_loan_entry;

Line: 3544

     SELECT ppf.per_information15
	   ,pos.pds_information1
	   ,pos.pds_information2
     FROM   per_periods_of_service pos
	   ,per_assignments_f paf
	   ,per_people_f ppf
	   ,hr_soft_coding_keyflex  scl
     WHERE  pos.period_of_service_id = p_period_of_service_id
     AND    pos.business_group_id    = p_business_group_id
     AND    paf.assignment_id        = p_assignment_id
     AND    pos.period_of_service_id = paf.period_of_service_id
     AND    paf.person_id            = ppf.person_id
     AND    scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
     AND    scl.enabled_flag = 'Y'
     AND    scl.segment2 IS NOT NULL
     AND    ppf.per_information15 IS NOT NULL
     AND   (to_char(paf.effective_start_date,'Month-YYYY')=to_char(p_actual_termination_date,'Month-YYYY')
         OR  to_char(paf.effective_end_date,'Month-YYYY')=to_char(p_actual_termination_date,'Month-YYYY')
         OR  p_actual_termination_date between paf.effective_start_date and paf.effective_end_date)
     AND    p_actual_termination_date  BETWEEN ppf.effective_start_date
                              AND     ppf.effective_end_date;

Line: 3825

PROCEDURE delete_termination_elements
              (p_period_of_service_id    IN NUMBER
              ,p_business_group_id       IN NUMBER
              ,p_actual_termination_date IN DATE
              ,p_calling_procedure       IN VARCHAR2
              ,p_message_name            OUT NOCOPY VARCHAR2
              ,p_token_name              OUT NOCOPY pay_in_utils.char_tab_type
              ,p_token_value             OUT NOCOPY pay_in_utils.char_tab_type
              )
IS
  l_procedure      VARCHAR2(100);

Line: 3839

  l_procedure := g_package || 'delete_termination_elements' ;

Line: 3849

  delete_notice_entry
          (p_period_of_service_id    => p_period_of_service_id
	      ,p_business_group_id       => p_business_group_id
	      ,p_actual_termination_date => p_actual_termination_date
	      ,p_calling_procedure       => p_calling_procedure
          ,p_message_name            => p_message_name
          ,p_token_name              => p_token_name
          ,p_token_value             => p_token_value
          );

Line: 3864

  delete_retrenchment_entry
          (p_period_of_service_id    => p_period_of_service_id
	      ,p_business_group_id       => p_business_group_id
	      ,p_actual_termination_date => p_actual_termination_date
	      ,p_calling_procedure       => p_calling_procedure
          ,p_message_name            => p_message_name
          ,p_token_name              => p_token_name
          ,p_token_value             => p_token_value
          );

Line: 3879

  delete_vrs_entry
          (p_period_of_service_id    => p_period_of_service_id
	      ,p_business_group_id       => p_business_group_id
	      ,p_actual_termination_date => p_actual_termination_date
	      ,p_calling_procedure       => p_calling_procedure
          ,p_message_name            => p_message_name
          ,p_token_name              => p_token_name
          ,p_token_value             => p_token_value
          );

Line: 3894

  delete_pension_entry
          (p_period_of_service_id    => p_period_of_service_id
	      ,p_business_group_id       => p_business_group_id
	      ,p_actual_termination_date => p_actual_termination_date
	      ,p_calling_procedure       => p_calling_procedure
          ,p_message_name            => p_message_name
          ,p_token_name              => p_token_name
          ,p_token_value             => p_token_value
          );

Line: 3909

  delete_pf_entry
          (p_period_of_service_id    => p_period_of_service_id
	      ,p_business_group_id       => p_business_group_id
	      ,p_actual_termination_date => p_actual_termination_date
	      ,p_calling_procedure       => p_calling_procedure
          ,p_message_name            => p_message_name
          ,p_token_name              => p_token_name
          ,p_token_value             => p_token_value
          );

Line: 3924

  delete_loan_entry
          (p_period_of_service_id    => p_period_of_service_id
	      ,p_business_group_id       => p_business_group_id
	      ,p_actual_termination_date => p_actual_termination_date
	      ,p_calling_procedure       => p_calling_procedure
          ,p_message_name            => p_message_name
          ,p_token_name              => p_token_name
          ,p_token_value             => p_token_value
          );

Line: 3939

  delete_gratuity_entry
          (p_period_of_service_id    => p_period_of_service_id
	      ,p_business_group_id       => p_business_group_id
	      ,p_actual_termination_date => p_actual_termination_date
	      ,p_calling_procedure       => p_calling_procedure
          ,p_message_name            => p_message_name
          ,p_token_name              => p_token_name
          ,p_token_value             => p_token_value
          );

Line: 3954

    delete_advances_entry
          (p_period_of_service_id    => p_period_of_service_id
          ,p_business_group_id       => p_business_group_id
          ,p_actual_termination_date => p_actual_termination_date
          ,p_calling_procedure       => p_calling_procedure
          ,p_message_name            => p_message_name
          ,p_token_name              => p_token_name
          ,p_token_value             => p_token_value
          );

Line: 3968

END delete_termination_elements;

Line: 4000

SELECT MAX(paa.assignment_action_id)
  FROM pay_payroll_Actions ppa
      ,pay_assignment_actions paa
 WHERE paa.assignment_id =p_assignment_id
   AND paa.payroll_action_id = ppa.payroll_Action_id
   AND ppa.action_type in('R','Q')
   AND TRUNC(ppa.date_earned,'MM') = TRUNC(p_end_date,'MM')
   AND ppa.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')-- Added as a part of bug fix 4774108
   AND paa.source_action_id IS NULL;