471: SELECT *
472: FROM IBY_EXTERNAL_PAYEES_ALL
473: WHERE ext_payee_id = cp_ext_payee_id;
474:
475: ext_payee_tab IBY_DISBURSEMENT_SETUP_PUB.External_Payee_Tab_Type;
476: ext_payee_id_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Id_Tab_Type;
477: ext_payee_create_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Create_Tab_Type;
478:
479: l_Disb_payee_rec IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE;
472: FROM IBY_EXTERNAL_PAYEES_ALL
473: WHERE ext_payee_id = cp_ext_payee_id;
474:
475: ext_payee_tab IBY_DISBURSEMENT_SETUP_PUB.External_Payee_Tab_Type;
476: ext_payee_id_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Id_Tab_Type;
477: ext_payee_create_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Create_Tab_Type;
478:
479: l_Disb_payee_rec IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE;
480: l_Ext_payee_rec IBY_EXTERNAL_PAYEES_ALL%ROWTYPE;
473: WHERE ext_payee_id = cp_ext_payee_id;
474:
475: ext_payee_tab IBY_DISBURSEMENT_SETUP_PUB.External_Payee_Tab_Type;
476: ext_payee_id_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Id_Tab_Type;
477: ext_payee_create_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Create_Tab_Type;
478:
479: l_Disb_payee_rec IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE;
480: l_Ext_payee_rec IBY_EXTERNAL_PAYEES_ALL%ROWTYPE;
481:
475: ext_payee_tab IBY_DISBURSEMENT_SETUP_PUB.External_Payee_Tab_Type;
476: ext_payee_id_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Id_Tab_Type;
477: ext_payee_create_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Create_Tab_Type;
478:
479: l_Disb_payee_rec IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE;
480: l_Ext_payee_rec IBY_EXTERNAL_PAYEES_ALL%ROWTYPE;
481:
482: l_pay_return_status VARCHAR2(50);
483: l_pay_msg_count NUMBER;