DBA Data[Home] [Help]

APPS.ARP_INSERT_DIST_COVER dependencies on AR_REVENUE_ASSIGNMENTS

Line 341: | Resets original GL date to valid value from ar_revenue_assignments if |

337: | FUNCTION |
338: | set_original_gl_date |
339: | |
340: | DESCRIPTION |
341: | Resets original GL date to valid value from ar_revenue_assignments if |
342: | a rule based invoice line to ensure the credit memo module will pick |
343: | up the distribution when a credit memo is created. |
344: | Distributions on rule based invoice lines have been manually entered |
345: | via the Distributions window in ARXTWMAI. |

Line 388: FROM ar_revenue_assignments ra,

384: AND ctl.customer_trx_line_id = p_customer_trx_line_id;
385:
386: CURSOR c_valid_rule_gl_date IS
387: SELECT ra.gl_date
388: FROM ar_revenue_assignments ra,
389: gl_sets_of_books sob,
390: ar_system_parameters sp
391: WHERE ra.customer_trx_line_id = p_customer_trx_line_id
392: AND sob.set_of_books_id = sp.set_of_books_id