APPS.PAY_GB_BACS_TAPE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 660: pay_external_accounts pea,

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
662: where paa.assignment_action_id =
663: p_assignment_action_id
664: and ppp.assignment_id =

Line 696: sql_str pay_external_accounts.segment8%TYPE;

692: --
693: proc_date DATE;
694: eff_date DATE;
695: dd_date DATE := p_process_date;
696: sql_str pay_external_accounts.segment8%TYPE;
697: lowest_dd_date DATE := dd_date;
698: assignmt_id number;
699: scl_pay_gb_bacs_pay_rule VARCHAR2(1) := 'N';
700: --

Line 786: From pay_external_accounts ext,

782: CURSOR c_get_conc_ident
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;