DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on HXC_MAPPING_COMPONENTS

Line 54: from fnd_descr_flex_column_usages c, hxc_mapping_components mpc

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

Line 1060: from fnd_descr_flex_column_usages c, hxc_mapping_components mpc

1056:
1057: CURSOR c_get_atttribute_num( p_element_type_id NUMBER,p_iv_seq VARCHAR2)
1058: is
1059: select 'Y'
1060: from fnd_descr_flex_column_usages c, hxc_mapping_components mpc
1061: where c.application_id = 809
1062: and c.descriptive_flexfield_name = 'OTC Information Types'
1063: and c.descriptive_flex_context_code = 'ELEMENT - '||p_element_type_id
1064: and c.application_column_name = mpc.segment