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 and

Line 48: from ce_bank_acct_uses_all cbb

44: where org_payment_method_id = p_org_payment_method_id))
45: -- Check whether the given Payroll account is attached to more than one CE account.
46: or exists (select Bank_account_id
47: from (select distinct cbb.Bank_account_id
48: from ce_bank_acct_uses_all cbb
49: where cbb.payroll_bank_account_id = p_external_account_id
50: and cbb.org_id in (select business_group_id from pay_org_payment_methods_f
51: where org_payment_method_id = p_org_payment_method_id))
52: group by Bank_account_id

Line 88: update ce_bank_acct_uses_all

84: if (csr_chk_payroll_bank_acct% NOTFOUND) THEN
85:
86: hr_utility.set_location(l_proc||'Stamping has to be done', 20);
87: hr_utility.set_location(l_proc||'Stamping ....',30);
88: update ce_bank_acct_uses_all
89: set payroll_bank_account_id = p_external_account_id
90: where Bank_account_id = p_bank_account_id
91: and pay_use_enable_flag = 'Y'
92: and org_id in (select business_group_id from pay_org_payment_methods_f

Line 97: update ce_bank_acct_uses_all

93: where org_payment_method_id = p_org_payment_method_id);
94: close csr_chk_payroll_bank_acct;
95:
96: hr_utility.set_location(l_proc||'Nullifying earlier stamping ....',40);
97: update ce_bank_acct_uses_all
98: set payroll_bank_account_id = null
99: where payroll_bank_account_id = p_external_account_id
100: AND Bank_account_id <> p_bank_account_id
101: and org_id in (select business_group_id from pay_org_payment_methods_f

Line 118: update ce_bank_acct_uses_all

114: ELSE
115: OPEN csr_chk_pre_payments_exists;
116: FETCH csr_chk_pre_payments_exists INTO l_dummy;
117: IF (csr_chk_pre_payments_exists % NOTFOUND) THEN
118: update ce_bank_acct_uses_all
119: set payroll_bank_account_id = null
120: where payroll_bank_account_id = p_external_account_id
121: and pay_use_enable_flag = 'Y'
122: and org_id in (select business_group_id from pay_org_payment_methods_f

Line 171: ce_bank_acct_uses_all apb,

167: popm.business_group_id
168: from
169: pay_org_payment_methods_f popm,
170: ce_bank_accounts cba,
171: ce_bank_acct_uses_all apb,
172: pay_pre_payments ppp,
173: pay_assignment_actions paa,
174: pay_payroll_actions ppa
175: where

Line 197: ce_bank_acct_uses_all apb,

193: popm.business_group_id
194: from
195: pay_org_payment_methods_f popm,
196: ce_bank_accounts cba,
197: ce_bank_acct_uses_all apb,
198: pay_pre_payments ppp,
199: pay_assignment_actions paa,
200: pay_assignment_actions paa1,
201: pay_payroll_actions ppa,

Line 243: ce_bank_acct_uses_all cbau

239:
240: cursor csr_row_exists(c_external_account_id number) is
241: select 'Y'
242: from ce_bank_accounts cba,
243: ce_bank_acct_uses_all cbau
244: where cba.bank_account_id = cbau.bank_account_id
245: and cbau.payroll_bank_account_id = c_external_account_id
246: and pay_use_allowed_flag = 'Y'
247: and cbau.org_id = nvl(hr_general.get_business_group_id, cbau.org_id);

Line 274: ce_bank_acct_uses_all cbau

270:
271: select DISTINCT null,null,null,aba.asset_code_combination_id
272: into p_char_of_accounts_id,p_set_of_books_id,p_name,p_asset_ccid
273: from ce_bank_accounts aba,
274: ce_bank_acct_uses_all cbau
275: where aba.bank_account_id = cbau.bank_account_id
276: and cbau.payroll_bank_account_id = p_external_account_id;
277:
278: end get_chart_of_accts_and_sob;

Line 316: ce_bank_acct_uses_all cbau

312: c_validation_end_date date) is
313: select null
314: from pay_org_payment_methods_f opm,
315: ce_bank_accounts cba,
316: ce_bank_acct_uses_all cbau
317: where cba.bank_account_id = cbau.bank_account_id
318: and opm.org_payment_method_id = c_org_payment_method_id
319: and opm.effective_start_date between c_validation_start_date and c_validation_end_date
320: and opm.effective_end_date between c_validation_start_date and c_validation_end_date

Line 349: from ce_bank_acct_uses_all aba

345: is
346:
347: cursor ABA_CUR is
348: select *
349: from ce_bank_acct_uses_all aba
350: where payroll_bank_account_id = p_external_account_id
351: FOR UPDATE OF BANK_ACCOUNT_ID NOWAIT;
352: l_rec ABA_CUR%rowtype;
353: --

Line 381: from ce_bank_acct_uses_all bank_uses,

377: --
378: cursor csr_get_bank_details is
379: select DISTINCT bank_uses.bank_account_id,
380: accounts.bank_account_name
381: from ce_bank_acct_uses_all bank_uses,
382: ce_bank_accounts accounts
383: where bank_uses.payroll_bank_account_id = p_external_account_id
384: and bank_uses.bank_account_id = accounts.bank_account_id
385: and accounts.PAY_USE_ALLOWED_FLAG = 'Y';