APPS.JAI_CMN_RPT_BBR_PKG dependencies on GL_JE_HEADERS

Line 39: lv_src_payables gl_je_headers.je_source%type ;

35: lv_status_remitted ar_cash_receipt_history_all.status%type ;
36: lv_status_confirmed ar_cash_receipt_history_all.status%type ;
37: lv_status_reversed ar_cash_receipt_history_all.status%type ;
38:
39: lv_src_payables gl_je_headers.je_source%type ;
40: lv_src_rcv gl_je_headers.je_source%type ;
41:
42:
43: BEGIN

Line 40: lv_src_rcv gl_je_headers.je_source%type ;

36: lv_status_confirmed ar_cash_receipt_history_all.status%type ;
37: lv_status_reversed ar_cash_receipt_history_all.status%type ;
38:
39: lv_src_payables gl_je_headers.je_source%type ;
40: lv_src_rcv gl_je_headers.je_source%type ;
41:
42:
43: BEGIN
44:

Line 75: FROM gl_je_headers glh,

71: AND (acr.org_id = b_org_id OR acr.org_id IS NULL);
72: --SRW.message(3, to_char(NVL(amt, 0)));
73:
74: SELECT SUM(accounted_dr) INTO amt1
75: FROM gl_je_headers glh,
76: gl_je_lines gll,
77: ce_gl_accounts_ccid cega,
78: ce_bank_acct_uses_all cebau,
79: ce_bank_accounts ceba

Line 122: lv_src_payables gl_je_headers.je_source%type ;

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:
125: --Stored function to calculate the o/b and c/b for Cash and Bank Book report
126: BEGIN

Line 123: lv_src_rcv gl_je_headers.je_source%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:
125: --Stored function to calculate the o/b and c/b for Cash and Bank Book report
126: BEGIN
127:

Line 150: FROM gl_je_headers glh,

146: AND TRUNC(aip.accounting_date ) < TRUNC(b_start_date)
147: AND (api.org_id = b_org_id OR api.org_id IS NULL);
148: --SRW.message(1, to_char(NVL(amt, 0)));
149: SELECT SUM(accounted_cr) INTO amt1
150: FROM gl_je_headers glh,
151: gl_je_lines gll,
152: ce_gl_accounts_ccid cega,
153: ce_bank_acct_uses_all cebau,
154: ce_bank_accounts ceba