APPS.ARP_PROCESS_HEADER_UPDTE_COVER dependencies on RA_CUSTOMER_TRX

Line 11: | Updates a record in ra_customer_trx. |

7: | PROCEDURE |
8: | update_header_cover |
9: | |
10: | DESCRIPTION |
11: | Updates a record in ra_customer_trx. |
12: | |
13: | SCOPE - PUBLIC |
14: | |
15: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 360: FROM ra_customer_trx t,

356: t.org_id,
357: d.set_of_books_id,
358: t.term_id,
359: t.initial_customer_trx_id /*bug6957444*/
360: FROM ra_customer_trx t,
361: ra_cust_trx_line_gl_dist d
362: WHERE t.customer_trx_id = p_customer_trx_id
363: AND t.customer_trx_id = d.customer_trx_id
364: AND d.account_class = 'REC' ;

Line 368: FROM ra_customer_trx_lines_all

364: AND d.account_class = 'REC' ;
365:
366: CURSOR c_line (p_trx_id NUMBER) IS
367: SELECT customer_trx_line_id
368: FROM ra_customer_trx_lines_all
369: WHERE customer_trx_id = p_trx_id
370: AND line_type = 'LINE';
371:
372: l_trx_date DATE;

Line 383: l_trx_rec ra_customer_trx%rowtype;

379: x_event_id NUMBER;
380: --}
381:
382: l_commit_rec arp_process_commitment.commitment_rec_type;
383: l_trx_rec ra_customer_trx%rowtype;
384: l_recalc_tax_flag boolean;
385: l_rerun_autoacc_flag boolean;
386: l_return_status NUMBER;
387: