APPS.PN_LEASE_PVT dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 18544: FROM fnd_descr_flex_col_usage_vl

18540: l_count NUMBER :=0;
18541: BEGIN
18542: SELECT count(1)
18543: INTO l_count
18544: FROM fnd_descr_flex_col_usage_vl
18545: WHERE descriptive_flexfield_name = UPPER(trim(p_desc_name))
18546: AND enabled_flag = 'Y'
18547: AND display_flag = 'Y';
18548: RETURN l_count;

Line 18577: FROM fnd_descr_flex_col_usage_vl a

18573: AS
18574: CURSOR cur_req_status(p_desc_name VARCHAR2)
18575: IS
18576: SELECT a.*
18577: FROM fnd_descr_flex_col_usage_vl a
18578: WHERE a.descriptive_flexfield_name = trim(p_desc_name)
18579: AND a.enabled_flag = 'Y'
18580: AND a.display_flag = 'Y'
18581: AND a.required_flag = 'Y';