eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on FND_DESCR_FLEX_COLUMN_USAGES

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 758: from fnd_descr_flex_column_usages c

754: and pet.effective_end_date;
755:
756: CURSOR c_chk_otc_information_type ( p_element_type_id NUMBER ) IS
757: select 'Y'
758: from fnd_descr_flex_column_usages c
759: where c.application_id = 809
760: and c.descriptive_flexfield_name = 'OTC Information Types'
761: and c.descriptive_flex_context_code = 'ELEMENT - '||p_element_type_id;
762:

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