DBA Data[Home] [Help]

APPS.JAI_AR_GLDIST_TRIGGER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

|| data still lies in ja_in_temp_line_insert
|| This includes both Imported and Manual tramsactions
*/
CURSOR cur_get_temp_row
IS
SELECT
        1
FROM
        JAI_AR_TRX_INS_LINES_T
WHERE
        customer_trx_id  =  pr_new.customer_trx_id
AND     error_flag       <> 'D'; /* Modified by Ramananda for removal of SQL LITERALs */