APPS.JG_GL_ACCT_HIER_PKG dependencies on FND_FLEX_VALUES

Line 511: FROM FND_FLEX_VALUES_VL

507: CURSOR top_parent IS
508: SELECT flex_value, description, enabled_flag, summary_flag,
509: substr(compiled_value_attributes,5,1) account_type,
510: flex_value_set_id, start_date_active, end_date_active
511: FROM FND_FLEX_VALUES_VL
512: WHERE flex_value_set_id = p_value_set_id
513: AND DECODE(p_top_parent_acct,'','1',flex_value) = DECODE(p_top_parent_acct,'','1',p_top_parent_acct);
514:
515: CURSOR next_level_flex(v_level NUMBER) IS

Line 525: FROM FND_FLEX_VALUES_VL f

521: AND nvl(gt.hierarchy_level, -1) = v_level
522: AND gt.child_value = f.flex_value
523: AND EXISTS( SELECT distinct 1 FROM JG_ZZ_GL_ACCT_HIER_GT gt2
524: WHERE gt2.PARENT_VALUE = gt.CHILD_VALUE)),0) record_exists
525: FROM FND_FLEX_VALUES_VL f
526: WHERE flex_value_set_id = p_value_set_id
527: AND flex_value IN (SELECT gt.child_value
528: FROM JG_ZZ_GL_ACCT_HIER_GT gt
529: WHERE gt.summary_flag = 'Y'

Line 534: FROM FND_FLEX_VALUES_VL b, FND_FLEX_VALUE_NORM_HIERARCHY a

530: AND nvl(gt.hierarchy_level, -1) = v_level);
531:
532: CURSOR flex_child(v_flex_parent VARCHAR2) IS
533: SELECT b.flex_value, b.summary_flag
534: FROM FND_FLEX_VALUES_VL b, FND_FLEX_VALUE_NORM_HIERARCHY a
535: WHERE a.flex_value_set_id = p_value_set_id
536: AND a.parent_flex_value = v_flex_parent
537: AND b.flex_value_set_id = p_value_set_id
538: AND b.flex_value IN

Line 540: FROM FND_FLEX_VALUES c

536: AND a.parent_flex_value = v_flex_parent
537: AND b.flex_value_set_id = p_value_set_id
538: AND b.flex_value IN
539: (SELECT c.flex_value
540: FROM FND_FLEX_VALUES c
541: WHERE c.flex_value BETWEEN a.child_flex_value_low
542: AND a.child_flex_value_high
543: AND c.flex_value_set_id = a.flex_value_set_id
544: AND DECODE(a.range_attribute, 'P', 'Y', 'N') = c.summary_flag);