[Home] [Help]
166: paa.action_status,
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
192: paa.action_status,
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,
238: l_exists varchar2(1);
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'
269: begin
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:
311: c_validation_start_date date,
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
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';
386: --