DBA Data[Home] [Help]

APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 268: pay_org_payment_methods_f OPM,

264: per_all_assignments_f asg,
265: pay_payroll_actions pa2,
266: pay_payroll_actions pa1,
267: pay_pre_payments ppp,
268: pay_org_payment_methods_f OPM,
269: pay_payment_types PPT,
270: per_all_people_f pap
271: WHERE pa1.payroll_action_id = p_payroll_action_id
272: AND pa2.consolidation_set_id = p_consolidation_id

Line 411: pay_org_payment_methods_f org

407: IS
408: Select ext.segment1, --Sort Code
409: ext.segment4 --Acc Num
410: From pay_external_accounts ext,
411: pay_org_payment_methods_f org
412: Where org.org_payment_method_id = p_org_payment_method_id
413: and p_effective_date between org.effective_start_date and org.effective_end_date
414: and org.external_account_id = ext.external_account_id;
415: