APPS.PAY_US_NACHA_IAT_TAPE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 397: FROM PAY_PERSONAL_PAYMENT_METHODS_F b

393: p_effective_date)
394: WHERE a.PRENOTE_DATE IS NULL
395: AND a.EXTERNAL_ACCOUNT_ID =
396: (SELECT b.EXTERNAL_ACCOUNT_ID
397: FROM PAY_PERSONAL_PAYMENT_METHODS_F b
398: WHERE b.PERSONAL_PAYMENT_METHOD_ID =
399: g_personal_payment_method_id
400: AND p_effective_date BETWEEN b.EFFECTIVE_START_DATE
401: AND b.EFFECTIVE_END_DATE);