APPS.IBY_FD_USER_API_PUB dependencies on IBY_PAYMENT_PROFILES

Line 72: iby_payment_profiles p

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

Line 84: iby_payment_profiles p

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

Line 171: from IBY_PAYMENT_PROFILES

167: print_debuginfo(l_module_name,'Payment profile ' || p_ppp_id || ' is to be validated.');
168:
169: select payment_profile_name
170: into l_profile_name
171: from IBY_PAYMENT_PROFILES
172: where payment_profile_id = p_ppp_id;
173:
174: -- Validate legal entities for the payment profile
175: IF (p_int_bank_acc_arr.COUNT > 0) THEN

Line 243: iby_payment_profiles p

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

Line 276: from iby_payment_profiles

272: select nvl(DEFAULT_PAYMENT_DOCUMENT_ID, -1),
273: processing_type
274: into l_payment_document_id,
275: l_proc_type
276: from iby_payment_profiles
277: where payment_profile_id = p_ppp_id;
278:
279: IF (l_payment_document_id = -1) and
280: (l_proc_type = 'PRINTED') THEN

Line 626: iby_payment_profiles pp,

622: f.format_name
623: into x_default_sra_format_code,
624: x_default_sra_format_name
625: from iby_pay_instructions_all ins,
626: iby_payment_profiles pp,
627: iby_remit_advice_setup sra_setup,
628: iby_formats_vl f
629: where ins.payment_instruction_id = p_instr_id
630: and pp.payment_profile_id = ins.payment_profile_id

Line 722: FROM iby_pay_instructions_all inst, iby_payment_profiles pp

718: BEGIN
719:
720: SELECT inst.payments_complete_code, pp.mark_complete_event
721: INTO l_complete_code, l_mark_complete_event
722: FROM iby_pay_instructions_all inst, iby_payment_profiles pp
723: WHERE inst.payment_profile_id = pp.payment_profile_id
724: AND inst.payment_instruction_id = p_instruction_id;
725:
726: IF (l_complete_code = 'YES') THEN