APPS.HR_GBNIDIR dependencies on PAY_USER_ROWS

Line 1180: , pay_user_rows R

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
1183: and C.user_column_name = p_user_column
1184: and fnd_number.canonical_to_number(CINST.value)

Line 1216: , pay_user_rows R

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
1218: where TAB.user_table_name = p_user_table
1219: and C.user_column_name = p_user_column
1220: and C.user_table_id = TAB.user_table_id

Line 1259: , pay_user_rows R

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
1262: and R.user_table_id = TAB.user_table_id
1263: and TAB.user_key_units = 'N'

Line 1296: , pay_user_rows R

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
1298: where upper(TAB.user_table_name) = 'NI_ERS_WEEKLY'
1299: and C.user_column_name = 'C_ERS_RATE_CO'
1300: and C.user_table_id = TAB.user_table_id

Line 1332: , pay_user_rows R

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
1334: where upper(TAB.user_table_name) = 'NI_ERS_WEEKLY'
1335: and C.user_column_name = 'C_ERS_RATE_CM'
1336: and C.user_table_id = TAB.user_table_id