DBA Data[Home] [Help]

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on AR_LOOKUPS

Line 610: 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

606: WHERE
607: receivable_application_id = p_receivable_application_id AND
608: org_id = p_org_id;
609:
610: 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
611: IS
612: SELECT
613: code_combination_id
614: FROM

Line 616: ar_lookups lkup

612: SELECT
613: code_combination_id
614: FROM
615: ar_receivables_trx_all rtrx,
616: ar_lookups lkup
617: WHERE
618: rtrx.type = lkup.lookup_code AND
619: lkup.lookup_code = cp_type AND
620: lkup.lookup_type = p_lookup_type AND --rchandan for bug#4428980