DBA Data[Home] [Help]

APPS.IGI_EXP_UTILS dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 1023: UPDATE ra_cust_trx_line_gl_dist rgd

1019: -------------------------------------------------------
1020:
1021: /* shsaxena bug.2777575 START */
1022:
1023: UPDATE ra_cust_trx_line_gl_dist rgd
1024: SET rgd.gl_date = TRUNC(p_gl_date),
1025: rgd.last_update_login = NVL(fnd_profile.value('LOGIN_ID'),-1),
1026: rgd.last_update_date = SYSDATE,
1027: rgd.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)

Line 1038: (SELECT 'x' FROM ra_cust_trx_line_gl_dist rgd

1034: rct.last_update_date = SYSDATE,
1035: rct.last_updated_by = NVL(fnd_profile.value('USER_ID'),-1)
1036: WHERE rct.customer_trx_id = r_ar_trx.customer_trx_id
1037: AND EXISTS
1038: (SELECT 'x' FROM ra_cust_trx_line_gl_dist rgd
1039: WHERE rgd.customer_trx_id = rct.customer_trx_id
1040: AND rgd.gl_posted_date IS NULL);
1041:
1042: /* shsaxena bug.2777575 END */