DBA Data[Home] [Help]

APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on DUAL

Line 29: from dual;

25: -- For example, if l_acct = 'CITI-AAA', then SETOFF_BANK_CODE will return 'AAA'.
26: -- if l_acct = 'CITI', then SETOFF_BANK_CODE will return 'CITI'.
27: cursor SETOFF_BANK_CODE is
28: select substr(L_ACCT,instr(L_ACCT,'-')+1)
29: from dual;
30: */
31:
32: cursor RATE_BASIS is
33: select nvl(INTEREST_CALCULATION_BASIS,'STEP')

Line 920: from DUAL;

916: and COMPANY_CODE = nvl(p_pty_cross_ref,p_party_code);
917: --
918: cursor EXP_NUM is
919: select XTR_DEALS_S.NEXTVAL
920: from DUAL;
921: --
922: l_deal_nos NUMBER;
923:
924: cursor RNDING is