DBA Data[Home] [Help]

APPS.XTR_ACCRUAL_PROCESS_P dependencies on XTR_BANK_ACCOUNTS

Line 3418: from XTR_BANK_ACCOUNTS a,

3414: nvl(a.year_calc_type,'ACTUAL/ACTUAL') year_calc_type,
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

Line 3457: from XTR_BANK_ACCOUNTS a,

3453: -- Oldest CA Transaction
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