APPS.FV_CFS_PKG dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 343: FROM fnd_flex_value_hierarchies

339: AND id_flex_num = v_chart_of_accounts_id;
340:
341: CURSOR child_value(seg varchar2,sid number) IS
342: SELECT child_flex_value_low,child_flex_value_high
343: FROM fnd_flex_value_hierarchies
344: WHERE parent_FLEX_value = seg
345: AND flex_value_set_id = sid;
346:
347: child_rec child_value%ROWTYPE;

Line 431: FROM fnd_flex_value_hierarchies

427: l_segno := substr(flex_rec.application_column_name,8,2);
428: If v_seg(l_segno) is not null then /* 1 */
429:
430: select count(*) into l_cnt
431: FROM fnd_flex_value_hierarchies
432: where parent_FLEX_value = v_seg(l_segno)
433: AND flex_value_set_id = flex_rec.flex_value_set_id;
434:
435: if (l_cnt > 0) then /* 2 */

Line 1054: FROM fnd_flex_value_hierarchies

1050: WHEN NO_DATA_FOUND THEN
1051: BEGIN
1052: SELECT parent_flex_value
1053: INTO l_account_number
1054: FROM fnd_flex_value_hierarchies
1055: WHERE detail_rec.account_number
1056: BETWEEN child_flex_value_low AND child_flex_value_high
1057: AND flex_value_set_id = v_acct_flex_value_set_id
1058: AND ROWNUM = 1;