DBA Data[Home] [Help]

APPS.ARP_PROCESS_HEADER_POST_COMMIT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 208: ra_cust_trx_line_gl_dist lgd,

204: l_ps_rev_cash_id,
205: l_ct_rev_cash_id
206: FROM ar_payment_schedules ps,
207: ra_cust_trx_types ctt,
208: ra_cust_trx_line_gl_dist lgd,
209: ra_customer_trx ct
210: WHERE ct.customer_trx_id = ps.customer_trx_id(+)
211: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
212: AND ct.customer_trx_id = lgd.customer_trx_id

Line 677: | ra_cust_trx_line_gl_dist is NULL. We need to check |

673: +----------------------------------------------------------------------------------*/
674:
675: /*--------------------------------------------------------------------------+
676: | Bug Fix 620760: when no-post-to-GL, the gl_date in |
677: | ra_cust_trx_line_gl_dist is NULL. We need to check |
678: | for this before comparing to see if the gl_date has |
679: | changed. |
680: +--------------------------------------------------------------------------*/
681:

Line 726: ra_cust_trx_line_gl_dist lgd,

722: INTO l_recreate_ps_flag,
723: l_term_changed_flag
724: FROM ar_payment_schedules ps,
725: ra_cust_trx_types ctt,
726: ra_cust_trx_line_gl_dist lgd,
727: ra_customer_trx ct
728: WHERE ct.customer_trx_id = ps.customer_trx_id(+)
729: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
730: AND ct.customer_trx_id = lgd.customer_trx_id