APPS.CE_AUTO_BANK_CLEAR1 dependencies on RA_CUST_TRX_TYPES

Line 2542: cc_id ra_cust_trx_types.gl_id_rec%type;

2538: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2539: CE_AUTO_BANK_MATCH.trx_customer_id is not null)
2540: THEN
2541: declare
2542: cc_id ra_cust_trx_types.gl_id_rec%type;
2543: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2544: cust_trx_type ra_cust_trx_types.name%type;
2545: l_dbseqname varchar2(30);
2546: l_doc_seq_id NUMBER;

Line 2543: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

2539: CE_AUTO_BANK_MATCH.trx_customer_id is not null)
2540: THEN
2541: declare
2542: cc_id ra_cust_trx_types.gl_id_rec%type;
2543: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2544: cust_trx_type ra_cust_trx_types.name%type;
2545: l_dbseqname varchar2(30);
2546: l_doc_seq_id NUMBER;
2547: l_doc_seq_value NUMBER;

Line 2544: cust_trx_type ra_cust_trx_types.name%type;

2540: THEN
2541: declare
2542: cc_id ra_cust_trx_types.gl_id_rec%type;
2543: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2544: cust_trx_type ra_cust_trx_types.name%type;
2545: l_dbseqname varchar2(30);
2546: l_doc_seq_id NUMBER;
2547: l_doc_seq_value NUMBER;
2548: l_valid_seq BOOLEAN := TRUE;

Line 2555: from ra_cust_trx_types

2551:
2552: begin
2553: select name, gl_id_rec, cust_trx_type_id
2554: into cust_trx_type, cc_id, cust_trx_type_id
2555: from ra_cust_trx_types
2556: where type = 'DM'
2557: and post_to_gl = 'Y'
2558: and accounting_affect_flag = 'Y'
2559: and tax_calculation_flag = 'N'