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 pmts.payment_id,
                               pmts.payee_party_id,
                               pmts.payee_le_registration_num,
                               pmts.internal_bank_account_id,
                               pmts.int_bank_account_name,
                               pmts.int_bank_acct_agency_loc_code,
                               pmts.external_bank_account_id,
                               ext_ba.bank_account_name ext_bank_account_name,
                               iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
																		  ext_ba.ba_num_sec_segment_id,
																		  iby_utility_pvt.get_view_param('SYS_KEY'),
																		  baek.subkey_cipher_text,
																		  baes.segment_cipher_text,
																		  baes.encoding_scheme,
																		  ext_ba.ba_mask_setting,
																		  ext_ba.ba_unmask_length) ext_bank_account_number,
                               pmts.ext_branch_number,
                               pmts.ext_bank_account_type
			FROM iby_payments_all pmts,
			     iby_ext_bank_accounts ext_ba,
				 IBY_SYS_SECURITY_SUBKEYS baek,
                 IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
				AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 74

			SELECT 	calling_app_doc_unique_ref2
			FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 117

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 363

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 371

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 373

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 401

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 408

			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
				AND payment_status = 'INSTRUCTION_CREATED';

Line: 422

			SELECT calling_app_doc_unique_ref2
			FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 463

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 588

                                        SELECT document_type
                                        INTO l_invoice_type FROM IBY_DOCS_PAYABLE_ALL
                                        WHERE calling_app_doc_unique_ref2 = l_iby_docs_rec.calling_app_doc_unique_ref2
					AND payment_id = l_iby_pmt_rec.payment_id
				        AND calling_app_id=200
				        AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');

Line: 684

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 692

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 694

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 722

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 730

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 763

			SELECT calling_app_doc_unique_ref2
			FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 801

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 1071

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 1079

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 1081

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 1109

			SELECT  org_id,payment_reason_code
				FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 1116

			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
				AND payment_status = 'INSTRUCTION_CREATED';

Line: 1130

			SELECT calling_app_doc_unique_ref2
			FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 1170

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 1363

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 1372

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 1374

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 1402

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 1409

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 1442

			SELECT calling_app_doc_unique_ref2
			FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 1482

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 1723

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 1731

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 1733

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 1761

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 1768

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 1801

			SELECT calling_app_doc_unique_ref2
			FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 1841

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 2053

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 2062

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 2064

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 2092

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 2099

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 2132

			SELECT calling_app_doc_unique_ref2
			FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 2171

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 2382

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 2390

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 2392

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 2420

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 2428

			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
				AND payment_status = 'INSTRUCTION_CREATED';

Line: 2440

			SELECT calling_app_doc_unique_ref2
				FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 2480

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 2589

                                        SELECT document_type
                                        INTO l_invoice_type FROM IBY_DOCS_PAYABLE_ALL
                                        WHERE calling_app_doc_unique_ref2 = l_iby_docs_rec.calling_app_doc_unique_ref2
					AND payment_id = l_iby_pmt_rec.payment_id
				        AND calling_app_id=200
				        AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');

Line: 2653

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 2661

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 2663

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 2691

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 2699

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 2732

			SELECT calling_app_doc_unique_ref2
			FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 2772

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 3017

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 3025

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 3027

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 3055

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 3063

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 3096

			SELECT calling_app_doc_unique_ref2
				FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 3136

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 3377

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 3385

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 3387

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 3415

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 3422

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 3455

			SELECT calling_app_doc_unique_ref2
			FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 3495

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 3691

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 3699

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 3701

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 3729

			SELECT  org_id
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 3736

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 3769

			SELECT calling_app_doc_unique_ref2
				FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 3809

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 4008

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 4016

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 4018

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 4046

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 4054

			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
				AND payment_status = 'INSTRUCTION_CREATED';

Line: 4068

			SELECT calling_app_doc_unique_ref2
				FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 4109

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 4191

                                        SELECT document_type
                                        INTO l_invoice_type FROM IBY_DOCS_PAYABLE_ALL
                                        WHERE calling_app_doc_unique_ref2 = l_iby_docs_rec.calling_app_doc_unique_ref2
					AND payment_id = l_iby_pmt_rec.payment_id
				        AND calling_app_id=200
				        AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');

Line: 4272

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 4280

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 4282

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 4310

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 4318

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 4351

			SELECT calling_app_doc_unique_ref2
				FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 4390

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 4612

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 4620

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 4622

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 4650

			SELECT  org_id,
				payment_reason_code
				  FROM  iby_pay_instructions_all
			WHERE
				payment_instruction_id = p_instruction_id;

Line: 4658

			SELECT pmts.payment_id,
			       pmts.payment_instruction_id,
                   pmts.payee_party_id,
                   pmts.payee_le_registration_num,
			       pmts.payment_amount,
                   pmts.internal_bank_account_id,
                   pmts.int_bank_account_name,
                   pmts.int_bank_acct_agency_loc_code,
                   pmts.external_bank_account_id,
                   ext_ba.bank_account_name ext_bank_account_name,
                   iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.bank_account_num,
															  ext_ba.ba_num_sec_segment_id,
															  iby_utility_pvt.get_view_param('SYS_KEY'),
															  baek.subkey_cipher_text,
															  baes.segment_cipher_text,
															  baes.encoding_scheme,
															  ext_ba.ba_mask_setting,
															  ext_ba.ba_unmask_length) ext_bank_account_number,
                   pmts.ext_branch_number,
                   pmts.ext_bank_account_type
			FROM   iby_payments_all pmts,
			       iby_ext_bank_accounts ext_ba,
				   IBY_SYS_SECURITY_SUBKEYS baek,
                   IBY_SECURITY_SEGMENTS baes
			WHERE
				pmts.payment_instruction_id = p_instruction_id
				AND pmts.payment_status = 'INSTRUCTION_CREATED'
                AND pmts.external_bank_account_id = ext_ba.ext_bank_account_id(+)
				AND ext_ba.ba_num_sec_segment_id = baes.sec_segment_id(+)
                AND baes.sec_subkey_id = baek.sec_subkey_id(+);

Line: 4691

			SELECT calling_app_doc_unique_ref2
				FROM iby_docs_payable_all
			WHERE
				payment_id = p_pmt_id
				AND
				calling_app_id=200
				AND
				UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP')
				AND document_status = 'PAYMENT_CREATED';

Line: 4730

                        delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

Line: 4955

                IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

Line: 4963

	IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

Line: 4965

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);