806: -- First do cash methods
807: --
808: select payment_type_id
809: into cash_type
810: from pay_payment_types
811: where payment_type_name = 'Cash';
812: --
813: -- Now insert the methods
814: --
831: -- Now do check methods
832: --
833: select payment_type_id
834: into check_type
835: from pay_payment_types
836: where payment_type_name = 'Check';
837: --
838: -- Now insert the methods
839: --
856: -- Now do NACS methods
857: --
858: select payment_type_id
859: into nacs_type
860: from pay_payment_types
861: where payment_type_name = 'NACS';
862: --
863: -- Now insert the methods
864: --
881: -- Now put in a cheque method paid in GBP
882: --
883: select payment_type_id
884: into cheque_type
885: from pay_payment_types
886: where payment_type_name = 'Cheque';
887: --
888: -- Now insert the methods
889: --