[Home] [Help]
154: paa.action_status,
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
179: paa.action_status,
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,
223: l_exists varchar2(1);
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';
253: begin
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:
295: c_validation_start_date date,
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
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';
368: --