DBA Data[Home] [Help]

APPS.ARP_PROCESS_CREDIT dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 27: | Inserts salescredit records into RA_CUST_TRX_LINE_SALESREPS |

23: | PROCEDURE |
24: | create_salescredits |
25: | |
26: | DESCRIPTION |
27: | Inserts salescredit records into RA_CUST_TRX_LINE_SALESREPS |
28: | - copies from the credited transaction line, if any |
29: | OR - inserts a row based on the primary salesperson specified on |
30: | the transaction |
31: | |

Line 72: FROM ra_cust_trx_line_salesreps sales,

68:
69: --Bug 12376682
70: SELECT count(*)
71: INTO l_line_salesrep_flag
72: FROM ra_cust_trx_line_salesreps sales,
73: ra_customer_trx_lines ctl
74: WHERE ctl.previous_customer_trx_id = sales.customer_trx_id
75: AND ctl.previous_customer_trx_line_id = sales.customer_trx_line_id
76: AND ctl.customer_trx_id = p_customer_trx_id