APPS.PSB_FLEX_MAPPING_PVT dependencies on FND_FLEX_VALUES_VL

Line 1105: from fnd_flex_values_vl fval,

1101: -- otherwise, null from value will do ... pass segment num
1102: cursor c_seginfo_subs is
1103: select fval.flex_value to_val ,
1104: fromval.flex_value from_val
1105: from fnd_flex_values_vl fval,
1106: fnd_flex_values_vl fromval,
1107: psb_flex_mapping_set_values map,
1108: fnd_id_flex_segments seg
1109: where flex_mapping_set_id = p_flexfield_mapping_set_id

Line 1106: fnd_flex_values_vl fromval,

1102: cursor c_seginfo_subs is
1103: select fval.flex_value to_val ,
1104: fromval.flex_value from_val
1105: from fnd_flex_values_vl fval,
1106: fnd_flex_values_vl fromval,
1107: psb_flex_mapping_set_values map,
1108: fnd_id_flex_segments seg
1109: where flex_mapping_set_id = p_flexfield_mapping_set_id
1110: and budget_year_type_id = p_budget_year_type_id

Line 1134: from fnd_flex_values_vl fval,

1130:
1131: -- cursor for worksheet mapping_mode - uses from value
1132: cursor c_seginfo_ws is
1133: select fval.flex_value from_val , seg.application_column_name
1134: from fnd_flex_values_vl fval,
1135: psb_flex_mapping_set_values map,
1136: fnd_id_flex_segments seg
1137: where flex_mapping_set_id = p_flexfield_mapping_set_id
1138: and budget_year_type_id = l_cy_budget_year_type_id

Line 1148: from fnd_flex_values_vl fval,

1144: and seg.application_column_name = map.application_column_name ;
1145:
1146: cursor c_cy is
1147: select fval.flex_value curr_val
1148: from fnd_flex_values_vl fval,
1149: psb_flex_mapping_set_values map,
1150: fnd_id_flex_segments seg
1151: where flex_mapping_set_id = p_flexfield_mapping_set_id
1152: and budget_year_type_id = l_cy_budget_year_type_id

Line 1164: from fnd_flex_values_vl fval,

1160: ;
1161:
1162: cursor c_py is
1163: select fval.flex_value curr_val
1164: from fnd_flex_values_vl fval,
1165: psb_flex_mapping_set_values map,
1166: fnd_id_flex_segments seg
1167: where flex_mapping_set_id = p_flexfield_mapping_set_id
1168: and budget_year_type_id = l_py_budget_year_type_id

Line 1449: from fnd_flex_values_vl fval,

1445:
1446: cursor c_seginfo_subs is
1447: select fval.flex_value to_val ,
1448: fromval.flex_value from_val
1449: from fnd_flex_values_vl fval,
1450: fnd_flex_values_vl fromval,
1451: psb_flex_mapping_set_values map,
1452: fnd_id_flex_segments seg
1453: where flex_mapping_set_id = p_flexfield_mapping_set_id

Line 1450: fnd_flex_values_vl fromval,

1446: cursor c_seginfo_subs is
1447: select fval.flex_value to_val ,
1448: fromval.flex_value from_val
1449: from fnd_flex_values_vl fval,
1450: fnd_flex_values_vl fromval,
1451: psb_flex_mapping_set_values map,
1452: fnd_id_flex_segments seg
1453: where flex_mapping_set_id = p_flexfield_mapping_set_id
1454: and budget_year_type_id = p_budget_year_type_id

Line 1477: from fnd_flex_values_vl fval,

1473: -- null from value so it will be read first when first rec is read.
1474:
1475: cursor c_cy is
1476: select fval.flex_value curr_val
1477: from fnd_flex_values_vl fval,
1478: psb_flex_mapping_set_values map,
1479: fnd_id_flex_segments seg
1480: where flex_mapping_set_id = p_flexfield_mapping_set_id
1481: and budget_year_type_id = l_cy_budget_year_type_id