APPS.PAY_QPU_API dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 216: -- 1) The p_org_payment_method must exist in pay_org_payment_methods_f as

212: --
213: -- Post Failure:
214: -- An error is raised if any of the following conditions are not met:
215: -- if p_org_payment_method_id is not null then
216: -- 1) The p_org_payment_method must exist in pay_org_payment_methods_f as
217: -- of the QuickPay Run date paid.
218: -- 2) The p_org_payment_method must be in the same business group as
219: -- the QuickPay Pre-Payment.
220: -- 3) The p_org_payment_method must not have a payment category of magnetic

Line 240: from pay_org_payment_methods_f org

236: l_proc varchar2(72) := g_package||'chk_org_payment_method_id';
237: --
238: cursor csr_org_met is
239: select 'Y'
240: from pay_org_payment_methods_f org
241: where org.org_payment_method_id = p_org_payment_method_id
242: and org.business_group_id = p_business_group_id
243: and p_effective_date between org.effective_start_date
244: and org.effective_end_date;

Line 248: from pay_org_payment_methods_f org

244: and org.effective_end_date;
245: --
246: cursor csr_pay_type is
247: select 'Y'
248: from pay_org_payment_methods_f org
249: , pay_payment_types typ
250: where org.org_payment_method_id = p_org_payment_method_id
251: and typ.payment_type_id = org.payment_type_id
252: and typ.category = 'MT'

Line 261: -- Check that org_payment_method_id exists in pay_org_payment_methods_f

257: hr_utility.set_location('Entering:'|| l_proc, 5);
258: if p_org_payment_method_id is not null then
259: hr_utility.set_location(l_proc, 6);
260: --
261: -- Check that org_payment_method_id exists in pay_org_payment_methods_f
262: -- as of the effective_date (date paid). Also it must be in the same
263: -- business group as the QuickPay Pre-payment.
264: --
265: open csr_org_met;