DBA Data[Home] [Help]

APPS.FV_CFS_PKG dependencies on FND_FLEX_VALUES

Line 1554: FROM fnd_flex_values

1550: IF detail_rec.account_number IS NOT NULL THEN
1551: BEGIN
1552: SELECT SUBSTR(compiled_value_attributes, 5, 1)
1553: INTO l_account_type
1554: FROM fnd_flex_values
1555: WHERE flex_value = detail_rec.account_number
1556: AND flex_value_set_id = v_acct_flex_value_set_id;
1557: EXCEPTION
1558: WHEN NO_DATA_FOUND THEN

Line 1568: FROM fnd_flex_values

1564: AND flex_value_set_id = v_acct_flex_value_set_id
1565: AND ROWNUM = 1;
1566: SELECT SUBSTR(compiled_value_attributes, 5, 1)
1567: INTO l_account_type
1568: FROM fnd_flex_values
1569: WHERE flex_value = l_account_number
1570: AND flex_value_set_id = v_acct_flex_value_set_id;
1571: EXCEPTION
1572: WHEN NO_DATA_FOUND THEN

Line 3830: FROM fnd_flex_values

3826: IF detail_rec.acct_number IS NOT NULL THEN
3827: BEGIN
3828: SELECT SUBSTR(compiled_value_attributes, 5, 1)
3829: INTO l_account_type
3830: FROM fnd_flex_values
3831: WHERE flex_value = detail_rec.acct_number
3832: AND flex_value_set_id = v_acct_flex_value_set_id;
3833: EXCEPTION
3834: WHEN NO_DATA_FOUND THEN

Line 3844: FROM fnd_flex_values

3840: AND flex_value_set_id = v_acct_flex_value_set_id
3841: AND ROWNUM = 1;
3842: SELECT SUBSTR(compiled_value_attributes, 5, 1)
3843: INTO l_account_type
3844: FROM fnd_flex_values
3845: WHERE flex_value = l_account_number
3846: AND flex_value_set_id = v_acct_flex_value_set_id;
3847: EXCEPTION
3848: WHEN NO_DATA_FOUND THEN