DBA Data[Home] [Help]

APPS.IBY_FD_USER_API_PUB dependencies on IBY_APPLICABLE_PMT_PROFS

Line 71: from iby_applicable_pmt_profs ap,

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

Line 83: from iby_applicable_pmt_profs ap,

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'

Line 242: from iby_applicable_pmt_profs ap,

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'