APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 56: from fnd_descr_flex_column_usages c, hxc_mapping_components mpc

52: cursor c_input_value_name
53: (p_ele_type_id in number
54: ,p_ipv_segment in VARCHAR2) is
55: select end_user_column_name
56: from fnd_descr_flex_column_usages c, hxc_mapping_components mpc
57: where c.application_id = 809
58: and c.descriptive_flexfield_name = 'OTC Information Types'
59: and c.descriptive_flex_context_code = 'ELEMENT - '||to_char(p_ele_type_id)
60: and c.application_column_name = mpc.segment

Line 763: from fnd_descr_flex_column_usages c

759: and pet.effective_end_date;
760:
761: CURSOR c_chk_otc_information_type ( p_element_type_id NUMBER ) IS
762: select 'Y'
763: from fnd_descr_flex_column_usages c
764: where c.application_id = 809
765: and c.descriptive_flexfield_name = 'OTC Information Types'
766: and c.descriptive_flex_context_code = 'ELEMENT - '||p_element_type_id;
767:

Line 1084: , fnd_descr_flex_column_usages fdfcu

1080: p_iv_id NUMBER)
1081: IS
1082: SELECT to_number (replace (fdfcu.application_column_name, 'ATTRIBUTE')) otl_sequence
1083: FROM pay_input_values_f iv
1084: , fnd_descr_flex_column_usages fdfcu
1085: WHERE p_effective_date
1086: BETWEEN iv.effective_start_date
1087: AND iv.effective_end_date
1088: AND iv.element_type_id = p_element_type_id