67: p_driver_type VARCHAR2,
68: p_driver_value VARCHAR2)
69: IS
70: select count(ap.applicable_pmt_prof_id)
71: from iby_applicable_pmt_profs ap,
72: iby_payment_profiles p
73: where ap.system_profile_code = p.system_profile_code
74: and p.payment_profile_id = p_profile_id
75: and ap.applicable_type_code = p_driver_type
79: p_driver_id_value VARCHAR2,
80: p_driver_type_value VARCHAR2)
81: IS
82: select count(ap.applicable_pmt_prof_id)
83: from iby_applicable_pmt_profs ap,
84: iby_payment_profiles p
85: where ap.system_profile_code = p.system_profile_code
86: and p.payment_profile_id = p_profile_id
87: and ap.applicable_type_code = 'PAYER_ORG'
238: -- Validate payment method for the payemnt profile
239: IF p_payment_method_code is not null THEN
240: select count(ap.applicable_pmt_prof_id)
241: into l_count
242: from iby_applicable_pmt_profs ap,
243: iby_payment_profiles p
244: where ap.system_profile_code = p.system_profile_code
245: and p.payment_profile_id = p_ppp_id
246: and ap.applicable_type_code = 'PAYMENT_METHOD'