APPS.HR_GBNIDIR dependencies on PAY_USER_TABLES

Line 1181: , pay_user_tables TAB

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)
1185: = fnd_number.canonical_to_number(p_user_value)

Line 1217: , pay_user_tables TAB

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
1221: and CINST.user_column_id = C.user_column_id

Line 1260: , pay_user_tables TAB

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'
1264: and LABEL.value = p_label

Line 1297: , pay_user_tables TAB

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
1301: and CINST.user_column_id = C.user_column_id

Line 1333: , pay_user_tables TAB

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
1337: and CINST.user_column_id = C.user_column_id