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;

Line: 533

     Select business_group_id
     From pay_payroll_actions
     Where payroll_action_id = p_payroll_action_id;

Line: 539

     Select overriding_dd_date
     From pay_payroll_actions
     Where payroll_action_id = p_payroll_action_id;

Line: 545

     Select ext.segment2 --Acc Num
     From pay_external_accounts ext,
	  pay_org_payment_methods_f org
     Where org.org_payment_method_id = p_org_payment_method_id
     and   p_effective_date between org.effective_start_date and org.effective_end_date
     and   org.external_account_id = ext.external_account_id;

Line: 554

     Select pay_nl_general.get_parameter(legislative_parameters, 'BATCH_DESC')
     From pay_payroll_actions
     Where payroll_action_id = p_payroll_action_id;

Line: 560

     Select pmeth_information2
     From pay_org_payment_methods_f
     Where org_payment_method_id = p_org_payment_method_id
     and  p_effective_date between effective_start_date and effective_end_date;

Line: 578

   Select hruserdt.get_table_value(l_business_grp_id,
                                   'NL_EFT_RECONC_FUNC',
				   'RECONCILIATION',
				   'FUNCTION NAME',
                                   p_effective_date)
    Into l_usr_fnc_name
    From dual;

Line: 588

	     EXECUTE IMMEDIATE 'select '||l_usr_fnc_name||'(:1,:2,:3,:4,:5,:6,:7,:8,:9) from dual'
	     INTO l_return_value
	     USING p_effective_date ,
                   p_identifier_name,
	           p_payroll_action_id,
		   p_payment_type_id,
		   p_org_payment_method_id,
		   p_personal_payment_method_id,
		   p_assignment_action_id,
		   p_pre_payment_id,
		   p_delimiter_string ;