APPS.CE_INTEREST_SCHED_PKG dependencies on CE_BANK_ACCOUNTS

Line 14: , CE_BANK_ACCOUNTS BA

10: CURSOR SCHED_XTR_ACCTS(P_INTEREST_SCHEDULE_ID NUMBER,
11: P_BANK_ACCOUNT_ID NUMBER) IS
12: SELECT BA.BANK_ACCOUNT_ID
13: FROM CE_BANK_ACCT_USES_ALL BAU
14: , CE_BANK_ACCOUNTS BA
15: WHERE
16: BA.BANK_ACCOUNT_ID = BAU.BANK_ACCOUNT_ID
17: AND BAU.XTR_USE_ENABLE_FLAG = 'Y'
18: AND BA.INTEREST_SCHEDULE_ID = P_INTEREST_SCHEDULE_ID

Line 95: | CE_BANK_ACCOUNTS |

91: | delete_schedule |
92: | |
93: | DESCRIPTION |
94: | remove bank accounts that has been assign to schedule |
95: | CE_BANK_ACCOUNTS |
96: --------------------------------------------------------------------- */
97: PROCEDURE remove_schedule_account(p_interest_schedule_id IN number,
98: p_bank_account_id IN number,
99: x_return_status IN OUT NOCOPY VARCHAR2,

Line 113: UPDATE CE_BANK_ACCOUNTS

109: -- initialize API return status to success.
110: x_return_status := fnd_api.g_ret_sts_success;
111:
112: IF (p_interest_schedule_id is not null and p_bank_account_id is not null) THEN
113: UPDATE CE_BANK_ACCOUNTS
114: SET INTEREST_SCHEDULE_ID = NULL
115: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id
116: and BANK_ACCOUNT_ID = p_bank_account_id;
117: ELSIF (p_interest_schedule_id is not null and p_bank_account_id is null) THEN

Line 118: UPDATE CE_BANK_ACCOUNTS

114: SET INTEREST_SCHEDULE_ID = NULL
115: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id
116: and BANK_ACCOUNT_ID = p_bank_account_id;
117: ELSIF (p_interest_schedule_id is not null and p_bank_account_id is null) THEN
118: UPDATE CE_BANK_ACCOUNTS
119: SET INTEREST_SCHEDULE_ID = NULL
120: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id;
121:
122: END IF;

Line 174: | CE_BANK_ACCOUNTS |

170: | InterestAMImpl (ScheduleBankAcctPG/CO) |
171: | |
172: | DESCRIPTION |
173: | assign bank accounts for the interest schedule |
174: | CE_BANK_ACCOUNTS |
175: --------------------------------------------------------------------- */
176: PROCEDURE assign_schedule_account(p_interest_schedule_id IN number,
177: p_bank_account_id IN number,
178: p_basis IN varchar2,

Line 199: from CE_BANK_ACCOUNTS

195:
196: IF (p_interest_schedule_id is not null ) THEN
197: SELECT count(1)
198: into x_ba_count
199: from CE_BANK_ACCOUNTS
200: WHERE
201: nvl(interest_schedule_id, 1) = p_interest_schedule_id
202: and bank_account_id = p_bank_account_id;
203:

Line 209: UPDATE CE_BANK_ACCOUNTS

205: FND_MESSAGE.Set_Name('CE', 'CE_ACCT_IS_ASSIGNED');
206: --FND_MESSAGE.Set_Token('PROCEDURE', 'CE_INTEREST_SCHED_PKG.assign_schedule_account');
207: fnd_msg_pub.add;
208: ELSE
209: UPDATE CE_BANK_ACCOUNTS
210: SET INTEREST_SCHEDULE_ID = p_interest_schedule_id
211: WHERE INTEREST_SCHEDULE_ID is null
212: and BANK_ACCOUNT_ID = p_bank_account_id;
213: