DBA Data[Home] [Help]

APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on IBY_PAYMENT_PROFILES

Line 128: l_processing_type iby_payment_profiles.processing_type%TYPE;

124: l_last_update_login ap_checks.last_update_login%TYPE; -- Bug3343314
125: l_org_id NUMBER;
126: l_bank_account_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
127: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
128: l_processing_type iby_payment_profiles.processing_type%TYPE;
129: l_print_instr_immed_flag iby_payment_profiles.print_instruction_immed_flag%TYPE;
130: l_default_printer iby_payment_profiles.default_printer%TYPE;
131: l_payment_document_id ce_payment_documents.payment_document_id %TYPE;
132: l_bills_payable iby_payment_methods_vl.support_bills_payable_flag%TYPE;

Line 129: l_print_instr_immed_flag iby_payment_profiles.print_instruction_immed_flag%TYPE;

125: l_org_id NUMBER;
126: l_bank_account_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
127: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
128: l_processing_type iby_payment_profiles.processing_type%TYPE;
129: l_print_instr_immed_flag iby_payment_profiles.print_instruction_immed_flag%TYPE;
130: l_default_printer iby_payment_profiles.default_printer%TYPE;
131: l_payment_document_id ce_payment_documents.payment_document_id %TYPE;
132: l_bills_payable iby_payment_methods_vl.support_bills_payable_flag%TYPE;
133: l_maturity_date_offset_days iby_payment_methods_vl.maturity_date_offset_days%TYPE;

Line 130: l_default_printer iby_payment_profiles.default_printer%TYPE;

126: l_bank_account_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
127: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
128: l_processing_type iby_payment_profiles.processing_type%TYPE;
129: l_print_instr_immed_flag iby_payment_profiles.print_instruction_immed_flag%TYPE;
130: l_default_printer iby_payment_profiles.default_printer%TYPE;
131: l_payment_document_id ce_payment_documents.payment_document_id %TYPE;
132: l_bills_payable iby_payment_methods_vl.support_bills_payable_flag%TYPE;
133: l_maturity_date_offset_days iby_payment_methods_vl.maturity_date_offset_days%TYPE;
134: l_maturity_date ap_checks.future_pay_due_date%TYPE;

Line 824: FROM IBY_PAYMENT_PROFILES

820: default_printer
821: INTO l_processing_type,
822: l_print_instr_immed_flag,
823: l_default_printer
824: FROM IBY_PAYMENT_PROFILES
825: WHERE payment_profile_id = p_payment_profile_id;
826:
827: EXCEPTION
828: WHEN NO_DATA_FOUND THEN