DBA Data[Home] [Help]

APPS.ARP_PROCESS_HEADER_POST_COMMIT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 209: ra_cust_trx_line_gl_dist lgd,

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

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

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

Line 728: ra_cust_trx_line_gl_dist lgd,

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