APPS.IBY_FD_USER_API_PUB dependencies on IBY_PAYMENT_PROFILES

Line 60: iby_payment_profiles p

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
64: and (ap.applicable_value_to is null OR ap.applicable_value_to = p_driver_value);

Line 72: iby_payment_profiles p

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'
76: and ((ap.applicable_value_to is null AND ap.applicable_value_from is null) OR

Line 159: from IBY_PAYMENT_PROFILES

155: print_debuginfo(l_module_name,'Payment profile ' || p_ppp_id || ' is to be validated.');
156:
157: select payment_profile_name
158: into l_profile_name
159: from IBY_PAYMENT_PROFILES
160: where payment_profile_id = p_ppp_id;
161:
162: -- Validate legal entities for the payment profile
163: IF (p_int_bank_acc_arr.COUNT > 0) THEN

Line 231: iby_payment_profiles p

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'
235: and (ap.applicable_value_to is null OR ap.applicable_value_to = p_payment_method_code);

Line 262: from iby_payment_profiles

258: select nvl(DEFAULT_PAYMENT_DOCUMENT_ID, -1),
259: processing_type
260: into l_payment_document_id,
261: l_proc_type
262: from iby_payment_profiles
263: where payment_profile_id = p_ppp_id;
264:
265: IF (l_payment_document_id = -1) and
266: (l_proc_type = 'PRINTED') THEN

Line 486: iby_payment_profiles pp,

482: f.format_name
483: into x_default_sra_format_code,
484: x_default_sra_format_name
485: from iby_pay_instructions_all ins,
486: iby_payment_profiles pp,
487: iby_remit_advice_setup sra_setup,
488: iby_formats_vl f
489: where ins.payment_instruction_id = p_instr_id
490: and pp.payment_profile_id = ins.payment_profile_id