DBA Data[Home] [Help]

APPS.IBY_PAYMENT_FORMAT_VAL_PUB SQL Statements

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

Line: 35

			SELECT  org_id
				FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 43

			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;
Line: 60

			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');
Line: 104

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 348

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 356

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 358

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 386

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 393

			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;
Line: 406

			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');
Line: 447

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 660

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 668

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 670

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 698

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 706

			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;
Line: 725

			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');
Line: 764

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 1032

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1040

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1042

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1070

			SELECT  org_id,payment_reason_code
				FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 1077

			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;
Line: 1090

			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');
Line: 1131

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 1324

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1333

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1335

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1363

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 1370

			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;
Line: 1389

			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');
Line: 1430

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 1668

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1676

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1678

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1706

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 1713

			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;
Line: 1732

			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');
Line: 1773

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 1983

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1992

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1994

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 2022

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 2029

			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;
Line: 2048

			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');
Line: 2088

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 2297

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 2305

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2307

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 2335

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 2343

			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;
Line: 2354

			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');
Line: 2394

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 2558

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 2566

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2568

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 2596

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 2604

			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;
Line: 2623

			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');
Line: 2664

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 2907

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 2915

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2917

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 2945

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 2953

			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;
Line: 2972

			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');
Line: 3013

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 3252

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3260

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3262

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3290

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 3297

			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;
Line: 3316

			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');
Line: 3357

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 3551

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3559

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3561

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3589

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 3596

			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;
Line: 3615

			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');
Line: 3656

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 3853

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3861

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3863

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3891

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 3899

			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;
Line: 3912

			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');
Line: 3953

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 4106

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 4114

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4116

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 4144

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 4152

			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;
Line: 4171

			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');
Line: 4211

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 4431

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 4439

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4441

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 4469

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;
Line: 4477

			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;
Line: 4496

			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');
Line: 4536

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
Line: 4759

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 4767

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4769

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);