DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 218: ,fnd_descr_flex_column_usages fcu

214:
215: CURSOR csr_get_tag_name (p_org_meth_id number,p_eff_date date ,p_tag_name varchar2) IS
216: select fcu.end_user_column_name
217: from pay_org_payment_methods_f opm
218: ,fnd_descr_flex_column_usages fcu
219: where opm.org_payment_method_id=p_org_meth_id
220: and fcu.descriptive_flex_context_code=opm.pmeth_information_category
221: and fcu.application_column_name =p_tag_name
222: and p_eff_date between opm.effective_start_date and effective_end_date;

Line 238: ,fnd_descr_flex_column_usages fcu

234:
235: CURSOR csr_get_tag_name (p_per_meth_id number,p_eff_date date ,p_tag_name varchar2) IS
236: select fcu.end_user_column_name
237: from pay_personal_payment_methods_f ppm
238: ,fnd_descr_flex_column_usages fcu
239: where ppm.personal_payment_method_id=p_per_meth_id
240: and fcu.descriptive_flex_context_code=ppm.ppm_information_category
241: and fcu.application_column_name =p_tag_name
242: and p_eff_date between ppm.effective_start_date and effective_end_date;