DBA Data[Home] [Help]

APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 463: FROM pay_org_payment_methods_f popm

459: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NAME', pea.territory_code),
460: pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
461: pea.segment4,
462: pea.segment2
463: FROM pay_org_payment_methods_f popm
464: , pay_external_accounts pea
465: WHERE org_payment_method_id = p_org_payment_method_id
466: AND popm.external_account_id = pea.external_account_id
467: AND p_effective_date between popm.EFFECTIVE_START_DATE

Line 499: , pay_org_payment_methods_f popm

495: , pay_assignment_actions paa
496: , pay_assignment_actions paa_chq
497: , pay_payroll_actions ppa
498: , pay_payroll_actions ppa_chq
499: , pay_org_payment_methods_f popm
500: WHERE paa_chq.assignment_action_id = cp_chk_action_id
501: and paa_chq.assignment_action_id = pai.locking_action_id
502: and pai.locked_action_id = paa.assignment_action_id
503: and paa.payroll_action_id = ppa.payroll_action_id