eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_GBNIDIR dependencies on PAY_USER_COLUMNS

Line 1103: , pay_user_columns C

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
1107: and C.user_column_name = p_user_column

Line 1138: , pay_user_columns CLABEL

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
1142: where TAB.user_table_name = p_user_table

Line 1139: , pay_user_columns C

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
1142: where TAB.user_table_name = p_user_table
1143: and C.user_column_name = p_user_column

Line 1182: , pay_user_columns CLABEL

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
1186: and R.user_table_id = TAB.user_table_id

Line 1218: , pay_user_columns CLABEL

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
1222: where upper(TAB.user_table_name) = 'NI_ERS_WEEKLY'

Line 1219: , pay_user_columns C

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
1222: where upper(TAB.user_table_name) = 'NI_ERS_WEEKLY'
1223: and C.user_column_name = 'C_ERS_RATE_CO'

Line 1254: , pay_user_columns CLABEL

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
1258: where upper(TAB.user_table_name) = 'NI_ERS_WEEKLY'

Line 1255: , pay_user_columns C

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
1258: where upper(TAB.user_table_name) = 'NI_ERS_WEEKLY'
1259: and C.user_column_name = 'C_ERS_RATE_CM'