DBA Data[Home] [Help]

APPS.ARRX_C_BRS dependencies on RA_CUSTOMER_TRX

Line 120: l_maturity_date_from RA_CUSTOMER_TRX.term_due_date%TYPE;

116: l_second_status AR_LOOKUPS.lookup_code%TYPE;
117: l_third_status AR_LOOKUPS.lookup_code%TYPE;
118: l_excluded_status AR_LOOKUPS.lookup_code%TYPE;
119: l_transaction_type RA_CUST_TRX_TYPES.name%TYPE;
120: l_maturity_date_from RA_CUSTOMER_TRX.term_due_date%TYPE;
121: l_maturity_date_to RA_CUSTOMER_TRX.term_due_date%TYPE;
122: l_drawee_name HZ_PARTIES.party_name%TYPE;
123: l_drawee_number_from HZ_CUST_ACCOUNTS.account_number%TYPE;
124: l_drawee_number_to HZ_CUST_ACCOUNTS.account_number%TYPE;

Line 121: l_maturity_date_to RA_CUSTOMER_TRX.term_due_date%TYPE;

117: l_third_status AR_LOOKUPS.lookup_code%TYPE;
118: l_excluded_status AR_LOOKUPS.lookup_code%TYPE;
119: l_transaction_type RA_CUST_TRX_TYPES.name%TYPE;
120: l_maturity_date_from RA_CUSTOMER_TRX.term_due_date%TYPE;
121: l_maturity_date_to RA_CUSTOMER_TRX.term_due_date%TYPE;
122: l_drawee_name HZ_PARTIES.party_name%TYPE;
123: l_drawee_number_from HZ_CUST_ACCOUNTS.account_number%TYPE;
124: l_drawee_number_to HZ_CUST_ACCOUNTS.account_number%TYPE;
125: l_remittance_batch_name AR_BATCHES.name%TYPE;

Line 130: l_transaction_issue_date_from RA_CUSTOMER_TRX.trx_date%TYPE;

126: l_remittance_bank_account ce_bank_accounts.bank_account_name%TYPE;
127: l_drawee_bank_name ce_bank_branches_v.bank_name%TYPE;
128: l_original_amount_from AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
129: l_original_amount_to AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
130: l_transaction_issue_date_from RA_CUSTOMER_TRX.trx_date%TYPE;
131: l_transaction_issue_date_to RA_CUSTOMER_TRX.trx_date%TYPE;
132: l_on_hold RA_CUSTOMER_TRX.br_on_hold_flag%TYPE;
133:
134: BEGIN

Line 131: l_transaction_issue_date_to RA_CUSTOMER_TRX.trx_date%TYPE;

127: l_drawee_bank_name ce_bank_branches_v.bank_name%TYPE;
128: l_original_amount_from AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
129: l_original_amount_to AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
130: l_transaction_issue_date_from RA_CUSTOMER_TRX.trx_date%TYPE;
131: l_transaction_issue_date_to RA_CUSTOMER_TRX.trx_date%TYPE;
132: l_on_hold RA_CUSTOMER_TRX.br_on_hold_flag%TYPE;
133:
134: BEGIN
135:

Line 132: l_on_hold RA_CUSTOMER_TRX.br_on_hold_flag%TYPE;

128: l_original_amount_from AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
129: l_original_amount_to AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
130: l_transaction_issue_date_from RA_CUSTOMER_TRX.trx_date%TYPE;
131: l_transaction_issue_date_to RA_CUSTOMER_TRX.trx_date%TYPE;
132: l_on_hold RA_CUSTOMER_TRX.br_on_hold_flag%TYPE;
133:
134: BEGIN
135:
136: -- Populate mandatory parameters for request_id and user_id