APPS.XTR_ACCRUAL_PROCESS_P dependencies on XTR_BANK_BALANCES

Line 3419: XTR_BANK_BALANCES b

3415: decode(b.DAY_COUNT_TYPE,'F','PRIOR','L','FOLLOWING','B') day_count_type, -- AW Japan Project
3416: nvl(b.ROUNDING_TYPE,'R') rounding_type, -- AW Japan Project
3417: decode(nvl(b.DAY_COUNT_TYPE,'L'),'F',1,0) forward_adjust -- AW Japan Project
3418: from XTR_BANK_ACCOUNTS a,
3419: XTR_BANK_BALANCES b
3420: where b.COMPANY_CODE = p_company
3421: and a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER
3422: and a.PARTY_CODE = b.COMPANY_CODE
3423: --and nvl(a.SETOFF_ACCOUNT_YN,'N') <> 'Y'

Line 3425: from XTR_BANK_BALANCES c

3421: and a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER
3422: and a.PARTY_CODE = b.COMPANY_CODE
3423: --and nvl(a.SETOFF_ACCOUNT_YN,'N') <> 'Y'
3424: and b.BALANCE_DATE = (select max(c.BALANCE_DATE)
3425: from XTR_BANK_BALANCES c
3426: where c.BALANCE_DATE <= p_end_date
3427: and c.COMPANY_CODE = b.COMPANY_CODE
3428: and c.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER)
3429: order by a.CURRENCY,a.ACCOUNT_NUMBER;

Line 3458: XTR_BANK_BALANCES b

3454: ------------------------------------
3455: cursor CA_OLDEST (v_acct_no VARCHAR2, v_ccy VARCHAR2, v_comp VARCHAR2) is
3456: select b.BALANCE_DATE
3457: from XTR_BANK_ACCOUNTS a,
3458: XTR_BANK_BALANCES b
3459: where b.COMPANY_CODE = v_comp
3460: and a.PARTY_CODE = v_comp
3461: and a.ACCOUNT_NUMBER = v_acct_no
3462: and a.CURRENCY = v_ccy