APPS.PAY_NL_PAYFILE SQL Statements

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

Line: 32

  SELECT payee_type,payee_id
  FROM   pay_personal_payment_methods_f ppm
  WHERE  ppm.assignment_id              = p_assignment_id
  AND    ppm.personal_payment_method_id = p_per_pay_method_id
  AND    p_date_earned    BETWEEN ppm.effective_start_date
                                        AND     ppm.effective_end_date
  AND    ppm.business_group_id          = p_business_group_id
  AND    ppm.payee_id is NOT NULL;

Line: 42

select count(*) from
hr_All_organization_units  hou,
hr_organization_information hoi
where hou.organization_id = p_org_id
and   hoi.organization_id = hou.organization_id
and    hoi.org_information_context = 'CLASS'
and    hoi.org_information1 = 'NL_PAYEE_OVERRIDE'
and   hoi.org_information2='Y';

Line: 239

		   SELECT person_id INTO l_payee_id
		      FROM   per_all_assignments_f paf
		      WHERE  paf.assignment_id = p_assignment_id
		      AND    p_date_earned BETWEEN paf.effective_start_date
				      AND     paf.effective_end_date;

Line: 257

      SELECT person_id INTO l_payee_id
	      FROM   per_all_assignments_f paf
	      WHERE  paf.assignment_id = p_assignment_id
	      AND    p_date_earned BETWEEN paf.effective_start_date
				      AND     paf.effective_end_date;

Line: 350

  SELECT 'Y'
  FROM   ff_formulas_f ff
        ,ff_compiled_info_f ffci
  WHERE  ff.formula_id           = ffci.formula_id
  AND    ff.effective_start_date = ffci.effective_start_date
  AND    ff.effective_end_date   = ffci.effective_end_date
  AND    ff.formula_id           = p_formula_id
  AND    ff.business_group_id    = p_business_group_id
  AND    p_effective_date        BETWEEN ff.effective_start_date
                                 AND     ff.effective_end_date;

Line: 363

  SELECT ff.formula_id
  FROM   ff_formulas_f ff
  WHERE  ff.formula_name         = p_formula_name
  AND    ff.business_group_id    = p_business_group_id
  AND    p_effective_date        BETWEEN ff.effective_start_date
                                 AND     ff.effective_end_date;

Line: 458

  SELECT substr(style,1,35) style
  FROM   per_addresses pas
  WHERE  pas.person_id    = p_payee_id
  AND    pas.primary_flag = 'Y'
  AND    p_effective_date BETWEEN pas.date_from
                          AND     nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line: 466

  SELECT substr(hr_general.decode_lookup('HR_NL_CITY',town_or_city),1,35) town_or_city
  FROM   per_addresses pas
  WHERE  pas.person_id    = p_payee_id
  AND    pas.primary_flag = 'Y'
  AND    p_effective_date BETWEEN pas.date_from
                          AND     nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line: 474

  SELECT substr(town_or_city,1,35) town_or_city
  FROM   per_addresses pas
  WHERE  pas.person_id    = p_payee_id
  AND    pas.primary_flag = 'Y'
  AND    p_effective_date BETWEEN pas.date_from
                          AND     nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line: 482

  SELECT substr(hr_general.decode_lookup('HR_NL_CITY',town_or_city),1,35) town_or_city
  FROM   hr_locations_all hla
 	      ,hr_all_organization_units hou
  WHERE  hou.organization_id = p_payee_id
  AND    hou.location_id     = hla.location_id;