APPS.PAY_KR_RULES dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 52: pay_org_payment_methods_f_tl ppmtl,

48: --
49: cursor csr_pay_meth_name is
50: select ppmtl.org_payment_method_name
51: from
52: pay_org_payment_methods_f_tl ppmtl,
53: pay_org_payment_methods_f ppm
54: where
55: ppmtl.org_payment_method_id = p_org_meth
56: and ppm.org_payment_method_id = p_org_meth

Line 53: pay_org_payment_methods_f ppm

49: cursor csr_pay_meth_name is
50: select ppmtl.org_payment_method_name
51: from
52: pay_org_payment_methods_f_tl ppmtl,
53: pay_org_payment_methods_f ppm
54: where
55: ppmtl.org_payment_method_id = p_org_meth
56: and ppm.org_payment_method_id = p_org_meth
57: and ppm.external_account_id is null

Line 61: l_pay_meth_name pay_org_payment_methods_f_tl.org_payment_method_name%type ;

57: and ppm.external_account_id is null
58: and ppmtl.language = userenv('LANG')
59: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date ;
60: --
61: l_pay_meth_name pay_org_payment_methods_f_tl.org_payment_method_name%type ;
62: --
63: begin
64: --
65: open csr_pay_meth_name ;