DBA Data[Home] [Help]

APPS.HR_GBNICAR dependencies on PAY_USER_COLUMNS

Line 332: pay_user_columns col,

328: cp_mileage_factor IN NUMBER,
329: cp_date IN DATE) is
330: SELECT puc.value
331: FROM pay_user_column_instances_f puc,
332: pay_user_columns col,
333: pay_user_rows_f ur,
334: pay_user_tables tab
335: WHERE tab.user_table_id = col.user_table_id
336: AND col.user_column_id = puc.user_column_id

Line 349: pay_user_columns col,

345: 2,'CAR_2_OVER_4','CAR_2_UNDER_4'))
346: --MILEAGE BAND
347: AND ur.user_row_id = (SELECT ur.user_row_id
348: FROM pay_user_column_instances_f puc,
349: pay_user_columns col,
350: pay_user_tables tab,
351: pay_user_rows_f ur
352: WHERE col.user_table_id = tab.user_table_id
353: AND col.user_column_id = puc.user_column_id