DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 657: from pay_org_payment_methods_f pop,

653: and ppa.payroll_action_id = paa.payroll_action_id;
654: --
655: CURSOR get_banks IS
656: select pea.segment8
657: from pay_org_payment_methods_f pop,
658: pay_personal_payment_methods_f ppp,
659: pay_assignment_actions paa,
660: pay_external_accounts pea,
661: pay_payment_types ppt

Line 787: pay_org_payment_methods_f org

783: IS
784: Select ext.segment3, --Sort Code
785: ext.segment4 --Acc Num
786: From pay_external_accounts ext,
787: pay_org_payment_methods_f org
788: Where org.org_payment_method_id = p_org_payment_method_id
789: and p_effective_date between org.effective_start_date and org.effective_end_date
790: and org.external_account_id = ext.external_account_id;
791: