APPS.JAI_CMN_RPT_BBR_PKG dependencies on AP_CHECKS_ALL

Line 118: lv_negotiable ap_checks_all.status_lookup_code%TYPE;

114:
115: /* Added by Ramananda for bug#4407165 */
116: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rpt_bbr_pkg.get_debit_balance';
117:
118: lv_negotiable ap_checks_all.status_lookup_code%TYPE;
119: lv_cleared ap_checks_all.status_lookup_code%TYPE;
120: lv_voided ap_checks_all.status_lookup_code%TYPE;
121:
122: lv_src_payables gl_je_headers.je_source%type ;

Line 119: lv_cleared ap_checks_all.status_lookup_code%TYPE;

115: /* Added by Ramananda for bug#4407165 */
116: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rpt_bbr_pkg.get_debit_balance';
117:
118: lv_negotiable ap_checks_all.status_lookup_code%TYPE;
119: lv_cleared ap_checks_all.status_lookup_code%TYPE;
120: lv_voided ap_checks_all.status_lookup_code%TYPE;
121:
122: lv_src_payables gl_je_headers.je_source%type ;
123: lv_src_rcv gl_je_headers.je_source%type ;

Line 120: lv_voided ap_checks_all.status_lookup_code%TYPE;

116: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rpt_bbr_pkg.get_debit_balance';
117:
118: lv_negotiable ap_checks_all.status_lookup_code%TYPE;
119: lv_cleared ap_checks_all.status_lookup_code%TYPE;
120: lv_voided ap_checks_all.status_lookup_code%TYPE;
121:
122: lv_src_payables gl_je_headers.je_source%type ;
123: lv_src_rcv gl_je_headers.je_source%type ;
124:

Line 138: ap_checks_all apc,

134:
135: SELECT SUM(NVL(aip.amount, 0)*NVL(aip.exchange_rate,1)) INTO amt /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
136: FROM ap_invoice_payments_all aip,
137: ap_invoices_all api,
138: ap_checks_all apc,
139: ce_bank_accounts ceba
140: WHERE api.invoice_id = aip.invoice_id
141: AND aip.check_id = apc.check_id
142: AND apc.bank_account_id = ceba.bank_account_id