APPS.PAY_MAINTAIN_BANK_ACCT dependencies on CE_BANK_ACCT_USES_ALL

Line 38: from ce_bank_acct_uses_all cba

34: p_org_payment_method_id IN number) IS
35:
36: cursor csr_chk_payroll_bank_acct is
37: select cba.payroll_bank_account_id
38: from ce_bank_acct_uses_all cba
39: where cba.Bank_account_id = p_bank_account_id
40: and (-- Check Whether the given CE account is attached to another payroll account.
41: (cba.payroll_bank_account_id <> p_external_account_id and
42: cba.payroll_bank_account_id is not null)

Line 46: from ce_bank_acct_uses_all cbb

42: cba.payroll_bank_account_id is not null)
43: -- Check whether the given Payroll account is attached to more than one CE account.
44: or exists (select Bank_account_id
45: from (select distinct cbb.Bank_account_id
46: from ce_bank_acct_uses_all cbb
47: where cbb.payroll_bank_account_id = p_external_account_id)
48: group by Bank_account_id
49: having count(*) >1));
50: -- Need to check whether the payment is reconcilled.

Line 84: update ce_bank_acct_uses_all

80: if (csr_chk_payroll_bank_acct% NOTFOUND) THEN
81:
82: hr_utility.set_location(l_proc||'Stamping has to be done', 20);
83: hr_utility.set_location(l_proc||'Stamping ....',30);
84: update ce_bank_acct_uses_all
85: set payroll_bank_account_id = p_external_account_id
86: where Bank_account_id = p_bank_account_id;
87: close csr_chk_payroll_bank_acct;
88:

Line 90: update ce_bank_acct_uses_all

86: where Bank_account_id = p_bank_account_id;
87: close csr_chk_payroll_bank_acct;
88:
89: hr_utility.set_location(l_proc||'Nullifying earlier stamping ....',40);
90: update ce_bank_acct_uses_all
91: set payroll_bank_account_id = null
92: where payroll_bank_account_id = p_external_account_id
93: AND Bank_account_id <> p_bank_account_id;
94:

Line 109: update ce_bank_acct_uses_all

105: ELSE
106: OPEN csr_chk_pre_payments_exists;
107: FETCH csr_chk_pre_payments_exists INTO l_dummy;
108: IF (csr_chk_pre_payments_exists % NOTFOUND) THEN
109: update ce_bank_acct_uses_all
110: set payroll_bank_account_id = null
111: where payroll_bank_account_id = p_external_account_id;
112: ELSE
113: fnd_message.set_name('PAY', 'HR_6226_PAYM_PPS_EXIST');

Line 159: ce_bank_acct_uses_all apb,

155: popm.business_group_id
156: from
157: pay_org_payment_methods_f popm,
158: ce_bank_accounts cba,
159: ce_bank_acct_uses_all apb,
160: pay_pre_payments ppp,
161: pay_assignment_actions paa,
162: pay_payroll_actions ppa
163: where

Line 184: ce_bank_acct_uses_all apb,

180: popm.business_group_id
181: from
182: pay_org_payment_methods_f popm,
183: ce_bank_accounts cba,
184: ce_bank_acct_uses_all apb,
185: pay_pre_payments ppp,
186: pay_assignment_actions paa,
187: pay_assignment_actions paa1,
188: pay_payroll_actions ppa,

Line 228: ce_bank_acct_uses_all cbau

224:
225: cursor csr_row_exists(c_external_account_id number) is
226: select 'Y'
227: from ce_bank_accounts cba,
228: ce_bank_acct_uses_all cbau
229: where cba.bank_account_id = cbau.bank_account_id
230: and cbau.payroll_bank_account_id = c_external_account_id
231: and pay_use_allowed_flag = 'Y';
232: begin

Line 258: ce_bank_acct_uses_all cbau

254:
255: select DISTINCT null,null,null,aba.asset_code_combination_id
256: into p_char_of_accounts_id,p_set_of_books_id,p_name,p_asset_ccid
257: from ce_bank_accounts aba,
258: ce_bank_acct_uses_all cbau
259: where aba.bank_account_id = cbau.bank_account_id
260: and cbau.payroll_bank_account_id = p_external_account_id;
261:
262: end get_chart_of_accts_and_sob;

Line 300: ce_bank_acct_uses_all cbau

296: c_validation_end_date date) is
297: select null
298: from pay_org_payment_methods_f opm,
299: ce_bank_accounts cba,
300: ce_bank_acct_uses_all cbau
301: where cba.bank_account_id = cbau.bank_account_id
302: and opm.org_payment_method_id = c_org_payment_method_id
303: and opm.effective_start_date between c_validation_start_date and c_validation_end_date
304: and opm.effective_end_date between c_validation_start_date and c_validation_end_date

Line 331: from ce_bank_acct_uses_all aba

327: is
328:
329: cursor ABA_CUR is
330: select *
331: from ce_bank_acct_uses_all aba
332: where payroll_bank_account_id = p_external_account_id
333: FOR UPDATE OF BANK_ACCOUNT_ID NOWAIT;
334: l_rec ABA_CUR%rowtype;
335: --

Line 363: from ce_bank_acct_uses_all bank_uses,

359: --
360: cursor csr_get_bank_details is
361: select DISTINCT bank_uses.bank_account_id,
362: accounts.bank_account_name
363: from ce_bank_acct_uses_all bank_uses,
364: ce_bank_accounts accounts
365: where bank_uses.payroll_bank_account_id = p_external_account_id
366: and bank_uses.bank_account_id = accounts.bank_account_id
367: and accounts.PAY_USE_ALLOWED_FLAG = 'Y';