DBA Data[Home] [Help]

APPS.PSB_FLEX_MAPPING_PVT dependencies on FND_ID_FLEX_SEGMENTS

Line 1108: fnd_id_flex_segments seg

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
1111: and map.flex_value_id = fval.flex_value_id(+)
1112: and map.from_flex_value_id = fromval.flex_value_id

Line 1136: fnd_id_flex_segments seg

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
1139: and map.from_flex_value_id = fval.flex_value_id
1140: and seg.application_id = 101

Line 1150: fnd_id_flex_segments seg

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
1153: and map.from_flex_value_id = fval.flex_value_id
1154: and seg.application_id = 101

Line 1166: fnd_id_flex_segments seg

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
1169: and map.from_flex_value_id = fval.flex_value_id
1170: and seg.application_id = 101

Line 1452: fnd_id_flex_segments seg

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
1455: and map.flex_value_id = fval.flex_value_id(+)
1456: and map.from_flex_value_id = fromval.flex_value_id

Line 1479: fnd_id_flex_segments seg

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
1482: and map.from_flex_value_id = fval.flex_value_id
1483: and seg.application_id = 101

Line 1672: from fnd_id_flex_segments

1668: ) IS
1669:
1670: cursor c_seginfo is
1671: select application_column_name,segment_num
1672: from fnd_id_flex_segments
1673: where application_id = 101
1674: and id_flex_code = 'GL#'
1675: and id_flex_num = p_flex_code
1676: and enabled_flag = 'Y'