APPS.PAY_ZA_EFT_RECONCILIATION SQL Statements

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

Line: 19

     Select to_char(nvl(ppa.overriding_dd_date, nvl(ptp.default_dd_date, ptp.end_date)), 'YYYY/MM/DD')
     from pay_assignment_actions paa,
          pay_pre_payments       ppp,
          pay_assignment_actions paa2,
          pay_payroll_actions    ppa,
          per_time_periods       ptp
     where paa.assignment_action_id = p_assignment_action_id
     and paa.PRE_PAYMENT_ID = ppp.PRE_PAYMENT_ID
     and paa2.assignment_action_id  = ( select max(locked_action_id)
                                        from pay_action_interlocks pai
                                        where pai.locking_action_id = ppp.assignment_action_id
                                       )
    and paa2.payroll_action_id     = ppa.payroll_action_id
    and ppa.time_period_id        = ptp.time_period_id;

Line: 36

    select SEGMENT2
    from pay_payrolls_f PPF,
        PAY_PAYROLL_ACTIONS PPA,
        hr_soft_coding_keyflex SOK
    where PPA.payroll_action_id =  p_payroll_action_id
    and PPA.payroll_id = PPF.payroll_id
    and PPF.SOFT_CODING_KEYFLEX_ID = SOK.SOFT_CODING_KEYFLEX_ID
    and p_effective_date between ppf.EFFECTIVE_START_DATE and ppf.EFFECTIVE_END_DATE;

Line: 47

    select SEGMENT3
    from PAY_ORG_PAYMENT_METHODS_F OPM,
         PAY_EXTERNAL_ACCOUNTS PEA
    where OPM.ORG_PAYMENT_METHOD_ID = p_org_payment_method_id
    and   OPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID
    and p_effective_date between OPM.EFFECTIVE_START_DATE and OPM.EFFECTIVE_END_DATE;

Line: 56

     select ppa.effective_date
     from pay_assignment_actions paa,
          pay_pre_payments       ppp,
          pay_assignment_actions paa2,
          pay_payroll_actions    ppa
     where paa.assignment_action_id = p_assignment_action_id
     and paa.PRE_PAYMENT_ID = ppp.PRE_PAYMENT_ID
     and paa2.assignment_action_id  = ( select max(locked_action_id)
                                        from pay_action_interlocks pai
                                        where pai.locking_action_id = ppp.assignment_action_id
                                       )
      and paa2.payroll_action_id     = ppa.payroll_action_id;

Line: 70

   select  substr(hoi.org_information1, 1, 80),
           substr(hoi.org_information2, 1, 80)
   from   pay_payroll_actions         ppa,
          hr_organization_information hoi,
          hr_organization_units       hou
   where  ppa.payroll_action_id = p_payroll_action_id
   and    hou.organization_id = ppa.business_group_id
   and    hoi.organization_id = hou.organization_id
   and    hoi.org_information_context = 'ZA_ACB_INFORMATION';

Line: 95

   SELECT BUSINESS_GROUP_ID
	 INTO l_business_grp_id
	 FROM pay_payroll_actions
   WHERE PAYROLL_ACTION_ID = p_payroll_action_id;

Line: 101

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

Line: 111

	  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 ;

Line: 160

          SELECT GEN_NUMBER INTO l_gen_number
          FROM PAY_ZA_ACB_USER_GEN_NOS
          WHERE PAYROLL_ACTION_ID = p_payroll_action_id
          AND  USER_CODE  =  l_inst_code;

Line: 165

          SELECT GEN_NUMBER INTO l_gen_number
          FROM PAY_ZA_ACB_USER_GEN_NOS
          WHERE PAYROLL_ACTION_ID = p_payroll_action_id
          AND  USER_CODE  =  l_acb_code;