APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG SQL Statements

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

Line: 32

	    select fed_employer_id_number
	   	into l_fed_employer_number
	   	from fv_operating_units_all foua,
	             iby_pay_instructions_all ipia
	   	where ipia.payment_instruction_id = p_payment_instruction_id
	   	and   ipia.org_id = foua.org_id;

Line: 97

   select payment_reason_code
   into l_payment_reason_code
   from iby_payments_all
   where payment_id = p_payment_id;

Line: 152

  	SELECT '1'
  	FROM   FV_TOP_EXCLUSION_CRITERIA_ALL FVTOPEC
  	WHERE  FVTOPEC.set_of_books_id 	= p_sob_id_csr
  	AND   (FVTOPEC.payment_reason_code  	= NVL(p_payment_reason_csr,'-999')
  		OR FVTOPEC.vendor_type_code	= NVL(p_vendor_type_csr,'-999')
  		OR (FVTOPEC.vendor_id		= p_vendor_id_csr
  		   AND (FVTOPEC.vendor_site_id  	= p_vendor_site_id_csr
  			OR FVTOPEC.vendor_site_code   = 'ALL')))
  	AND (NVL(FVTOPEC.effective_start_date ,p_payment_date_csr) <= p_payment_date_csr
  	AND NVL(FVTOPEC.effective_end_date ,p_payment_date_csr) >= p_payment_date_csr);

Line: 166

        SELECT DISTINCT aid.dist_code_combination_id
        FROM  iby_payments_all ipa,
              iby_docs_payable_all idpa,
              ap_invoice_distributions aid
        WHERE ipa.payment_id = p_payment_id
        and   ipa.payment_id = idpa.payment_id
        and   idpa.calling_app_id = 200
        and   idpa.document_type = 'INVOICE'
        and   idpa.calling_app_doc_unique_ref2 = aid.invoice_id;

Line: 180

  	SELECT concatenated_segments_low , concatenated_segments_high
  	FROM   fv_top_exclusion_criteria
  	WHERE  (concatenated_segments_low IS NOT NULL
  	AND    concatenated_segments_high IS NOT NULL )
  	AND    set_of_books_id = p_sob_id_csr
  	AND    NVL(effective_start_date ,p_payment_date_csr) <= p_payment_date_csr
  	AND    NVL(effective_end_date   ,p_payment_date_csr) >= p_payment_date_csr ;

Line: 203

        select payment_reason_code, payment_date, org_id
        into l_payment_reason_code, l_payment_date, l_org_id
        from iby_payments_all
        where payment_id = p_payment_id;

Line: 215

        select chart_of_accounts_id
        into l_coa
        from gl_ledgers
        where ledger_id = l_ledger_id;

Line: 226

        select aia.vendor_id, aia.vendor_site_id, aps.vendor_type_lookup_code
        into l_vendor_id, l_vendor_site_id, l_vendor_type
        from iby_payments_all ipa,
             iby_docs_payable_all idpa,
             ap_invoices_all aia,
             ap_suppliers aps
        where ipa.payment_id = p_payment_id
        and   ipa.payment_id = idpa.payment_id
        and   idpa.calling_app_id = 200
        and   idpa.document_type = 'STANDARD'
        and   idpa.calling_app_doc_unique_ref2 = aia.invoice_id
        and   aia.vendor_id = aps.vendor_id
        and   rownum < 2;

Line: 360

          SELECT seq_assignment_id, initial_seq_value, org_id
	  FROM Fv_Pb_Seq_Assignments_all FPSA
	  WHERE FPSA.org_id = p_org_id_csr
          AND FPSA.next_seq_value IS NULL;

Line: 385

              UPDATE Fv_Pb_Seq_Assignments_all
	      SET next_seq_value = c_assign.initial_seq_value
	      WHERE org_id=c_assign.org_id
              AND seq_assignment_id = c_assign.seq_assignment_id;

Line: 395

	  	SELECT next_seq_value, final_seq_value, prefix, suffix, seq_assignment_id
	  	INTO l_nextseq, l_finalseq, l_prefix, l_suffix, l_seq_assignment_id
	  	FROM Fv_Pb_Seq_Assignments_all
	  	WHERE payment_reason_code = p_payment_reason_code
	  	AND     org_id = p_org_id
	  	AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date) AND NVL(TRUNC(end_date),TRUNC(SYSDATE));

Line: 418

	  SELECT COUNT(*)
	  INTO l_pi_count
	  FROM iby_pay_instructions_all
	  WHERE org_id = p_org_id
	  AND pay_admin_assigned_ref_code = l_instruction_name;

Line: 441

          update fv_pb_seq_assignments_all
          set next_seq_value = l_nextseq
          where seq_assignment_id = l_seq_assignment_id;

Line: 490

			Update fv_summary_consolidate_all
			Set summary_schedule_flag = 'Y'
			Where payment_instruction_id = p_payment_instruction_id;