DBA Data[Home] [Help]

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on AR_LOOKUPS

Line 308: CURSOR cur_get_disc_ccid (cp_type AR_RECEIVABLES_TRX_ALL.TYPE%TYPE,p_lookup_type ar_lookups.lookup_type%type,p_status ar_receivables_trx_all.status%TYPE )--rchandan for bug#4428980

304: WHERE
305: receivable_application_id = p_receivable_application_id AND
306: org_id = p_org_id;
307:
308: CURSOR cur_get_disc_ccid (cp_type AR_RECEIVABLES_TRX_ALL.TYPE%TYPE,p_lookup_type ar_lookups.lookup_type%type,p_status ar_receivables_trx_all.status%TYPE )--rchandan for bug#4428980
309: IS
310: SELECT
311: code_combination_id
312: FROM

Line 314: ar_lookups lkup

310: SELECT
311: code_combination_id
312: FROM
313: ar_receivables_trx_all rtrx,
314: ar_lookups lkup
315: WHERE
316: rtrx.type = lkup.lookup_code AND
317: lkup.lookup_code = cp_type AND
318: lkup.lookup_type = p_lookup_type AND --rchandan for bug#4428980