APPS.HR_GBNIDIR dependencies on PAY_USER_COLUMN_INSTANCES

Line 1102: from pay_user_column_instances CINST

1098: --
1099: -- initialize flag that indicates a valid value entered
1100: -- l_valid := 0;
1101: select nvl(max(1),0) into l_valid
1102: from pay_user_column_instances CINST
1103: , pay_user_columns C
1104: , pay_user_rows R
1105: , pay_user_tables TAB
1106: where TAB.user_table_name = p_user_table

Line 1136: pay_user_column_instances CINST

1132: Begin
1133: l_value := 0;
1134: begin
1135: select fnd_number.canonical_to_number(CINST.value) into l_value from
1136: pay_user_column_instances CINST
1137: , pay_user_column_instances LABEL
1138: , pay_user_columns CLABEL
1139: , pay_user_columns C
1140: , pay_user_rows R

Line 1137: , pay_user_column_instances LABEL

1133: l_value := 0;
1134: begin
1135: select fnd_number.canonical_to_number(CINST.value) into l_value from
1136: pay_user_column_instances CINST
1137: , pay_user_column_instances LABEL
1138: , pay_user_columns CLABEL
1139: , pay_user_columns C
1140: , pay_user_rows R
1141: , pay_user_tables TAB

Line 1181: pay_user_column_instances LABEL

1177: select decode(substr(p_high_or_low,1,1),
1178: 'H',fnd_number.canonical_to_number(R.ROW_HIGH_RANGE),
1179: fnd_number.canonical_to_number(R.row_low_range_or_name))
1180: into l_value from
1181: pay_user_column_instances LABEL
1182: , pay_user_columns CLABEL
1183: , pay_user_rows R
1184: , pay_user_tables TAB
1185: where TAB.user_table_name = p_user_table

Line 1216: pay_user_column_instances CINST

1212: l_value := 0;
1213: --
1214: select min(fnd_number.canonical_to_number(CINST.value))
1215: into l_value from
1216: pay_user_column_instances CINST
1217: , pay_user_column_instances LABEL
1218: , pay_user_columns CLABEL
1219: , pay_user_columns C
1220: , pay_user_rows R

Line 1217: , pay_user_column_instances LABEL

1213: --
1214: select min(fnd_number.canonical_to_number(CINST.value))
1215: into l_value from
1216: pay_user_column_instances CINST
1217: , pay_user_column_instances LABEL
1218: , pay_user_columns CLABEL
1219: , pay_user_columns C
1220: , pay_user_rows R
1221: , pay_user_tables TAB

Line 1252: pay_user_column_instances CINST

1248: l_value := 0;
1249: --
1250: select min(fnd_number.canonical_to_number(CINST.value))
1251: into l_value from
1252: pay_user_column_instances CINST
1253: , pay_user_column_instances LABEL
1254: , pay_user_columns CLABEL
1255: , pay_user_columns C
1256: , pay_user_rows R

Line 1253: , pay_user_column_instances LABEL

1249: --
1250: select min(fnd_number.canonical_to_number(CINST.value))
1251: into l_value from
1252: pay_user_column_instances CINST
1253: , pay_user_column_instances LABEL
1254: , pay_user_columns CLABEL
1255: , pay_user_columns C
1256: , pay_user_rows R
1257: , pay_user_tables TAB