APPS.IBY_FD_USER_API_PUB dependencies on IBY_APPLICABLE_PMT_PROFS

Line 59: from iby_applicable_pmt_profs ap,

55: p_driver_type VARCHAR2,
56: p_driver_value VARCHAR2)
57: IS
58: select count(ap.applicable_pmt_prof_id)
59: from iby_applicable_pmt_profs ap,
60: iby_payment_profiles p
61: where ap.system_profile_code = p.system_profile_code
62: and p.payment_profile_id = p_profile_id
63: and ap.applicable_type_code = p_driver_type

Line 71: from iby_applicable_pmt_profs ap,

67: p_driver_id_value VARCHAR2,
68: p_driver_type_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 = 'PAYER_ORG'

Line 230: from iby_applicable_pmt_profs ap,

226: -- Validate payment method for the payemnt profile
227: IF p_payment_method_code is not null THEN
228: select count(ap.applicable_pmt_prof_id)
229: into l_count
230: from iby_applicable_pmt_profs ap,
231: iby_payment_profiles p
232: where ap.system_profile_code = p.system_profile_code
233: and p.payment_profile_id = p_ppp_id
234: and ap.applicable_type_code = 'PAYMENT_METHOD'