APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_CMN_JOURNAL_ENTRIES

Line 177: SELECT 'Y' FROM jai_cmn_journal_entries

173: WHERE invoice_id = pr_new.invoice_id;
174: --start additions for bug#16241506
175: cursor get_acct_exists(CP_INVOICE_DISTIRBUTION_ID in number)
176: is
177: SELECT 'Y' FROM jai_cmn_journal_entries
178: WHERE regime_code='SERVICE'
179: AND source='AP'
180: AND source_table_name='AP_INVOICE_DISTRIBUTIONS_ALL'
181: AND SOURCE_TRX_ID=CP_INVOICE_DISTIRBUTION_ID;