The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT org_id
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payee_party_id,
payee_le_registration_num,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id,
payment_reason_code
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payee_party_id,
payee_le_registration_num,
payment_instruction_id,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code
FROM iby_payments_all
WHERE payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id,
payment_reason_code
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id,payment_reason_code
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id,
payment_reason_code
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code
FROM iby_payments_all
WHERE payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id,
payment_reason_code
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payee_party_id,
payee_le_registration_num,
payment_instruction_id,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id,
payment_reason_code
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id,
payment_reason_code
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code
FROM iby_payments_all
WHERE payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id,
payment_reason_code
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
SELECT org_id,
payment_reason_code
FROM iby_pay_instructions_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT payment_id,
payment_instruction_id,
payee_party_id,
payee_le_registration_num,
payment_amount,
internal_bank_account_id,
int_bank_account_name,
int_bank_acct_agency_loc_code,
external_bank_account_id,
ext_bank_account_name,
ext_bank_account_number,
ext_branch_number,
ext_bank_account_type
FROM iby_payments_all
WHERE
payment_instruction_id = p_instruction_id;
SELECT calling_app_doc_unique_ref2
FROM iby_docs_payable_all
WHERE
payment_id = p_pmt_id
AND
calling_app_id=200
AND
UPPER(document_type)='STANDARD'
AND
UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);