APPS.IBY_FD_USER_API_PUB SQL Statements

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

Line: 60

    select count(APPLICABLE_PMT_MTHD_ID)
      from iby_applicable_pmt_mthds
     where payment_method_code = p_method_code
       and applicable_type_code = p_driver_type
       and (applicable_value_to is null or applicable_value_to = p_driver_value);

Line: 70

    select count(ap.applicable_pmt_prof_id)
      from iby_applicable_pmt_profs ap,
           iby_payment_profiles p
     where ap.system_profile_code = p.system_profile_code
       and p.payment_profile_id = p_profile_id
       and ap.applicable_type_code = p_driver_type
       and (ap.applicable_value_to is null OR ap.applicable_value_to = p_driver_value);

Line: 82

    select count(ap.applicable_pmt_prof_id)
      from iby_applicable_pmt_profs ap,
           iby_payment_profiles p
     where ap.system_profile_code = p.system_profile_code
       and p.payment_profile_id = p_profile_id
       and ap.applicable_type_code = 'PAYER_ORG'
       and ((ap.applicable_value_to is null AND ap.applicable_value_from is null) OR
            (ap.applicable_value_to = p_driver_id_value AND
             ap.applicable_value_from = p_driver_type_value));

Line: 113

    select payment_method_name
      into l_method_name
      from IBY_PAYMENT_METHODS_VL
     where payment_method_code = p_payment_method_code;

Line: 126

          select name
            into l_le_name
            from XLE_FIRSTPARTY_INFORMATION_V
           where legal_entity_id = p_le_arr(i);

Line: 149

          select name
            into l_org_name
            from HR_ALL_ORGANIZATION_UNITS_VL
           where organization_id = p_org_arr(i).org_id;

Line: 169

    select payment_profile_name
      into l_profile_name
      from IBY_PAYMENT_PROFILES
     where payment_profile_id = p_ppp_id;

Line: 182

          select bank_account_name
            into l_acc_name
            from CE_INTERNAL_BANK_ACCOUNTS_V
           where bank_account_id = p_int_bank_acc_arr(i);

Line: 205

          select name
            into l_org_name
            from HR_ALL_ORGANIZATION_UNITS_VL
           where organization_id = p_org_arr(i).org_id;

Line: 240

      select count(ap.applicable_pmt_prof_id)
        into l_count
        from iby_applicable_pmt_profs ap,
             iby_payment_profiles p
       where ap.system_profile_code = p.system_profile_code
         and p.payment_profile_id = p_ppp_id
         and ap.applicable_type_code = 'PAYMENT_METHOD'
         and (ap.applicable_value_to is null OR ap.applicable_value_to = p_payment_method_code);

Line: 272

           select nvl(DEFAULT_PAYMENT_DOCUMENT_ID, -1),
                  processing_type
             into l_payment_document_id,
                  l_proc_type
             from iby_payment_profiles
            where payment_profile_id = p_ppp_id;

Line: 422

      select 0
      into   l_access
      from   dual
      where exists
           (select null
            from   iby_payments_all
            where  payment_instruction_id = p_instruction_id
            and    org_id <> -1
            and    MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');

Line: 501

		      select 0
		      into   l_access
		      from   dual
		      where exists
			   (select null
			    from   iby_payments_all
			    where  payment_instruction_id = p_instruction_id
			    and    org_id <> -1
			    and    MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');

Line: 606

  select count(*)
    into l_instr_sra_ok
    from IBY_PAY_INSTRUCTIONS_ALL
   where generate_sep_remit_advice_flag = 'Y'
     and (REMITTANCE_ADVICE_CREATED_FLAG = 'N' or
          IBY_FD_POST_PICP_PROGS_PVT.get_allow_multiple_sra_flag(p_instr_id) = 'Y')
     and payment_instruction_status not in ('CREATION_ERROR', 'RETRY_CREATION', 'TERMINATED')
     and IBY_FD_POST_PICP_PROGS_PVT.val_instruction_accessible(p_instr_id) = 'Y';

Line: 621

    select sra_setup.remittance_advice_format_code,
           f.format_name
      into x_default_sra_format_code,
           x_default_sra_format_name
      from iby_pay_instructions_all ins,
           iby_payment_profiles pp,
           iby_remit_advice_setup sra_setup,
           iby_formats_vl f
     where ins.payment_instruction_id = p_instr_id
       and pp.payment_profile_id = ins.payment_profile_id
       and pp.system_profile_code = sra_setup.system_profile_code
       and sra_setup.remittance_advice_format_code = f.FORMAT_CODE (+);

Line: 699

  SELECT payments_complete_code
  INTO l_complete_code
  FROM iby_pay_instructions_all
  WHERE payment_instruction_id = p_instruction_id;

Line: 720

  SELECT inst.payments_complete_code, pp.mark_complete_event
  INTO l_complete_code, l_mark_complete_event
  FROM iby_pay_instructions_all inst, iby_payment_profiles pp
     WHERE inst.payment_profile_id = pp.payment_profile_id
       AND inst.payment_instruction_id = p_instruction_id;

Line: 758

select PAYMENT_INSTRUCTION_STATUS,
       PROCESS_TYPE,
       PAYMENTS_COMPLETE_CODE,
       REQUEST_ID
into   l_instruction_status,
       l_process_type,
       l_pmt_complete_code,
       l_request_id
from iby_pay_instructions_all
where payment_instruction_id = p_instruction_id;

Line: 849

      select 0
      into   l_access
      from   dual
      where exists
           (select null
            from   iby_payments_all
            where  payment_instruction_id = p_instruction_id
            and    org_id <> -1
            and    MO_GLOBAL.CHECK_ACCESS(org_id) = 'N');

Line: 957

SELECT PAYMENT_INSTRUCTION_STATUS,
       PROCESS_TYPE,
       PAYMENT_INSTRUCTION_ID,
       ORG_ID,
       PAYMENTS_COMPLETE_CODE,
       REQUEST_ID
FROM IBY_PAY_INSTRUCTIONS_ALL INSTR
WHERE EXISTS (SELECT 'PAYMENTS'
              FROM IBY_PAYMENTS_ALL PMT
	      WHERE PMT.PAYMENT_SERVICE_REQUEST_ID= ppr_id
	      AND PMT.PAYMENT_INSTRUCTION_ID =  InStr.PAYMENT_INSTRUCTION_ID);