1174: --
1175: -- initialize flag that indicates a valid value entered
1176: -- l_valid := 0;
1177: select nvl(max(1),0) into l_valid
1178: from pay_user_column_instances CINST
1179: , pay_user_columns C
1180: , pay_user_rows R
1181: , pay_user_tables TAB
1182: where TAB.user_table_name = p_user_table
1208: Begin
1209: l_value := 0;
1210: begin
1211: select fnd_number.canonical_to_number(CINST.value) into l_value from
1212: pay_user_column_instances CINST
1213: , pay_user_column_instances LABEL
1214: , pay_user_columns CLABEL
1215: , pay_user_columns C
1216: , pay_user_rows R
1209: l_value := 0;
1210: begin
1211: select fnd_number.canonical_to_number(CINST.value) into l_value from
1212: pay_user_column_instances CINST
1213: , pay_user_column_instances LABEL
1214: , pay_user_columns CLABEL
1215: , pay_user_columns C
1216: , pay_user_rows R
1217: , pay_user_tables TAB
1253: select decode(substr(p_high_or_low,1,1),
1254: 'H',fnd_number.canonical_to_number(R.ROW_HIGH_RANGE),
1255: fnd_number.canonical_to_number(R.row_low_range_or_name))
1256: into l_value from
1257: pay_user_column_instances LABEL
1258: , pay_user_columns CLABEL
1259: , pay_user_rows R
1260: , pay_user_tables TAB
1261: where TAB.user_table_name = p_user_table
1288: l_value := 0;
1289: --
1290: select min(fnd_number.canonical_to_number(CINST.value))
1291: into l_value from
1292: pay_user_column_instances CINST
1293: , pay_user_column_instances LABEL
1294: , pay_user_columns CLABEL
1295: , pay_user_columns C
1296: , pay_user_rows R
1289: --
1290: select min(fnd_number.canonical_to_number(CINST.value))
1291: into l_value from
1292: pay_user_column_instances CINST
1293: , pay_user_column_instances LABEL
1294: , pay_user_columns CLABEL
1295: , pay_user_columns C
1296: , pay_user_rows R
1297: , pay_user_tables TAB
1324: l_value := 0;
1325: --
1326: select min(fnd_number.canonical_to_number(CINST.value))
1327: into l_value from
1328: pay_user_column_instances CINST
1329: , pay_user_column_instances LABEL
1330: , pay_user_columns CLABEL
1331: , pay_user_columns C
1332: , pay_user_rows R
1325: --
1326: select min(fnd_number.canonical_to_number(CINST.value))
1327: into l_value from
1328: pay_user_column_instances CINST
1329: , pay_user_column_instances LABEL
1330: , pay_user_columns CLABEL
1331: , pay_user_columns C
1332: , pay_user_rows R
1333: , pay_user_tables TAB