APPS.JG_ZZ_GLOBAL_FLEX_VALD_PKG dependencies on FND_DESCRIPTIVE_FLEXS

Line 37: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;

33: p_desc_flex_name IN VARCHAR2,
34: p_return_status IN OUT NOCOPY varchar2
35: ) IS
36:
37: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
38: l_count NUMBER;
39: l_col_name VARCHAR2(50);
40: l_flex_exists VARCHAR2(1);
41: CURSOR desc_flex_exists IS

Line 43: FROM fnd_descriptive_flexs

39: l_col_name VARCHAR2(50);
40: l_flex_exists VARCHAR2(1);
41: CURSOR desc_flex_exists IS
42: SELECT 'Y'
43: FROM fnd_descriptive_flexs
44: WHERE application_id = 7003
45: and descriptive_flexfield_name = p_desc_flex_name;
46: BEGIN
47: IF PG_DEBUG in ('Y', 'C') THEN