APPS.FV_CFS_PKG dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 652: FROM fnd_flex_value_hierarchies

648: CURSOR child_value(seg VARCHAR2,sid NUMBER)
649: IS
650: SELECT child_flex_value_low,
651: child_flex_value_high
652: FROM fnd_flex_value_hierarchies
653: WHERE parent_FLEX_value = seg
654: AND flex_value_set_id = sid;
655:
656: child_rec child_value%ROWTYPE;

Line 796: FROM fnd_flex_value_hierarchies

792: IF v_seg(l_segno) IS NOT NULL THEN
793: --1
794: SELECT COUNT(*)
795: INTO l_cnt
796: FROM fnd_flex_value_hierarchies
797: WHERE parent_FLEX_value = v_seg(l_segno)
798: AND flex_value_set_id = flex_rec.flex_value_set_id;
799: IF (l_cnt > 0) THEN
800: -- 2

Line 899: FROM fnd_flex_value_hierarchies

895: IF v_seg(l_segno) IS NOT NULL THEN
896: /* 1 */
897: SELECT COUNT(*)
898: INTO l_cnt
899: FROM fnd_flex_value_hierarchies
900: WHERE parent_FLEX_value = v_seg(l_segno)
901: AND flex_value_set_id = flex_rec.flex_value_set_id;
902: IF (l_cnt > 0) THEN
903: /* 2 */

Line 1562: FROM fnd_flex_value_hierarchies

1558: WHEN NO_DATA_FOUND THEN
1559: BEGIN
1560: SELECT parent_flex_value
1561: INTO l_account_number
1562: FROM fnd_flex_value_hierarchies
1563: WHERE detail_rec.account_number BETWEEN child_flex_value_low AND child_flex_value_high
1564: AND flex_value_set_id = v_acct_flex_value_set_id
1565: AND ROWNUM = 1;
1566: SELECT SUBSTR(compiled_value_attributes, 5, 1)

Line 3838: FROM fnd_flex_value_hierarchies

3834: WHEN NO_DATA_FOUND THEN
3835: BEGIN
3836: SELECT parent_flex_value
3837: INTO l_account_number
3838: FROM fnd_flex_value_hierarchies
3839: WHERE detail_rec.acct_number BETWEEN child_flex_value_low AND child_flex_value_high
3840: AND flex_value_set_id = v_acct_flex_value_set_id
3841: AND ROWNUM = 1;
3842: SELECT SUBSTR(compiled_value_attributes, 5, 1)