APPS.PAY_KW_GENERAL SQL Statements

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

Line: 20

			Select Org_Information1
			Into l_nationality_cd
			From HR_ORGANIZATION_INFORMATION
			Where ORG_INFORMATION_CONTEXT = 'KW_BG_DETAILS'
			And ORGANIZATION_ID = l_organization_id;

Line: 53

			Select person_id
			Into l_person_id
			From PER_ALL_ASSIGNMENTS_F
			Where ASSIGNMENT_ID = p_assignment_id
			AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Line: 63

			Select Nationality
			Into l_nationality_person
			From PER_ALL_PEOPLE_F
			Where PERSON_ID = l_person_id
			AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Line: 155

			 SELECT user_table_id
			 FROM   pay_user_tables
			 WHERE  legislation_code='KW'
	  		 AND    UPPER(user_table_name) = UPPER(l_table_name);

Line: 160

			 SELECT MIN(fnd_number.canonical_to_number(row_low_range_or_name))
			 FROM   pay_user_rows_f
			 WHERE  user_table_id = l_user_table_id
			 AND    legislation_code = 'KW'
	  		 AND    l_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 166

			 SELECT MIN(fnd_number.canonical_to_number(row_high_range))
			 FROM   pay_user_rows_f
			 WHERE  user_table_id = l_user_table_id
			 AND    legislation_code = 'KW'
	  		 AND    l_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 172

			 SELECT MAX(fnd_number.canonical_to_number(row_high_range))
			 FROM   pay_user_rows_f
			 WHERE  user_table_id = l_user_table_id
			 AND    legislation_code = 'KW'
  		 	 AND    l_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 248

   SELECT count(DISTINCT paf.assignment_id)
   FROM   per_all_assignments_f paf
         ,per_assignment_status_types pas
   WHERE  paf.assignment_type    = 'E'
   AND    paf.PERSON_ID          = p_person_id
   AND    p_effective_date between effective_start_date and effective_end_date
   AND    paf.assignment_status_type_id = pas.assignment_status_type_id
   AND    pas.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line: 271

  SELECT COUNT(*)
  FROM  per_assignments_f            paf
        ,per_people_f                 pef
        ,pay_pre_payments             ppp
        ,pay_assignment_actions       paa
        ,pay_payroll_actions          ppa
  WHERE  paa.payroll_action_id          =
         pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
  AND    paa.pre_payment_id             = ppp.pre_payment_id
  AND    paa.payroll_action_id          = ppa.payroll_action_id
  AND    paa.assignment_id              = paf.assignment_id
  AND    paf.person_id                  = pef.person_id
  AND    ppp.value                      > 0
  AND    ppa.effective_date BETWEEN paf.effective_start_date
                                AND paf.effective_end_date
  AND    ppa.effective_date BETWEEN pef.effective_start_date
                                AND pef.effective_end_date;

Line: 298

  SELECT SUM(ppp.value)
  FROM  per_assignments_f            paf
        ,per_people_f                 pef
        ,pay_pre_payments             ppp
        ,pay_assignment_actions       paa
        ,pay_payroll_actions          ppa
  WHERE  paa.payroll_action_id          =
         pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
  AND    paa.pre_payment_id             = ppp.pre_payment_id
  AND    paa.payroll_action_id          = ppa.payroll_action_id
  AND    paa.assignment_id              = paf.assignment_id
  AND    paf.person_id                  = pef.person_id
  AND    ppp.value                      > 0
  AND    ppa.effective_date BETWEEN paf.effective_start_date
                                AND paf.effective_end_date
  AND    ppa.effective_date BETWEEN pef.effective_start_date
                                AND pef.effective_end_date;